BW

1. What is BW ?

1.1. Definition :

1.1.1. SAP Business Data warehouse

1.1.1.1. Infrastructure typical of DWH

1.1.1.2. Data Integration – Extract, Transform, Load

1.1.1.3. MultiDimension Model

1.2. Advance Features:

1.2.1. Preconfigured data extractors

1.2.1.1. BI Content

1.2.1.1.1. Metadata following ETL process (including reporting)

1.2.2. Analysis and report tools

1.2.2.1. BEx (Business Explorer)

1.2.2.1.1. Bex Browser

1.2.2.1.2. Bex Analyzer

2. How does it works ?

2.1. 3 Layers architecture

2.1.1. Source System

2.1.2. Data warehouse

2.1.3. Reporting

2.2. Data Warehousing Workbench Tool

2.2.1. Tcode RSA1

2.2.2. Central tool for BW Modelling, Schedule and Monitor

2.3. Exercise 1: Getting started with BW. (flat file source)

2.4. BW data flow

2.4.1. Data Source

2.4.2. InfoPackage

2.4.3. PSA

2.4.4. DTP

2.4.5. Info Provider

2.4.5.1. DSO

2.4.5.2. InfoCube

2.5. Exercise 2: Work with BI Content

3. Practice with BW

3.1. Scenario

3.2. Analysis

3.3. Implement

4. Administrator

4.1. Delta management

4.2. Data target management

4.3. Transport

4.4. Process Chain

4.5. Performance optimize

4.6. Authorization

5. Standardisation

5.1. LSA

5.2. LSA ++

6. Advanced Tasks

6.1. Load data from customized Data source

6.2. Real-Time Data Acquisition