Duration:
2 Hours/day – 1 Hour Theory, 1 Hour Practical
4 Hours/day – 2 Hours Theory, 2 hours Practical
Course Content:
Enterprise Structure
- Introduction to ERP, SAP, Data Warehouse
 - Overview of BW, BI, Data Base
 - Overview of BW Architecture, Landscape
 
Business Modeling
- Info Area
 - Info Object Catalogs
 - Info Objects
 - PSA
 - Application Component
 - Info Source
 - Data Source
 - Transfer Rules
 - Update Rules
 - Transfer Structure
 - Communication Structure
 - Info Package
 - Transformation
 - Data Transfer Process
 
Routines
- Start Routine
 - End Routine
 - Expert Routine
 
DTP (Data Transfer Process)
- Standard DSO
 - Write optimized DSO
 - Direct update DSO
 - APD (Analysis Process & Design)
 
DSO (Data Store Object)
- Standard DSO
 - Write optimized DSO
 - Direct update DSO
 - APD (Analysis Process & Design)
 
Update Methods
- Full updates
 - Initialization
 - Delta Updates
 
Info Providers
- Multi Providers
 - Info set
 - Virtual Providers
 
Info Cube Maintenance
- Aggregates
 - Roll-up
 - Compression
 - Reconstruction
 
Process Management
- Process Chains, Process Types
 - Scheduling
 - Monitor (Header, Status, Details)
 
Reporting : Business Explorer
- BEX Query designer
 - BEX Analyzer
 - BEX WAD
 - BEX Report Designer
 - Visual Composer
 
Functional Overview of Bex Query Designer
- Reusable Query Elements
 - Query Controls with Variables
 - Calculated Key Figures
 - Restricted Key Figures
 - Formulae
 - Structures
 
Variable Definition in Detail
- Characteristic values variables
 - Text Variables
 - Formula Variables
 - Hierarchy Variable
 
Analysis Functions
- Conditions
 - Exceptions
 
Reporting Drilldown
- Drilldown to DSO from Info Cube (RRI)
 - Copying Queries from Cubes
 
Bex Analyzer
Bex WAD
Bex Report Designer Visual Composer
- Migration Objects from BW 3.x to BI 7.0 Transportation
 
Extraction
- Generic Data Extraction using MD/TD Tables
 - COPA Extraction
 - Business Content Extractions using MD/TD
 - LO-COCKPIT Data Extraction
 
Delta types for
- Generic Extraction
 - LO Extraction
 
