108 IBM Cognos Dynamic Cubes
Table 4-27 provides the attributes and columns for Branch.
Table 4-27 Branch
4.13.11 Product brand
Table 4-28 provides the attributes and columns for Product brand.
Table 4-28 Product brand
4.13.12 Product name
Table 4-29 provides the attributes and columns for Product name.
Table 4-29 Product name
Attributes Source column
Level key GO_BRANCH_DIM.BRANCH_KEY
Member Caption GO_BRANCH_DIM.CITY
Other attributes GO_BRANCH_DIM.ADDRESS1, GO_BRANCH_DIM.ADDRESS2,
GO_BRANCH_DIM.PROV_STATE,
GO_BRANCH_DIM.ADDRESS1_MB,
GO_BRANCH_DIM.ADDRESS2_MB, GO_BRANCH_DIM.CITY_MB,
GO_BRANCH_DIM.PROV_STATE_MB,
GO_BRANCH_DIM.POSTAL_ZONE,
GO_BRANCH_DIM.WAREHOUSE_BRANCH_CODE,
GO_BRANCH_DIM.BRANCH_CODE
Member sort BRANCH_KEY, Ascending
Attributes Source column
Level key PRODUCT_BRAND_KEY
Member Caption SLS_PRODUCT_BRAND_LOOKUP.PRODUCT_BRAND_EN
Other attributes PRODUUCT_BRAND_CODE
Member sort PRODUCT_BRAND_KEY, Ascending
Attributes Source column
Level key BASE_PRODUCT_KEY
Member Caption PRODUCT_EN
Other attributes
Member sort BASE_PRODUCT_KEY, Ascending
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset