SAP Bw

MODELING

The Multi-dimensional Model in SAP BW

• The SAP BW Star Schema Concept
• Data warehousing Workbench (DWB)
• Info Objects
• Info Cubes

Data Extraction and Data Flow within SAP BW 7.4 NW 2004S

• 3.x Dataflow
• Overview of BW 7.4 Dataflow
• Comparison of 3.x and BW 7.34 Data flows
• Loading Master Data (Attributes, Texts, Hierarchies)
• Loading Transaction Data

New Data source Concept of BW 7.4

• Overview of new Datasource
• Emulation of Data source in BW 7.4
• Datasource Lifecycle with In BW 7.4 NW 2004S
• Migration of 3.x data source to BW 7.4 data source

Transformation in BW 7.4(ETL)

• In depth coverage of Transformation
• Routines in Transformations (Start routine, End routine, Expert routine, transformation routine) with different Real Time examples
• Transformation Groups
• Unit and currency Conversions

DTP (Data Transfer Process)

• Overview of DTPS
• Trouble shooting techniques in DTPS
• Debugging ABAP routines Using DTPS

UPGRADING DATAFLOWS FROM 3.X TO BW 7.4

Business Content

• Business Content (BCT)

Administration of InfoCubes and Aggregates

• Managing Basic Cubes
• Aggregates
• BI Accelerators

DSO (DATA STORE OBJECTS)

• Data Store Objects concept

Virtual Cubes and Multi Providers

• Virtual Cubes
• Multi Providers

DATA EXTRACTIONS (ETL)

ECC extractions using BW 7.4 Data flows

Overview of ECC6.0 Extractions

• Types of ECC extractions

Generic Extractions.

• Generic Extraction using
• Database Table
• View
• Classical Info sets.
• Functional Module.

Business Content Extractions

• Overview of Business Content Extractions.
• Examples from Financial, Logistics, HRMS modules.

CO-PA Extractions (COST PROFITABLE ANALYSIS)

LO-COCK PIT Extractions (LOGISTICS)

FI-SL Extractions (Financial special purpose ledger)

• SAP CRM extractions.
• Marketing Extractions
• CRM SALES Extractions
• CRM SERVICE Extractions (CRM Extractions are Very High in demand)

Delta Management

Extracting Master Data from CC (Attributes, Text, Hierarchies)

Datasource Enhancement

Process Chains in Detail covering all process Types

• Real time examples on process Chains (Meta Chains)

Upgrading process Chains from 3.x to BI 7.3

APDS (Analysis Process Designers)

REPORTING

Introduction to BI Enterprise Reporting.

• The SAP BI Overview

Navigating in Reports

First Steps in Query Designer

• Query Designer
• Info providers in query Designer

Key Figures

• Restricted Key Figures
• Calculated Key Figures
• Properties of Key Figures
• Structures and cells

CHARACTERSTICS

• Properties and Attributes of Characteristics
• Integrating attributes and hierarchies in reports.

Attributes

• Characteristic Variables
• Hierarchy variables
• Hierarchy Node variables
• Formula Variables
• Text variables
• Variable Processing types.

Exceptions and Conditions

• Exceptions
• Conditions