SAP BW. A Step-by-Step Guide pdf
By Biao Fu, Henry Fu
Publisher : Addison Wesley
Pub Date : July 23, 2002
ISBN : 0-201-70366-1
Pages : 480
SAP BW has recently come to the fore as a valuable tool for developing data warehouses that accurately and effectively support critical business decision making. It facilitates easy-to-use and high-performance extraction, transfer, transformation, and loading of data from a variety of data sources, including such comprehensive business management systems as SAP R/3.
This practitioner's guide uses step-by-step instructions complete with a plethora of screen captures to illustrate key SAP BW functionalities. It demonstrates how SAP BW implements the fundamental star schema and solves the major challenges inherent in the creation of data warehouses: performance, reliability, and error-handling. Using a real-world business scenario as a running example, SAP® BW presents a comprehensive view of the technology, from underlying concepts and basic techniques through its most sophisticated capabilities.
Specific topics covered include:
Creating an InfoCube and loading the data
Checking the accuracy of data with BW Monitor and the Persistent Staging Area (PSA)
Creating queries to generate reports using Business Explorer (BEx)
Managing user authorization with the Profile Generator
Advanced InfoCube design techniques
Aggregates and multicubes
Working with the Operational Data Store (ODS)
Installing business content and creating an R/3 source system in BW
Loading data from SAP R/3 into SAP BW
Data maintenance
Performance tuning, including parallel query option and data packet sizing
Object transport
Although the focus is on the core SAP BW technology, this book also discusses other relevant technologies, including Basis, ABAP (Advanced Business Application Programming), ALE (Application Link Enabling), and ASAP (Accelerated SAP) for BW.
With the clear explanations and practical techniques presented in SAP® BW information systems professionals will gain both the general understanding and specific skills necessary to create high quality data warehouses that support effective decision making.
Copyright
Preface
Book Objective
Intended Audience
Prerequisites
Book Structure
Conventions Used in This Book
Acknowledgments
Part I. Guided Tours
Chapter 1. Business Scenario and SAP BW
Section 1.1. Sales Analysis—A Business Scenario
Section 1.2. Basic Concept of Data Warehousing
Section 1.3. BW—An SAP Data Warehousing Solution
Section 1.4. Summary
Chapter 2. Creating an InfoCube
Section 2.1. Creating an InfoArea
Section 2.2. Creating InfoObject Catalogs
Section 2.3. Creating InfoObjects—Characteristics
Section 2.4. Creating InfoObjects—Key Figures
Section 2.5. Creating an InfoCube
Section 2.6. Summary
Chapter 3. Loading Data into the InfoCube
Section 3.1. Creating a Source System
Section 3.2. Creating an Application Component
Section 3.3. Creating an InfoSource for Characteristic Data
Section 3.4. Creating InfoPackages to Load Characteristic Data
Section 3.5. Checking Loaded Characteristic Data
Section 3.6. Entering the Master Data, Text, and Hierarchy Manually
Section 3.7. Creating an InfoSource for Transaction Data
Section 3.8. Creating Update Rules for the InfoCube
Section 3.9. Create an InfoPackage to Load Transaction Data
Section 3.10. Summary
Chapter 4. Checking Data Quality
Section 4.1. Checking InfoCube Contents
Section 4.2. Using BW Monitor
Section 4.3. Using the Persistent Staging Area (PSA)
Section 4.4. Summary
Chapter 5. Creating Queries and Workbooks
Section 5.1. Creating a Query Using BEx Analyzer
Section 5.2. Organizing Workbooks Using BEx Browser
Section 5.3. Using a Variable to Access a Hierarchy Node Directly
Section 5.4. Summary
Chapter 6. Managing User Authorization
Section 6.1. Creating an Authorization Profile Using Profile Generator
Section 6.2. Creating an Authorization Object to Control User Access to the InfoCube Data
Section 6.3. Integrating Profile Generator and BEx Browser
Section 6.4. Summary
Part II. Advanced Topics
Chapter 7. InfoCube Design
Section 7.1. BW Star Schema
Section 7.2. InfoCube Design Alternative I— Time-Dependent Navigational Attributes
Section 7.3. InfoCube Design Alternative II-Dimension Characteristics
Section 7.4. InfoCube Design Alternative III— Time-Dependent Entire Hierarchies
Section 7.5. Other InfoCube Design Techniques
Section 7.6. Summary
Chapter 8. Aggregates and Multi-Cubes
Section 8.1. Aggregates
Section 8.2. Multi-Cubes
Section 8.3. Summary
Chapter 9. Operational Data Store (ODS)
Section 9.1. Creating an ODS Object
Section 9.2. Preparing to Load Data into the ODS Object, Then into an InfoCube
Section 9.3. Loading Data into the ODS Object
Section 9.4. Loading Data into the InfoCube
Section 9.5. Using 0RECORDMODE for Delta Load
Section 9.6. Summary
Chapter 10. Business Content
Section 10.1. Creating an R/3 Source System
Section 10.2. Transferring R/3 Global Settings
Section 10.3. Replicating R/3 DataSources
Section 10.4. Installing Business Content Objects and Loading R/3 Data
Section 10.5. Summary
Chapter 11. Generic R/3 Data Extraction
Section 11.1. Creating Views in R/3
Section 11.2. Creating DataSources in R/3 and Replicating Them to BW
Section 11.3. Creating a Characteristic in BW
Section 11.4. Loading Data from R/3 into BW
Section 11.5. Summary
Chapter 12. Data Maintenance
Section 12.1. Maintaining Characteristic Data
Section 12.2. Maintaining InfoCube Data
Section 12.3. Summary
Chapter 13. Performance Tuning
Section 13.1. BW Statistics
Section 13.2. System Administration Assistant
Section 13.3. Tuning Query Performance
Section 13.4. Tuning Load Performance
Section 13.5. Summary
Chapter 14. Object Transport
Section 14.1. System Landscape
Section 14.2. Development Class
Section 14.3. Object Transport
Section 14.4. Summary
Appendix A. BW Implementation Methodology
Section A.1. ASAP for BW
Section A.2. A Simplified BW Project Plan
Section A.3. For Further Information
Appendix B. SAP Basis Overview
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 D. Bibliography
No comments: