IBM Cognos Dynamic Cubes

106 IBM Cognos Dynamic Cubes

Table 4-19 provides the attributes and columns for Month (close date).

Table 4-19 Month (close date)

Table 4-20 provides the attributes and columns for Day (close date).

Table 4-20 Day (close date)

4.13.9 Time (ship date)

Table 4-21 provides the attributes and columns for Year (ship date).

Table 4-21 Year (ship date)

Table 4-22 provides the attributes and columns for Quarter (ship date).

Table 4-22 Quarter (ship date)

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_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