BO

Data warehousing/Dimensional modeling/ SAP BW 7.0 Concepts

• OLTP vs. OLAP
• Types of OLAP
• Multi Dimensional Modeling Of SAP BW 7.0
• SAP BW 7.0 Cubes, DSO’s ,Multi Providers, Infosets
• Business Explorer (Bex) Queries in BW 7.0 system as Data sources
• Data Flow in BW 7.0 and Activating Business Content Cube.

For who doesn’t have SAP BI background above topics can be covered
Database Concepts needed for Data warehousing

• Joins & Cardinality
• Views/Materialized Views
• Date/Time Functions

BOXI 4.0 Architecture

• Architectural overview
• Client tier components
• Application tier components
• Intelligence tier
• Processing tier
• Data tier
• Security management
• Information

Information Design Tool (Universe Designer)

• Understanding Business Objects Universes
• Creating the Course Universe
• Building the Universe Structure
• Creating Dimension Objects
• Creating Measure Objects
• Resolving Loops in a Universe
• Resolving SQL Traps
• Using List of Values
• Applying Restrictions on Objects
• Using @Functions with Objects
• Using Hierarchies
• Deriving Tables & Indexes
• Working with Aggregate Awareness
• Designing Advanced Objects
• Creating Predefined Condition
• LOVs & Joins
• Securing Universes
• Implementing Universe Life Cycle Mgmt
• Maintaining & Optimizing Universes
• Creating Universe from Other Data sources

Web intelligence

• Understand concepts of Web intelligence
• Create Web Intelligence documents with Queries
• Restrict data returned by a query
• Design a report
• Enhance the presentation of data in reports
• Creation of Web intelligence report with auto scheduling
• Creation of Corporate dashboard for Supply chain mgmt/Banking Domain
• Format a report
• Calculate data with formulas and variables
• Use multiple data sources
• Analyze data
• Manage and share Web Intelligence documents
• Work with Advanced Query techniques
• Work with calculation contexts
• Create formulas with character & date string functions
• Use “If” logic
• Work with additional reporting techniques
• Create hyperlinks

Crystal Reports 2011

• Planning a Report
• Selecting Records
• Formatting a Report
• Representing Data Visually
• Distributing Reports
• Creating Basic Formulas
• Organizing Data on a Report
• Applying Section Formatting
• Applying Conditional Reporting
• Using the Repository
• Using Report Templates
• Creating Formulas
• Building Parameterized Reports
• Summarizing Data with Cross-Tabs
• Using Report Sections
• Managing Reports
• Presenting Data Visually
• Add hyperlinks to a report

Dashboard Design Tool

• Creating a Model
• Adding Interactivity to a Model
• Creating a Connected Model
• Connect to Crystal Reports data and create Dashboard
• Connect to Web intelligence report data and
• Create Dashboard
• Connect to Business Objects Universes
• Using Query as a web service and create Dashboard
• Use Live Office data and create Dashboard
• Use other connectivity components and create Dashboard

Webi-rich Client

• Installing Web Intelligence Rich Client
• Web Intelligence Rich Client working modes
• Launching Web Intelligence Rich Client
• To set user preferences in Web Intelligence Rich Client
• Working with documents
• Working with universes in Web Intelligence Rich Client
• Accessing Web Intelligence from Info View
• Working with queries in Web Intelligence Rich Client
• Working with reports

Universe Builder & Query Builder

• Universe Builder basics
• Building universes from XML metadata sources
• Updating XML metadata source universes
• Exporting a universe to a XML file format

OLAP Universe

• Creation of OLAP Universe by connecting to an Info cube
• Updating the OLAP Universe (Cube)
• Creating the Custom Hierarchies in OLAP Universes.
• Accessing multiple info cubes to create an OLAP Universe

Live Office Reporting

• Describe the benefits of using Live Office
• Connect to the repository
• Navigate the Live Office menu
• Insert charts, crosstabs, and fields from a Crystal report
• Insert report parts from a Web Intelligence document
• Insert a new query based on a Universe
• Insert Live Office objects into an email
• Navigate and refresh Live Office objects
• Enable consolidated prompts
• Set refresh settings for objects
• Set parameter binding
• Take a snapshot
• Save Live Office documents to the repository
• Open and view Live Office documents from the repository

SAP Webi/Dashboard Reporting

• Creation of Web intelligence reports using Info cube & BW Query