Chapter 4. Modeling dynamic cubes 109
4.13.13 Products
Table 4-30 provides the attributes and columns for Product line.
Table 4-30 Product line
Table 4-31 provides the attributes and columns for Product line.
Table 4-31 Product type
Table 4-32 provides the attributes and columns for Product.
Table 4-32 Product
You now need to create a join between VIEW_PRODUCT_NAME and SLS_PRODUCT_DIM.
Use the following steps.
1. Open the dimension editor for Products.
2. Click the Implementation tab.
3. In the implementation diagram, press Ctrl and select the title bars of the
VIEW_PRODUCT_NAME and SLS_PRODUCT_DIM tables.
Attributes Source column
Level key SLS_PRODUCT_DIM.PRODUCT_LINE_CODE
Member Caption SLS_PRODUCT_LINE_LOOKUP PRODUCT_LINE
Other attributes
Member sort PRODUCT_LINE_CODE, ASCENDING
Attributes Source column
Level key SLS_PRODUCT_DIM.PRODUCT_TYPE_KEY
Member Caption SLS_PRODUCT_TYPE_LOOKUP.PRODUCT_TYPE
Other attributes
Member sort PRODUCT_TYPE_KEY, ASCENDING
Attributes Source column
Level key SLS_PRODUCT_DIM.BASE_PRODUCT_KEY
Member Caption VIEW_PRODUCT_NAME.PRODUCT_EN
Other attributes BASE_PRODUCT_NUMBER
Member sort BASE_PRODUCT_KEY, Ascending