|
|
SAP® BW: A Step-by-Step Guide (完整版) |
|
作 者:Biao Fu, Henry Fu |
I S B N:0-201-70366-1 |
出 版 社: Addison Wesley |
开 本: |
出版日期: July 23, 2002 |
页 数: 480 |
装 帧: |
版 次: |
始 发 地: |
重 量:0(克) |
定 价:0 |
会 员 价:0 |
积 分:0 |
学员价格: 0 |
|
|
|
|
书名 |
SAP® BW: A Step-by-Step Guide (完整版) |
|
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. |
|
 |
目录 |
|
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
|
|
|
|
|
|
|
|