Course contents:
Enterprise Structure:
Introduction to ERP, SAP, Data Warehouse
Overview of BW, BI, Data Base.
Overview of BW Architecture, Landscape
Routines:
Start Routine
End Routine
Expert Routine
DTP (Data Transfer Process):
Standard DTP
Error DTP
Direct Access DTP
Real time DTP
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
Delta Mechanism
Different Types of Attributes
Transformations , Rule types
DSO (Data Store Object):
Standard DSO
Write optimized DSO
Direct update DSO
APD (Analysis Process & Design)
Update Methods
1Fullupdates
2Initialization
3 Delta Updates
2Initialization
3 Delta Updates
Multi-Dimensional Model – The Star Schema (Classical Approach)
Multi-Dimensional Star Schema in BW (Extended star Schema)
The OLAP Concept and differences between OLAP and OLTP
Info Providers:
Multi 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)
Business
Content
Business Explorer:
BEX Query designer
BEX Analyzer
BEX WAD
BEX Report Designer
Functional Overview of Bex Query Designer:
Reporting
Reusable Query Elements
Query Controls with Variables
Calculated Key Figures
Restricted Key Figures
Structures
Variable Definition in Detail:
Characteristic values variables
Text Variables
Formula Variables
Hierarchy Variable
Analysis Functions:
Conditions
Exceptions
New Selections
New Formulae
Real-time Scenarios:
ASAP Methodology
Live Project Explanation Live Project Preparation Live Test Cases
Mock interviews
Interview Questions
Reporting Drilldown:
Drilldown to DSO from Info Cube (RRI)
Drilldown to DSO from Info Cube (RRI)
Copying Queries from Cubes
Bex Analyzer
Bex Report Designer
Migration Objects from BW 3.x to BI 7.0
Transportation
Generic Data Extraction using MD/TD Tables
Business Content Extractions using MD/TD SD,MM and FI
COPA Extraction->CO
Delta types
Generic Extraction
LO Extraction->SD
Data source enhancements
Table level enhancements
BI Content
Universe Designer(SAP/NON SAP)
WEBI
WEBI Rich client
Live Office
Qaws
Import/Publishing Wizard
Voyager
Polestar
CrystalReports
Xcelsius
DesktopIntelligence
Widgets
Business View Manager
CMC
Dashboards/Scorecards
