SAP BW/BI 7.3 Online Training Course

Duration: 3 – 4 Weeks

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

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

• 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

Key Features of BW 7.3 are

• Hybrid providers
• Graphical Dataflow modeler
• Accelerated data loads
• Semantic partitioning objects
• Integrated planning front-end Analytical indexes