(NOTE: Each chapter concludes with a Summary.) Preface. Acknowledgments. I. GUIDED TOURS. 1. Business Scenario and SAP BW. Sales Analysis-A Business Scenario. Basic Concept of Data Warehousing. Star Schema. ETTL-Extracting, Transferring, Transforming, and Loading Data. BW-An SAP Data Warehousing Solution. BW Architecture. BW Business Content. BW in mySAP.com. 2. Creating an InfoCube. Creating an InfoArea. Creating InfoObject Catalogs. Creating InfoObjects-Characteristics. Creating InfoObjects-Key Figures. Creating an InfoCube. 3. 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. Master Data and Text. Hierarchy. Creating an InfoSource for Transaction Data. Creating Update Rules for the InfoCube. Creating an InfoPackage to Load Transaction Data. 4. Checking Data Quality. Checking InfoCube Contents. Using BW Monitor. Using the Persistent Staging Area (PSA). 5. Creating Queries and Workbooks. Creating a Query Using BEx Analyzer. Organizing Workbooks Using BEx Browser. Using a Variable to Access a Hierarchy Node Directly. 6. 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. II. ADVANCED TOPICS. 7. 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. Compound Attributes. Line Item Dimensions. 8. Aggregates and Multi-Cubes. Aggregates. Multi-Cubes. 9. 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. 10. Business Content. Creating an R/3 Source System. Creating a Logical System for the R/3 Client. Creating a Logical System for the BW Client. Naming Background Users. Creating an R/3 Source System in BW. Transferring R/3 Global Settings. Replicating R/3 DataSources. Installing Business Content Objects and Loading R/3 Data. 11. 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. 12. Data Maintenance. Maintaining Characteristic Data. Maintaining InfoCube Data. InfoCube Contents. Indices and Statistics. Data Load Requests. Aggregate Rollup. InfoCube Compression. InfoCube Reconstruction. 13. Performance Tuning. BW Statistics. System Administration Assistant. Tuning Query Performance. Query Read Mode. Bitmap Index. Statistics for the Cost-Based Optimizer. Partition. Parallel Query Option (PQO). Tuning Load Performance. Number Range Buffering. Data Packet Sizing. 14. Object Transport. System Landscape. Development Class. Object Transport. Appendix A: BW Implementation Methodology. ASAP for BW. A Simplified BW Project Plan. For Further Information. Appendix B: SAP Basis Overview. SAP Basis 3-Tier Architecture. Presentation Interface. Application Server. Database Interface. Open SQL. Native SQL. Dispatcher, Work Processes, and Services. Dialog Work Process. Update Work Process. Enqueue Work Process. Background Work Process. Spool Work Process. Message Service. Gateway Service. Memory Management. SAP Buffer. Appendix C: Glossary. Appendix D: Bibliography. Index 447 0201703661T07092002
Many large companies have now had SAP R/3 installed for several years, and have an urgent need to analyze the vast amounts of transaction data R/3 is providing them. Getting hold of vital facts and figures and turning them into useful information is a complex and time-consuming task. BW is designed to accurately and effectively support critical business decision-making. It facilitates high-performance and error-free extraction, transfer, transformation, and loading of data from a variety of data sources. This book uses step-by-step instructions with many examples to illustrate key SAP BW functions. Using a real-world business scenario as a running example, the book presents a comprehensive view of BW, from underlying concepts and basic techniques through the technology's most sophisticated capabilities. Tips, lessons, and best practices are discussed. It also covers other relevant technologies. With the clear explanations and practical techniques, SAP professionals will gain both the general understanding and specific skills they need to create effective data extraction tools needed to support decision-making processes.
Biao Fu is a partner with Fuguji LLC, an IT consulting firm specialized in ERP, data warehousing, business intelligence, and supply chain management. Prior to Fuguji LLC, he was a principal consultant with PricewaterhouseCoopers (PwC). At PwC Global Training Center, he was a solutions architect, as well as the lead instructor of SAP BW Technical Infrastructure (BWTI) class, where he was granted the Award of Excellence for his contributions to BWTI and other BW classes. He is an SAP Certified Technical Consultant and SAP Certified BW Consultant. Henry Fu is a partner with Fuguji LLC, an IT consulting firm specialized in ERP, data warehousing, business intelligence, and supply chain management. He is an Oracle Certified Database Administrator and Oracle Certified Application Developer. He has been involved in the development and implementation of several large-scale data warehousing projects. He is a licensed professional engineer (Ontario, Canada), and has two M.S. degrees majoring in management science and engineering. 0201703661AB01142003