Introduction to OLAP systems

Need of OLAP systems

Benefits of OLAP systems

Different types of OLAP systems

Introduction to Business Objects

  • Architecture of SAP- Business Object XIR3.1/4.0
  • ODBC connectivity between different types of Databases and SAP-BOE

Universe Design using SAP-BOXIR3.1/R4.0 UDT (Universe Designer Tool)

Working with quick design and manual design mode.

  • Enterprise mode (CMS)
  • Stand alone mode (No CMS)

 Connection type:

  • Secured
  • Shared
  • Personal

Working with tables, views and synonyms

Design universe diagram:

  • Identification of table types,
  • Joins (inner, left outer, right outer )
  • Data type conversion on join conditions
  • Cardinality creation
  • Table Derivation from same type of tables using Union Operator
  • Detection of the loops in Universe
  • Loops resolving for avoid Chesm traps, Fan Traps:
    • Creation of Aliases
  • Creation of Contexts based on   reporting requirements
    • Creation of Shortcut joins

Creation of Classes and objects:

  • Define the classes for end user requirements
  • Creation of objects
    • Dimensions for Analysis
    • Details with associate Dimensions
    • Measures at detail level and summarized level
  • Global filters creation at Universe Level
  • Working with standalone filters
  • @Aggregate awareness for same type of measures
  • @concatenation function creation
  • @measure function using Measure objects
  • Aggregate Navigation for Incompatible Objects

Custom Hierarchies for scope of Analysis

Check Integrity

Working with LOV’s

Working with cascading LOV’s

Organize the connections

Working with derived tables

Working with universe linking

Desktop Intelligence:

Introduction to query panel

Request generation in query panel

Local filter creation at reporting level using List of Values

Cascading filters using Logical Operators like AND, OR

Reports generation:

Ad-hoc reports

Standard reports

Two-dimensional reports

Multidimensional reports

  • List reports: Horizontal reports, vertical reports
  • Breaks creation on list reports
  • Master-Detail reports
  • Chart reports

Line chart, bar chart, pie-chart, etc.

  • Cross-tab reports
  • Group reports
  • Defining Rank on report
  • Assign Filter on report
  • Assign alert on report
  • Variables Creation at report level

Slices and dices:

Analysis of business user requirements

Generation of reporting requirements

  • Saving reports in different formats: HTML, PDF, Excel, MS Word
  • Generate the using predefined templates, user defined templates
  • Generate the reports using predefined sql without developing model
  • Generate the reports directly from the flat files, Excel sheets
  • Formatting the reports
  • Internal process explanation at server level

Drilling Analysis:

  • Drill through, drill down, drill up, and drill by

Post production of the report

Introduction to web intelligence rich client:

  • Generate different types of reports same as like desktop intelligence

Introduction to Java Info view or BI Launch Pad

  • Generate different types of reports using web intelligence document same as like desktop Intelligence
  • Saving Request for end user analysis for one click actions or saving report on PC

Dashboard Reports for multiple requirements

  • My Dashboards
  • Corporate Dashboards
  • Creation of tabs for multiple Dashboards
  • Dashboards using free form, docking, predefined templates.
  • Post production of the reports
  • Working with crystal reports enterprise.

Crystal Reports:

  • Introduction to Crystal Reports
  • Working with different data sources like Oracle, MS-Access,, Excel, etc
  • Explanation on Design view
  • Report header
  • Page header
  • Page detail
  • Report footer
  • Page footer
  • Selection of the Database
  • Define relationship between tables
  • Report generation

Blank report:

  • List report, cross tab report, chart reports

Report wizard:

  • List report, cross tab report, chart reports

Cross tab wizard:

  • Cross tab reports
  • Chart reports: Line chart, Bar chart, Pie-chart

Mailing Label wizard

OLAP cube report wizard

Organizing the report:

  • Adding filters, sorting the data, grouping the data
  • Cascading filters creation using logical operators
  • Chart reports: Line chart, Bar chart, Pie-chart

work shop

  • Formulas creation
  • SQL Expression Development
  • Parameters Creation (static, dynamic)
  • Special field’s utilization
  • Woking with alerters
  • Saving reports in different formats like PDF, HTML, Excel Sheet, etc.
  • Generates the reports from Business Objects environment
  • Export Crystal Reports To Java Infoview


  • Introduction to Xcelcius
  • Generate the reports in different types of the chart formats using Excel sheet data
  • Generate Flash player repots using Shock wave flash player (SWF) for analysis
  • Chart reports using dimensions and measures
  • Line chart, bar chart, pie-chart, 3d-chart, etc.
  • Formatting the reports in different styles
  • Defining the ranges for labels
  • Creation of the container for multiple requests
  • Creation of tabs on containers.
  • Generate the requests for containers
  • Post production of the reports

Project Explanation with real time requirements

  • Development of business requirements specifications(BRS)
  • Development of reporting requirement specifications(RRS)
  • Working with Live Office in Excel sheet from Crystal Reports and Web intelligent Reports in Xcelcius
  • Generate reports in MS-Office tools using Live Office.

SAP Integration:

  • Connect BO administrator to SAP BIW.
  • Import dimensions and key figures to BOE.
  • Create Global filters in Universe Designer.
  • Introduction to Java Infoview.
  • Generate reports from Web Intelligent Document.
  • Generate reports from Web Rich client
  • Introduction to Analytics.
  • Query Scheduling and Optimization.
  • Introduction to Corporate Analytics.
  • Develop my Dashboards and Corporate Dashboards.
  • Integrate SAP BIW with Crystal Reports.
  • Develop Cross Tab Reports and Chart Reports.
  • Working with analytics
  • Working with central management console (CMC)
  • create users and user groups
  • set privileges to the users
  • create servers and administer them
  • Working with CCM( central configuration managers)
  • Introduction to Business View Manager.
  • Introduction to Query as a Web service.
  • Working with crystal reports enterprise