IBM Cognos Dynamic Cubes

Chapter 4. Modeling dynamic cubes 105

Table 4-15 provides the attributes and columns for Retailer name.

Table 4-15 Retailer name

Table 4-16 provides the attributes and columns for Retailer site.

Table 4-16 Retailer site

4.13.8 Time (close date)

Table 4-17 provides the attributes and columns for Year (close date).

Table 4-17 Year (close date)

Table 4-18 provides the attributes and columns for Quarter (close date).

Table 4-18 Quarter (close date)

Attributes Source column

Level key SLS_RTL_DIM.RETAILER_KEY

Member Caption SLS_RTL_DIM.RETAILER_NAME

Other attributes SLS_RTL_DIM.RETAILER_NAME_MB,

SLS_RTL_DIM.RETAILER_CODE

Member sort RETAILER_KEY, Ascending

Attributes Source column

Level key SLS_RTL_DIM.RETAILER_SITE_KEY

Member Caption SLS_RTL_DIM.RTL_CITY

Other attributes All other unused columns in SLS_RTL_DIM

Member sort RETAILER_SITE_KEY, Ascending

Attributes Source column

Level key GO_TIME_DIM.CURRENT_YEAR

Member Caption GO_TIME_DIM.CURRENT_YEAR

Other attributes

Member sort

Attributes Source column

Level key GO_TIME_DIM.QUARTER_KEY

Member Caption GO_TIME_DIM.QUARTER_EN

Other attributes GO_TIME_DIM.CURRENT_QUARTER

Member sort QUARTER_KEY, Ascending