Example 2: Explicit Dimension Supersets and Subsets

An analytic model contains the SALES data cube. These dimensions are attached to this data cube:

• PRODUCTS

• REGIONS

• ORDER_ID

• BUSINESS_UNIT

• DEPT_ID

• EMPL_ID

You have defined these explicit dimension sets:

• SET_1: PRODUCTS, REGIONS, ORDER_ID (Priority 1).

• SET_2: PRODUCTS, REGIONS (Priority 2).

• SET_3: REGIONS, ORDER_ID (Priority 3).

• SET_4: DEPT_ID, EMPL_ID (Priority 4).

The explicit dimension subset (PRODUCTS, REGIONS) exists at a lower priority than its superset (PRODUCTS, REGIONS, ORDER_ID). The subset is in row 2; the superset is in row 1. The analytic calculation engine takes the cross product of the following to instantiate the valid combinations of dimension members for the SALES data cube:

• SET_1: PRODUCTS, REGIONS, ORDER_ID.

• SET_4: DEPT_ID, EMPL_ID.

• BUSINESS_UNIT dimension.