SAP BI/BW
SAP BI/BW BY Mr.DURGA PRASAD, with 5+ years of exp.,
20:54SAP BI/BW
SAP BI/BW BY Mr.DURGA PRASAD, with 5+ years of exp.,
Duration:2 months
Fee: 10000/- classroom: 25000/- online training
Enterprise Structure
Introduction to ERP, SAP, Data Warehouse
Overview of BW, BI, Data Base.
Overview of BW Architecture, Landscape
Basic Modeling
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
Business Modeling
1. Info Area
2. Info Object Catalogs
3. Info Objects
4. PSA
5. Application Component
6. Info Source
7. Data Source
8. Transfer Rules
9. Update Rules
10. Transfer Structure
11. Communication Structure
12. Info Package
13. Transformation
14. 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
Routines:-
1. Start Routine
2. End Routine
3. 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
1 Full updates
2 Initialization
3 Delta Updates
Info Providers
1 Multi Providers
2 Info set
3. Virtual Providers
· Re-Modeling
· Re-Partitioning
Open-Hub Destination
Data Marts
Info Cube Maintenance
· Aggregates
· Roll-up
· Compression
Reconstruction
Process Management
1 Process Chains, Process Types
2 Scheduling
3 Monitor (Header, Status, Details)
Business Content
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
· Structures
Variable Definition in Detail
· Characteristic values variables
· Text Variables
· Formula Variables
Hierarchy Variable
Analysis Functions
· Conditions
· Exceptions
· New Selections
· New Formulae
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
· Business Content Extractions using MD/TD MM and FI
· COPA Extraction->CO
Delta types for
· Generic Extraction
· LO Extraction->SDwww.pragna.info
0 comments