IBM Cognos Dynamic Cubes

Chapter 4. Modeling dynamic cubes 109

4.13.13 Products

Table 4-30 provides the attributes and columns for Product line.

Table 4-30 Product line

Table 4-31 provides the attributes and columns for Product line.

Table 4-31 Product type

Table 4-32 provides the attributes and columns for Product.

Table 4-32 Product

You now need to create a join between VIEW_PRODUCT_NAME and SLS_PRODUCT_DIM.

Use the following steps.

1. Open the dimension editor for Products.

2. Click the Implementation tab.

3. In the implementation diagram, press Ctrl and select the title bars of the

VIEW_PRODUCT_NAME and SLS_PRODUCT_DIM tables.

Attributes Source column

Level key SLS_PRODUCT_DIM.PRODUCT_LINE_CODE

Member Caption SLS_PRODUCT_LINE_LOOKUP PRODUCT_LINE

Other attributes

Member sort PRODUCT_LINE_CODE, ASCENDING

Attributes Source column

Level key SLS_PRODUCT_DIM.PRODUCT_TYPE_KEY

Member Caption SLS_PRODUCT_TYPE_LOOKUP.PRODUCT_TYPE

Other attributes

Member sort PRODUCT_TYPE_KEY, ASCENDING

Attributes Source column

Level key SLS_PRODUCT_DIM.BASE_PRODUCT_KEY

Member Caption VIEW_PRODUCT_NAME.PRODUCT_EN

Other attributes BASE_PRODUCT_NUMBER

Member sort BASE_PRODUCT_KEY, Ascending

110 IBM Cognos Dynamic Cubes

4. Click the Create Join icon. See Figure 4-21.

Figure 4-21 Creating a join between VIEW_PRODUCT_NAME and SLS_PRODUCT_DIM

5. Choose PRODUCT_NUMBER to be the key on both sides of the join (Figure 4-22).

Figure 4-22 PRODUCT_NUMBER is a key

6. Set the cardinality to: One to One

7. Click OK.

Chapter 4. Modeling dynamic cubes 111

8. Select the relationship that was created, and verify that the cardinality shows as 1 on both

ends of the relationship and that PRODUCT_NUMBER is highlighted in both tables, as

shown in Figure 4-23.

Figure 4-23 Verifying the cardinality

Table 4-33 describes the relationships between the keys.

Table 4-33 Relationships

Dimension Dimension key Measure dimension key

TIME GO_TIME_DIM.DAY_KEY DAY_KEY

Employee by region EMP_EMPLOYEE_DIM.EMPLOYEE_KEY EMPLOYEE_KEY

Products PRODUCT_KEY PRODUCT_KEY

Sales Order SALES_ORDER_KEY SALES_ORDER_KEY

Promotions PROMOTION_KEY PROMOTION_KEY

Order method ORDER_METHOD_KEY ORDER_METHOD_KEY

Retailers RETAILER_SITE_KEY RETAILER_SITE_KEY

TIME (close date) DAY_KEY CLOSE_DAY_KEY

Time (ship date) DAY_KEY SHIP_DAY_KEY

Branch EMPLOYEE_KEY EMPLOYEE_KEY

Product Brand PRODUCT_KEY PRODUCT_KEY