Book description
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.
0201703661B07092002
Table of contents
- Copyright
- Preface
- Acknowledgments
-
I. Guided Tours
- 1. Business Scenario and SAP BW
- 2. Creating an InfoCube
-
3. Loading Data into the InfoCube
- 3.1. Creating a Source System
- 3.2. Creating an Application Component
- 3.3. Creating an InfoSource for Characteristic Data
- 3.4. Creating InfoPackages to Load Characteristic Data
- 3.5. Checking Loaded Characteristic Data
- 3.6. Entering the Master Data, Text, and Hierarchy Manually
- 3.7. Creating an InfoSource for Transaction Data
- 3.8. Creating Update Rules for the InfoCube
- 3.9. Create an InfoPackage to Load Transaction Data
- 3.10. Summary
- 4. Checking Data Quality
- 5. Creating Queries and Workbooks
- 6. Managing User Authorization
-
II. Advanced Topics
- 7. InfoCube Design
- 8. Aggregates and Multi-Cubes
- 9. Operational Data Store (ODS)
- 10. Business Content
- 11. Generic R/3 Data Extraction
- 12. Data Maintenance
- 13. Performance Tuning
- 14. Object Transport
- A. BW Implementation Methodology
- B. SAP Basis Overview
-
C. Glossary
- D. Bibliography
Product information
- Title: SAP® BW: A Step-by-Step Guide
- Author(s):
- Release date: July 2002
- Publisher(s): Addison-Wesley Professional
- ISBN: 9780201703665
You might also like
book
Datenvisualisierung – Grundlagen und Praxis
Immer größere Datenmengen liegen uns vor. Doch wie vermitteln wir prägnant und anschaulich Erkenntnisse und Aussagen, …
book
Disruption in Financial Reporting
Since the global financial crisis of 2007–8, new laws and regulations have been introduced with the …
book
The Moorad Choudhry Anthology, + Website
The definitive and timeless guide to the principles of banking and finance, addressing and meeting the …
book
Conversation Transformation: Recognize and Overcome the 6 Most Destructive Communication Patterns
One of the New York Post's Top 10 Best Career Books of 2012 Repair communication breakdowns …