SAP BW

Week 1

  • Introduction to Data Warehousing
  • Multidimensional Modeling
  • BW Architecture
  • Extended Star Schema
  • Introduction to BW Objects and Administrative Work Bench
  • Introduction to Characteristics and Key Figures
  • Texts Attributes Hierarchies for Master Data
  • Data Flow in BW( Info sources/Data Source)
  • Introduction to different Info Providers ( Cubes/ODS etc)
  • Loading Data to a Data Target through flat files
  • Meta data repository.

Week 2

  • Extraction of data from R/3 system
  • Concept of Delta Queue
  • Introduction to different Delta Types in R/3
  • Debugging Extraction and Concept of Data Source in R.3
  • Extraction using Generic Extraction (Table/View/Info set/ FM)
  • Extraction from FI(GL/AP)
  • Extraction of COPA Data
  • Logistics Data Extraction (SD/MM)
  • Extraction Performance Tuning Techniques
  • BW Customization

Week 3

  • Introduction to Business Explorer
  • Understanding Bex Browser, Bex Query Designer, Bex Web Application Server
  • Advance Reporting/Web Reporting Techniques
  • Introduction to Reporting Agent (Precalculation)
  • Overview of Reporting Authorization Objects and their Usage in Security
  • Performance Techniques for queries by using Aggregates. OLAP cache
  • Debugging queries using RSRT Tcode
  • Open HUB

Week 4

  • Introduction to Multi providers , Info set and Master Data Reporting
  • Introduction to Process Chains for optimal data load scheduling
  • Overview and Introduction of Metadata Repository
  • Business child_list usage and Object Version
  • Introduction to the concept of delta for data loading process
  • Transport Methodology
  • Performance tuning( Aggregates , Compression etc)
  • Real time scenarios.

At the end of the course you will get good expertise in below areas:

  • Data modeling.
  • Extraction techniques and creating data targets.
  • BEx reporting
  • Data scheduling with Process chains
  • Performance tuning