Appendix D. Bibliography
Books
• ALE, EDI & IDoc Technologies for SAP, by Arvind Nagpal, Robert Lyfareff (ed.), and Gareth M. de Bruyn (ed.). Prima Publishing, 1999. ISBN: 0761519033.
• Authorizations Made Easy 4.6A/B, by SAP Labs, Inc., Simplification Group. Johnson Printing Service, 1999. ISBN: 1893570231.
• Business Information Warehouse for SAP, by Naeem Hashmi. Prima Publishing, 2000. ISBN: 0761523359.
• SAP BW Reporting Made Easy 2.0B/2.1C, by SAP Labs, Inc., Simplification Group. Johnson Printing Service, 2001. ISBN: 1-893570-66-5.
• SAP R/3 Administrator's Handbook, by Jose Antonio Hernandez (ed.). McGraw-Hill Professional Publishing, 1999. ISBN: 0071354131.
• SAP R/3 System: A Client/Server Technology, by Rudiger Buck-Emden, Jurgen Galimow, and SAP AG. Addison-Wesley, 1996. ISBN: 0201403501.
• The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses, Ralph Kimball. John Wiley & Sons, 1998. ISBN: 0471255475.
BW Methodology
• ASAP for BW Accelerators can be downloaded from http://service.sap.com/bw/.
BW Online Documentation
• SAP Library: Business Information Warehouse comes with the BW installation CDs.
Helpful OSS Notes
• 0128447, "Trusted/Trusting Systems."
• 0130253, "Notes on Upload of Transaction Data into the BW."
• 0156784, "Additional Tablespaces for BW tables."
• 0175534, "Large BW-Systems and Performance of Aggregate Build."
• 0181944, "Accelerate Hierarchy Attribute Change Run."
• 0184322, "Procedure after DB Copy of BW Source Systems."
• 0184905, "Collective Note Performance BW 2.0."
• 0301192, "Procedure After Upgrading an R/3 Source System."
• 0309955, "BW Statistics in 2.0B – Questions, Answers, Errors."
• 0323323, "Transport of All Activated Objects of a System."
• 0325470, "Activities After Client Copy in BW Source Systems."
• 0325525, "Copying and Renaming Systems in a BW Environment."
• 0325839, "Considerable Increase of Tablespace PSAPODSD."
• 0327876, "MultiCube Query and Using Several Aggregates."
• 0339896, "ORACLE ERROR 14400."
• 0351163, "Creating ORACLE DB Statistics Using DBMS_STATS."
• 0356018, "Standard Transport System Activation in BW."
• 0356801, "Performance Problems Based on a Wrong Optimizer Dec."
• 0364577, "ODS: ORA-54 When Loading Data into the ODS."
• 0379736, "How Does a MultiCube Work?"
• 0384023, "Optimize Performance of ODS Objects."
• 0397403, "Aggregate Rollup Runs Slowly."
• 0399704, "Calling SAP Transactions from within the BEx Browser."
• 0408532, "Using the DBMS_STATS Package for Collecting Stats."
SAP White Papers
• "mySAP Technology for Open E-Business Integration – Overview," available at http://www.sap.com/
• "Portal Infrastructure: People-Centric Collaboration," available at http://www.sap.com/
• "mySAP Business Intelligence," available at http://www.sap.com/
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
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
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
Performance Tuning
- Performance Tuning
- BW Statistics
- System Administration Assistant
- Tuning Query Performance
- Tuning Load Performance
- Summary
Object Transport
Appendix A. BW Implementation Methodology
Object Transport
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 D. Bibliography
EAN: N/A
Pages: 106
