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