SAP BW

    SAP BW - Course Contents

  • 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
  • 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
  • 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
  • Cost Centers
    • Creating and Changing Cost Centers:
    • Cost Centers
    • Cost Center Standard Hierarchy
    • Creating Cost Centers
    • Creating and Changing Activity Types:
    • Activity Types
    • Creating Activity Types
    • Maintaining Statistical Key Figures:
    • Fixed Values and Totals Values
    • Creating Key Figures
  • 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 Content usage and Object Version
    • Introduction to the concept of delta for data loading process
    • Transport Methodology
    • Performance tuning( Aggregates , Compression etc)
    • Real time scenarios.

QUICK ENQUIRY