IBM Cognos Dynamic Cubes

Chapter 4. Modeling dynamic cubes 107

Table 4-23 provides the attributes and columns for Month (ship date).

Table 4-23 Month (ship date)

Table 4-24 provides the attributes and columns for Day (ship date).

Table 4-24 Day (ship date)

4.13.10 Branch

Table 4-25 provides the attributes and columns for Region.

Table 4-25 Region

Table 4-26 provides the attributes and columns for Country.

Table 4-26 Country

Attributes Source column

Level key GO_TIME_DIM.MONTH_KEY

Member Caption GO_TIME_DIM.MONTH_EN

Other attributes GO_TIME_DIM.CURRENT_MONTH,

GO_TIME_DIM.MONTH_NUMBER,

GO_TIME_DIM.DAYS_IN_MONTH

Member sort MONTH_KEY, Ascending

Attributes Source column

Level Key GO_TIME_DIM.DAY_KEY

Member Caption GO_TIME_DIM.DAY_KEY

Other attributes GO_TIME_DIM.DAY_OF_WEEK, GO_TIME_DIM.DAY_OF_MONTH,

GO_TIME_DIM.DAY_OF_YEAR, GO_TIME_DIM.WEEKDAY_EN

Member sort DAY_KEY, ASCENDING

Attributes Source column

Level key GO_REGION.DIM.REGION_CODE

Member Caption GO_REGION.DIM.REGION_EN

Other attributes

Member sort REGION_CODE, Ascending

Attributes Source column

Level key GO_REGION.DIM.COUNTRY_KEY

Member Caption GO_REGION.DIM.COUNTRY_EN

Other attributes

Member sort COUNTRY_KEY, Ascending