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
• Direct update DSO

Update Methods

• Full updates
• Initialization
• Delta Updates

Info Providers

• Multi Providers
• Info set
• Virtual Providers
• Re-Modeling
• Re-Partitioning

Info Cube Maintenance

• Aggregates
• Roll-up
• Compression
• Reconstruction