Summary
This chapter described the creation and use of aggregates and multi-cubes. Aggregates, a key technique for improving query performance, can be used in multi-cube queries. Without resorting to aggregates, a complex query on a large multi-cube may experience an unacceptable response time.
Key Terms
| Term | Description |
|---|---|
| Aggregate | An aggregate is a subset of an InfoCube. The objective when using aggregates is to reduce I/O volume. The BW OLAP processor selects an appropriate aggregate during a query run or a navigation step. If no appropriate aggregate exists, the processor will retrieve data from the original InfoCube. |
| Multi-cube | A multi-cube is a union of basic cubes. The multi-cube itself does not contain any data; rather, the data reside in the basic cubes. To a user, the multi-cube resembles a basic cube. When creating a query, the user can select characteristics and key figures from different basic cubes. |
For Further Information
• OSS Note 0175534, "Large BW Systems and Performance of Aggregate Build."
• OSS Note 0379736, "How Does a MultiCube Work?"
• OSS Note 0327876, "MultiCube Query and Using Several Aggregates."
Next…
Chapter 9 discusses the Operational Data Store (ODS).
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
