Chapter 4. Modeling dynamic cubes 103
4.13.4 Employee by region
Table 4-7 provides the attributes and columns for Region.
Table 4-7 Region
Table 4-8 provides the attributes and columns for Country.
Table 4-8 Country
Table 4-9 provides the attributes and columns for Employee.
Table 4-9 Employee
4.13.5 Promotions
Table 4-10 provides the attributes and columns for Campaign.
Table 4-10 Campaign
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_CODE
Member Caption GO_REGION_DIM.COUNTRY_EN
Other attributes
Member sort COUNTRY_CODE, ASCENDING
Attributes Source column
Level key EMP_EMPLOYEE_DIM.EMPLOYEE_KEY
Member Caption EMP_EMPLOYEE_DIM.EMPLOYEE_NAME
Other attributes All other columns from EMP_EMPLOYEE_DIM
Member sort EMPLOYEE_KEY, ASCENDING
Attributes Source column
Level key MRK_PROMOTION_DIM.CAMPAIGN_CODE
Member Caption MRK_CAMPAIGN_LOOKUP.CAMPAIGN_NAME_EN
Other attributes
Member sort CAMPAIGN_CODE, Ascending
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.