SAP BW Online Training
SAP BW Course Curriculum

   Week 1

  • Introduction to Data Warehousing
  • Multidimensional Modeling
  • BW Architecture
  • Extended Star Schema
  • Introduction to BW Objects & 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

  • Intro. to Multi providers, Info set & Master Data Reporting
  • Intro. to Process Chains for optimal data load scheduling
  • Overview and Introduction of Metadata Repository
  • Business Content usage and Object Version
  • Intro. 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

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