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
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.