Other InfoCube Design Techniques - SAP BW

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

  • Compound attributes
  • Line item dimensions

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 shows that 0CO_AREA is a compound attribute of 0COSTCENTER as defined in Business Content.
Compound Attributes

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.

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,we can create another dimension called Dim: sales transaction,and check the option Line Item as shown in Screen.
Line Item Dimensions

After checking and activating the InfoCube,Screen 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.
Dictionary display table

Note:The line item dimension derives its name from the need for detailed information reporting at the line item level. In,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.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BW Topics