Chapter 4. Modeling dynamic cubes 97
Figure 4-16 Formatting according to table measures of gosldw_sales
4.13.1 Measures of gosldw_sales
Table 4-2 provides the measures for gosldw_sales.
Table 4-2 gosldw_sales measures
Measure Source
column
Regular
aggregate
Format Format
value
Quantity SLS_SALES_FACT.Q
UANTITY
Sum
Unit cost SLS_SALES_FACT.U
NIT_COST
Calculated Number of
decimal places
2
Unit sale price SLS_SALES_FACT.U
NIT_PRICE
Calculated Number of
decimal places
2
Revenue SLS_SALES_FACT.S
ALE_TOTAL
Sum Number of
decimal places
2
Gross profit SLS_SALES_FACT.G
ROSS_PROFIT
Sum Number of
decimal places
2
98 IBM Cognos Dynamic Cubes
How to create a dimension
Use the following steps to create a dimension:
1. Select the model folder.
2. Right-click New dimension.
3. Rename it to: Time
4. Expand the Project Explorer tree. Rename the hierarchy to: Time
5. Select the hierarchy and right-click Open Editor. The Hierarchy Editor opens
(Figure 4-17). Note that there is a already a level in the hierarchy.
Figure 4-17 Creating a dimension
6. Click New Level three times.
7. Rename the levels in the order that the levels appear in the table for specifying the
metadata for the Time dimension.
8. Select the Year level and right-click Open editor.
Chapter 4. Modeling dynamic cubes 99
9. Drag the columns listed in the table for the Year level into the Year level. These items are
the attributes of the Time dimension Year level. In this case, there is only one, as shown in
Figure 4-18.
Figure 4-18 Renaming the levels
10.Click the Member caption radio button for the attribute that is listed as the member
caption.
11.Click the level Unique key check box for the attributes that are listed in the level key.
100 IBM Cognos Dynamic Cubes
12.Click Level Key. The Level Key editor opens (Figure 4-19). For this initial set of
dimensions, only one attribute is in the level key. Notice that it has a key icon beside it.
That icon indicates that this attribute is the business key. For more information about
modeling level keys, see 4.3.4, “Modeling level keys” on page 75.
Figure 4-19 Level Key editor
13.Confirm that the level key is defined.
14.Click OK.
15.Click member sort dialog.
16.Drag the attribute listed in the Member sort row of the dimension specification into the
member sort control.
17.Set the member sort direction value to be Ascending.
18.Click OK to save the member sorting.
Get IBM Cognos Dynamic Cubes now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
