Summary

In this chapter, we created an InfoCube. To display its data model, you can right-click InfoCube demo: Basic Cube, then select Display data model…(Screen 2.30).

SCREEN 2.30

The data model appears in the right panel of Screen 2.31.

SCREEN 2.31

Note

IO_SREG and IO_SOFF are not listed under IO_SREP as attributes; rather, they have been created as independent characteristics. Section 3.6, "Entering the Master Data, Text, and Hierarchy Manually," describes how to link IO_SOFF and IO_SREG to IO_SREP via a sales organization hierarchy. Section 7.2, "InfoCube Design Alternative I – Time-Dependent Navigational Attributes," discusses a new InfoCube design in which IO_SOFF and IO_SREG are IO_SREP's attributes.

 

Key Terms

Term	Description
Key figure	Key figures are numeric values or quantities, such as Per Unit Sales Price, Quantity Sold, and Sales Revenue. The maximum number of characters allowed for the technical name is 9.
Characteristic	Characteristics are descriptions of key figures, such as Customer ID, Material Number, Sales Representative ID, Unit of Measure, and Transaction Date. The maximum number of characters allowed for the technical name is 9.
InfoObject	In BW, key figures and characteristics are collectively called InfoObjects.
InfoObject Catalog	InfoObject Catalogs are used to organize InfoObjects. Two types of InfoObject Catalogs exist: one for characteristics and one for key figures. The maximum number of characters allowed for the technical name is 30.
InfoArea	InfoAreas are used to organize InfoCubes and Info Objects. Each InfoCube is assigned to an InfoArea. Through an InfoObject Catalog, each InfoObject is assigned to an InfoArea as well. The maximum number of characters allowed for the technical name is 30.
InfoCube	An InfoCube consists of a fact table and its associated dimension tables in the star schema. The maximum number of characters allowed for the technical name is 30.

Next…

We will load the data described in Chapter 1, Business Scenario and SAP BW, into the InfoCube.