SAP BW online training

Request a free demo today


What should you expect to learn?


                OLTP system basics

                OLAP system basics

                OLTP Vs OLAP (differences and complications)

Introduction to Data-Warehousing

                Datawarehousing Concepts

The Extended STAR schema

Introduction to SAP Business Warehouse

                Landscape & Architecture

Building the SAP Business Warehouse

Building Blocks of SAP BW

InfoAreas / InfoObjects / DataSources / PSA / DSOs / InfoCubes / Transformations

Defining your Business Warehouse

Business definition / Identification of Business Data / Defining Business Reports

Start Building – Discuss Why / Where / When / How for each of the items below

Create InfoArea

Create InfoObectCatalogs

Create InfoObjects

Create Datasources (flat file)

Create DSO(s)

Create Cube(s)

Transformations to the InfoProviders

               Master data: Attributes, Text and Hierarchies loading from flat files.

Load Master and Transaction Data from Flat files

Surrogate IDs and Dimension IDs – A discussion

Attribute Change Run

                                Implement Delta mechanism (flat-file to DSO to Cube)

Create a simple Bex report based on the InfoProviders created so far

Explore and Experiment, then Discuss the Building Blocks

                Explore types, options, settings and usage scenarios




Data Store Objects

Multi providers

Virtual info providers

Info sets

Semantically partitioned IC/DSO




Start routine

End routine

Expert routine

Field level routine

Different rule types



Analysis Process designer (APD)      

SAP Modules and their interaction

                Source Systems

                Datasources in the context of source systems

                SAP ECC and ERP an important discussion

SAP Business Content

                Discuss the Business Content objects discovered

                Install Standard objects and activate them

Filling your Data Warehouse with SAP Business Data

                Extract FI data using Standard Extraction

                             FI-SL Extractions

                            COPA Extractions

Master Data Extraction

Transaction Data extraction

                Extract SD data using LOS Extraction

                                Understanding LOS extraction benefits and necessities

LO Cockpit Overview

Data Extraction Full Load and Delta mechanisms

                A note and an exercise on Generic Extraction

                           Using View

                         Using Functional Module

Maintaining your SAP Business Warehouse

                Administering the InfoCubes

                Administering the DSOs

                PSA Maintenance

                Automation: Creating and Monitoring the Process Chains

Explore SAP BW Data

                BEx Query Designer

                Query Design Elements (RKFs, CKFs, Variables, Conditions, Exceptions, Constant selection etc.)


                BEx Analyzer

                Query Monitor (RSRT)

                Build a Complex Report with Trend,forecasting, variables, RKFs and CKFs etc



Performance Optimization

                Understanding Performance Top-Down and Bottom-Up

Investigating Performance – The Approach

Load Performance Optimization

Building it right

Re-building it if required

Query Performance Optimization

BW Aggregates


BW Indexes

Your Eyes and Ears – BI Statistics

Advanced Data Warehousing (Discussion and Debate on usage and pros and cons)

                Study of Internal Structures and their workings

                                Cubes and Dimensions (SIDs, DIMIDs)

                                DSO mechanics (Delta Management with Active, Change-log tables)

                                InfoSets & Virtual Providers

                                Time Dependent Master Data Management

                                Extracting Hierarchies for ECC Sets (GS01, GS02, GS03 etc)