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.