SAP BW online training

SAP BW online training
SAP BW Online training

If you searching for a good online training institution for SAP BW. Finally, you found the right team to associate with your entire training period. We, here at Aurora online training provides best SAP BW online training.

Why Aurora only?

Like many other we don’t say, “we are the best in this…and that bla..bla “. Just make this simple and straightforward.

  1. Real – time training experience- In our SAP Business Intelligence online training program we make you learn the things as it is what is there in live environment.
  2. Recording sessions of class- After completion of each live class, we provide the recording sessions. So, you can use it for forever in your lifetime as SAP business warehouse tutorials.
  3. In Depth knowledge in SAP BEX reporting.
  4. Learning SAP BW without ABAP is useless. We will provide this required ABAP knowledge. It doesn’t matter, if you no prior knowledge in ABAP.


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 –
  • 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
  • InfoObjects
  • InfoProviders
  • InfoCubes
  • Data Store Objects
  • Multi providers
  • Virtual info providers
  • Info sets
  • Semantically partitioned IC/DSO
  • Transformations
  • Start routine
  • End routine
  • Expert routine
  • Field level routine
  • Different rule types
  • DTPs

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.)
  •  RRI
  •  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
  • Partitioning
  • 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)


Where we are?

We are on online; we offer this SAP BW online training for people across the world. We had taught people in US, UK, London, Canada, India, Singapore, Netherlands, Washington, Hyderabad, Bangalore, Malaysia and many other countries/cities.