SAP BI

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
Info Package
Transformation
Data Transfer Process
Loading Transactional Data into BW info Cube
Loading MD with TD into BW System
Info cube & Types
Manual Uploading of MD like Attributes, Text, Hierarchy
Different Types of Attributes
Transformations.
Routines
Start Routine
End Routine
Expert Routine
DSO (Data Store Object)
Standard DSO
Write optimized DSO
Info Providers
Multi Providers
Info set
Virtual Providers
Re-Modeling
Re-Partitioning
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
Functional Overview of Bex Query Designer
Reusable Query Elements
Calculated Key Figures
Restricted Key Figures
Formulae
Variable Definition in Detail
Characteristic values variables
Text Variables
Formula Variables
Hierarchy Variable
Analysis Functions
Conditions
Exceptions
Reporting Drilldown
BI Course Content
Direct update DSO
Update Methods
Full updates
Initialization
Delta Updates
Drilldown to DSO from Info Cube (RRI)
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
LO-COCKPIT Data Extraction
Delta types for
Generic Extraction
LO Extraction