SAP BW Course

SAP

SAP – BW COURSE CONTENT

• 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