Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

Creating Explicit Dimension Sets Chapter 8

• CHANNELS

•CUSTOMERS

•TAXES

• EXPENSES

•MONTHS

• PRODUCTS

•REGIONS

The analytic mo

del contains these explicit dimension sets:

• SET_1: MONTHS, REGIONS (first priority)

• SET_2: TAXES, PRODUCTS (second priority)

• SET_3: CHANNELS, CUSTOMERS, PRODUCTS (third priority)

• SET_4: CHANNELS, CUSTOMERS (fourth priority)

• SET_5: TAXES, EXPENSES (fifth priority)

The analytic calculation engine iterates through the explicit dimension sets—beginning with SET_1—and then

continues down the priority order for the remaining dimensions, matching the following:

• SET_1: MONTHS,

REGIONS (first priority)

• SET_2: TAXES, P

RODUCTS (second priority)

• SET_4: CHANNEL

S, CUSTOMERS (fourth priority)

Example 1: E xplic it Dimension Sets

This table lists an analytic model’s data cubes and their attached dimensions:

Data Cubes Data Cube Formula (if any) Attached Dimensions

SALES

UNIT_SALES * UNIT_PRICE

• PRODUCTS

•REGIONS

• M ONTH S

UNIT_SALES

None (input cube)

• PRODUCTS

•REGIONS

• M ONTH S

UNIT_PRICE

None (input cube)

• PRODUCTS

•REGIONS

• M ONTH S

The company:

•Sell

s the hamburgers product in both the Africa and Asia regions during all months of the year.

•Sell

s the french fries product in the Africa region only during the summer months.

•Neve

r sells the french fries product in the Asia region.