SAP BI / BW - Business Intelligence

This course will give you knowledge that you can use to create simple and complex query definitions using the BEx Query Designer. Also BEx Web Analyzer to make them available in standard layouts.


1. Basic knowledge of Data Warehousing
2. Experience in any SAP component

Course Highlights

1. Introduction

  • General Introduction.
  • SAP introduction.
  • Data warehousing/ BW/ BI Introduction.
  • Master data; Attributes, Texts, and Hierarchies.
  • Standard Naming conventions in SAP and BI.

2. Data Modeling

  • Info Objects: Definitions.
  • o Types: Characteristics, Key Figures, Time, and Unit.
  • Info Cubes: Definitions.
  • o Types: Standards, real time, remote. o Design of Info cube: Star Schema concepts. Precautions.
  • Data Store objects (DSO):.
  • o Types: Standards, Real time.
  • Multi Providers: Scenarios to create Multi providers.
  • Info cube VS DSO.

3. Metadata and Document Management

  • BI Content: Definitions, How to install BI contents.

4. Defining extraction

  • For SAP source systems: Creating Generic data Source and maintaining SAP delivered data Source.
  • Or for files: Creating Data Sources for File Source Systems.

5. Defining transformations

  • Transformations and different scenarios.

6. Defining the data flow:

  • Creating data transfer processes.
  • Creating process chains.

7. Scheduling and monitoring:

  • Checking process chain runs.
  • Monitor for extraction processes and data transfer processes.

8. Performance optimization:

  • Creating the first aggregate for an InfoCube.
  • Using the BIA index maintenance wizard.

9. User management:

  • Setting up standard authorizations.
  • Defining analysis authorizations.

10. Transports:

  • Real business scenarios on different system environments, Moving objects from one system to another.

BI SUITE: Business Explorer

1. BEx Query Designer

  • Queries: New queries, Restricting Characteristics, Formulas and Exception Cells.
  • Query Design: Defining Exceptions, Conditions, Restricted and Calculated KeyFigures.
  • Variables: The Variable Wizard, Variable Types and Processing Types, query Properties.
  • Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures.
  • Structures: Creating Re-usable structures.
  • Functions on BW Server: Copying queries between Cubes, Deleting Query Elements.

2. Web Application Designer

  • WAD: Functions of WAD, Web Items Window, Template Window, Properties Window.
  • Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and Properties.
  • Design: Designing the Layout of Web Templates, working with Library for Web Items.
  • Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes.

3. Activities

  • BEx Analyzer.
  • BEx Web Application Designer.
  • BEx Report Designer.

4. BI Platform

  • Information Broadcasting.
  • Functions of the Broadcaster: Pre calculating and Exporting into Enterprise Portal.
  • User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings.
  • Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.


  • OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP.
  • OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface.
  • Meta Data Repository: Searching for Meta Data.