Creating an InfoCube
The following steps demonstrate how to create an InfoCube, the fact table and associated dimension tables, for the sales data shown in Table 1.4.
Work Instructions
Step 1. Select Data targets under Modelling in the left panel. In the right panel, right-click InfoArea demo and then select Create InfoCube….
SCREEN 2.22
Step 2. Enter a name and a description, select the option Basic Cube in block InfoCube type, and then click
Note
An InfoCube can be a basic cube, a multi-cube, an SAP remote cube, or a general remote cube.
A basic cube has a fact table and associated dimension tables, and it contains data. We are building a basic cube.
A multi-cube is a union of multiple basic cubes and/or remote cubes to allow cross-subject analysis. It does not contain data. See Chapter 8, Aggregates and Multi-Cubes, for an example.
SCREEN 2.23
A remote cube does not contain data; instead, the data reside in the source system. A remote cube is analogous to a channel, allowing users to access the data using BEx. As a consequence, querying the data leads to poor performance.
If the source system is an SAP system, we need to select the option SAP RemoteCube. Otherwise, we need to select the option Gen. Remote Cube. This book will not discuss remote cubes.
Step 3. Select IO_CUST, IO_MAT, and IO_SREP from the Template table, and move them to the Structure table by clicking
Next, click the Dimensions… button to create dimensions and assign these characteristics to the dimensions.
SCREEN 2.24
Step 4. Click ,
Note
BW automatically assigns technical names to each dimension with the format .
Fixed dimension is reserved for Data Packet, Time, and Unit. Section 12.2.3, "Data Load Requests," discusses the Data Packet dimension.
A dimension uses a key column in the fact table. In most databases, a table can have a maximum of 16 key columns. Therefore, BW mandates that an InfoCube can have a maximum of 16 dimensions: three are reserved for Data Packet, Time, and Unit; the remaining 13 are left for us to use.
Repeat the same procedure to create two other dimensions. Next, click the Assign tab to assign the characteristics to the dimensions.
SCREEN 2.25
Step 5. Select a characteristic in the Characteristics and assigned dimension block, select a dimension to which the characteristic will be assigned in the Dimensions block, and then click
SCREEN 2.26
Step 6. After assigning all three characteristics to their dimensions, click
SCREEN 2.27
Step 7. Select the Time characteristics tab, select 0CALDAY from the Template table, and move it to the Structure table by clicking
SCREEN 2.28
Step 8. Select the Key figures tab, select IO_PRC, IO_QUAN, and IO_REV from the Template table and move them to the Structure table by clicking
Next, click
SCREEN 2.29
Result
You have created the InfoCube IC_DEMOBC. A status message InfoCube IC_DEMOBC activated will appear at the bottom of Screen 2.29.