- Module One: Enterprise Structure Introduction to ERP
- SAP, Data Warehouse Overview of BW, BI, Data Base.
- Overview of BW Architecture, Landscape Basic Modeling:
- Create a valid Schema Multi-Dimensional Model – The Star
- Schema (Classical Approach) Multi-Dimensional Star
- Schema in
- BW (Extended star Schema) The OLAP Concept
- Differences between OLAP and OLTP 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
- Loading Transactional Data into BW info Cube Loading MD
- with TD into BW System BW and BI Comparisons Master
- data loading-new(BI) ETL process
- Info cube & Types
- Standard Info cube and Loading with new ETL Process
- Generate Report with BI master and Transaction Data
- Manual Uploading of MD like Attributes, Text, Hierarchy
- Different Types of Attributes Transformations
- Start Routine
- End Routine
- Expert Routine
- Standard DTP
- Error DTP
- Direct Access DTP
- Real time DTP
- Standard DSO
- Write optimized DSO
- Direct update DSO
- APD (Analysis Process & Design)
- Update Methods
- Full updates
- Initialization
- Delta Updates
- Multi Providers
- Info set
- Virtual Providers
- Re-Modeling
- Re-Partitioning
- Open-Hub Destination
- Data Marts
- Aggregates
- Roll-up
- Compression
- Reconstruction
- Process Chains, Process Types
- Scheduling
- Monitor (Header, Status, Details)
- 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
- Formulas
- Structures
- Variable Definition in Detail
- Characteristic values variables
- Text Variables
- Formula Variables
- Hierarchy Variable
- 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
- ASAP methodology