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