Introduction
- 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 Star Schema (Classical Approach)
- Multi-Dimensional Star Schema in BW (Extended star Schema)
- The OLAP Concept and 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 , Rule types
Routines
- Start Routine
- End Routine
- Expert Routine
DTP (Data Transfer Process)
- Standard DTP
- Error DTP
- Direct Access DTP
- Real time DTP
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
- Re-Modeling
- Re-Partitioning
- Open-Hub Destination
- Data Marts
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
ASAP methodology
|
