- ホーム
- > 洋書
- > 英文書
- > Computer / General
Full Description
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.
Contents
(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
