Find SAP Materials

SAP-BW 3.5 TRAINING MATERIAL MANUAL - Presentation Preview Transcript

Index

Preface
Chapter 1. Business Scenario and SAP BW

1.1. Sales Analysis - A Business Scenario
1.2. Basic Concept of Data Warehousing

1.3. BW - A SAP Data Warehousing Solution
1.4. Summary

Chapter 2. Creating an InfoCube

2.1. Creating an InfoArea

2.2. Creating InfoObject Catalogs

2.3. Creating InfoObjects—Characteristics
2.4. Creating InfoObjects—Key Figures
2.5. Creating an InfoCube 2

2.6. Summary

Chapter 3. Loading Data into the InfoCube

3.1. Creating a Source System

3.2. Creating an Application Component

3.3. Creating an InfoSource for Characteristic Data

3.4. Creating InfoPackages to Load Characteristic Data

3.5. Checking Loaded Characteristic Data

3.6. Entering the Master Data, Text, and Hierarchy Manually
3.7. Creating an InfoSource for Transaction Data

3.8. Creating Update Rules for the InfoCube

3.9. Create an InfoPackage to Load Transaction Data

3.10. Summary

Chapter 4. Checking Data Qualit’

4.1. Checking InfoCube Contents

4.2. Using BW Monitor

4.3. Using the Persistent Staging Area (PSA)
4.4. Summary

Chapter 5. Creating Queries and Workbooks

5.1. Creating a Query Using BEx Analyzer

5.2. Organizing Workbooks Using BEx Browser

5.3. Using a Variable to Access a Hierarchy Node Directly
5.4. Summary

Chapter 6. *anaging User Authorization

6.1. Creating an Authorization Profile Using Profile Generator

6.2. Creating an Authorization Object to Control User Access to the InfoCube Data
6.3. Integrating Profile Generator and BEx Browser

6.4. Summary

Chapter 7. InfoCube Design

7.1. BW Star Schema

7.2. InfoCube Design Altemative I— Time-Dependent Navigational Attributes
7.3. InfoCube Design Altemative 11-Dimension Characteristics

7.4. InfoCube Design Altemative ]]I— Time-Dependent Entire Hierarchies.
7.5. Other InfoCube Design Techniques.

7.6. Summary

Chapter 8. Aggregates and *uIti0Cubes .

8.1. Aggregates
8.2. Multi-Cubes
8.3. Summary

Chapter 9. Operational Data Store (ODS)

9.1. Creating an ODS Object

9.2. Preparing to Load Data into the ODS Object, Then into an InfoCube
9.3. Loading Data into the ODS Object

9.4. Loading Data into the InfoCube

9.5. Using 0RECORDMODE for Delta Load.

9.6. Summary

Chapter 10. Business Content

10.1. Creating an R/3 Source System

10.2. Transferring R/3 Global Settings

10.3. Replicating R/3 DataSources.

10.4. Installing Business Content Objects and Loading R/3 Data
10.5. Summary

Chapter 11. Generic RI3 Data Extraction

11.1. Creating Views in R/3

11.2. Creating DataSources in R/3 and Replicating Them to BW
11.3. Creating a Characteristic in BW

11.4. Loading Data from R/3 into BW