SAP BW. A Step-by-Step Guide By Biao Fu, Henry Fu pdf


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:

Powered by Blogger.