102 IBM Cognos Dynamic Cubes
4.13.3 Time
Table 4-3 provides the attributes and columns for Year.
Table 4-3 Year
Table 4-4 provides the attributes and columns for Quarter.
Table 4-4 Quarter
Table 4-5 provides the attributes and columns for Month.
Table 4-5 Month
Table 4-6 provides the attributes and columns for Day.
Table 4-6 Day
Attributes Source column
Level key GO_TIME_DIM.CURRENT_YEAR
Member Caption GO_TIME_DIM.CURRENT_YEAR
Other attributes
Member sort CURRENT_YEAR, Ascending
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
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
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.