Appendix B. SAP Basis Overview

BW uses the same R/3 Basis 3-tier architecture. In this overview, we introduce basic concepts of SAP Basis 3-tier architecture, such as work processes and memory management.

Part I. Guided Tours

Part I. Guided Tours

Business Scenario and SAP BW

Business Scenario and SAP BW
Sales Analysis A Business Scenario
Basic Concept of Data Warehousing
BW An SAP Data Warehousing Solution
Summary

Creating an InfoCube

Creating an InfoCube
Creating an InfoArea
Creating InfoObject Catalogs
Creating InfoObjects Characteristics
Creating InfoObjects Key Figures
Creating an InfoCube
Summary

Loading Data into the InfoCube

Loading Data into the InfoCube
Creating a Source System
Creating an Application Component
Creating an InfoSource for Characteristic Data
Creating InfoPackages to Load Characteristic Data
Checking Loaded Characteristic Data
Entering the Master Data, Text, and Hierarchy Manually
Creating an InfoSource for Transaction Data
Creating Update Rules for the InfoCube
Create an InfoPackage to Load Transaction Data
Summary

Checking Data Quality

Checking Data Quality
Checking InfoCube Contents
Using BW Monitor
Using the Persistent Staging Area (PSA)
Summary

Creating Queries and Workbooks

Creating Queries and Workbooks
Creating a Query Using BEx Analyzer
Organizing Workbooks Using BEx Browser
Using a Variable to Access a Hierarchy Node Directly
Summary

Managing User Authorization

Managing User Authorization
Creating an Authorization Profile Using Profile Generator
Creating an Authorization Object to Control User Access to the InfoCube Data
Integrating Profile Generator and BEx Browser
Summary

Part II. Advanced Topics

Part II. Advanced Topics

InfoCube Design

InfoCube Design
BW Star Schema
InfoCube Design Alternative I Time-Dependent Navigational Attributes
InfoCube Design Alternative II-Dimension Characteristics
InfoCube Design Alternative III Time-Dependent Entire Hierarchies
Other InfoCube Design Techniques
Summary

Aggregates and Multi-Cubes

Aggregates and Multi-Cubes
Aggregates
Multi-Cubes
Summary

Operational Data Store (ODS)

Operational Data Store (ODS)
Creating an ODS Object
Preparing to Load Data into the ODS Object, Then into an InfoCube
Loading Data into the ODS Object
Loading Data into the InfoCube
Using 0RECORDMODE for Delta Load
Summary

Business Content

Business Content
Creating an R/3 Source System
Transferring R/3 Global Settings
Replicating R/3 DataSources
Installing Business Content Objects and Loading R/3 Data
Summary

Generic R/3 Data Extraction

Generic R/3 Data Extraction
Creating Views in R/3
Creating DataSources in R/3 and Replicating Them to BW
Creating a Characteristic in BW
Loading Data from R/3 into BW
Summary

Data Maintenance

Data Maintenance
Maintaining Characteristic Data
Maintaining InfoCube Data
Summary

Performance Tuning

Performance Tuning
BW Statistics
System Administration Assistant
Tuning Query Performance
Tuning Load Performance
Summary

Object Transport

Object Transport
System Landscape
Development Class
Object Transport
Summary

Appendix A. BW Implementation Methodology

Appendix A. BW Implementation Methodology

Object Transport

Object Transport
Section A.1. ASAP for BW
Section A.2. A Simplified BW Project Plan

Appendix B. SAP Basis Overview

Appendix B. SAP Basis Overview

Object Transport

Object Transport
Section B.1. SAP Basis 3-Tier Architecture
Section B.2. Dispatcher, Work Processes, and Services
Section B.3. Memory Management

Appendix C. Glossary

Appendix C. Glossary

Appendix D. Bibliography

Appendix D. Bibliography