Other InfoCube Design Techniques

Before closing this chapter, let's briefly discuss two other InfoCube design techniques:

  • Compound attributes
  • Line item dimensions

7.5.1 Compound Attributes

Compounding entities is an idea that BW borrows from R/3 to model coexistent entities. Compound attributes requires overhead, so you should not use them unless absolutely necessary.

Screen 7.38 shows that 0CO_AREA is a compound attribute of 0COSTCENTER as defined in Business Content.

SCREEN 7.38

graphics/07fig38.gif

Sometimes the meaning of master data depends on the source of the data. In these cases, we need to compound the characteristic with the InfoObject 0SOURSYSTEM (Source system ID).

For example, suppose a characteristic IO_HOUSE has an entry called White House. The characteristic could mean the home of the U.S. President if it comes from a government source system, or it could mean a house painted white if it comes from a home improvement Web site. To handle cases such as this one, we need to compound IO_HOUSE with 0SOURCESYSTEM to clarify the meaning of the characteristic.

The 0SOURSYSTEM InfoObject is provided with Business Content.

7.5.2 Line Item Dimensions

If a dimension has only one characteristic, we can make the dimension become a line item dimension. Consider the following example. For the InfoCube described in Chapter 2, we can create another dimension called Dim: sales transaction, and check the option Line Item as shown in Screen 7.39.

SCREEN 7.39

graphics/07fig39.gif

After checking and activating the InfoCube, Screen 7.40 reveals that the fact table has no dimension table created for the line item dimension. The key in the fact table is the SID of the SID table. Thus the fact table links to the master data, text, and hierarchy tables with the SID table, and one middle layer for the dimension table is removed. This design improves system performance.

SCREEN 7.40

graphics/07fig40.gif

Note

The line item dimension derives its name from the need for detailed information reporting at the line item level. In Chapter 9, Operational Data Store (ODS), we will discuss another technique that allows us to build a multilayer structure for different levels of detail information reporting.

The level of detail found in a data warehouse is called its granularity. It is determined by business requirements and technology capabilities.

Part I. Guided Tours

Business Scenario and SAP BW

Creating an InfoCube

Loading Data into the InfoCube

Checking Data Quality

Creating Queries and Workbooks

Managing User Authorization

Part II. Advanced Topics

InfoCube Design

Aggregates and Multi-Cubes

Operational Data Store (ODS)

Business Content

Generic R/3 Data Extraction

Data Maintenance

Performance Tuning

Object Transport

Appendix A. BW Implementation Methodology

Object Transport

Appendix B. SAP Basis Overview

Object Transport

Appendix C. Glossary

Appendix D. Bibliography



SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
ISBN: B000LZM8CM
EAN: N/A
Year: 2002
Pages: 106

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net