Technical data

Creating Explicit Dimension Sets Chapter 8

• SET_1: PRODUCTS, REGIONS, ORDER_ID.

• SET_4: DEPT_ID, EMPL_ID.

• BUSINESS_UNIT dimension.

Understanding Implicit Tuples and Explicit Tuples

Implicit tuples are the combinations of members that are used to calculate a single data cube but do not

comprise an explicit dimension set.

Explicit tupl

es are the valid combinations of members that are instantiated from an explicit dimension set

and are instan

tiated from these sources:

• Data loaded from the database.

• Data loaded by using the SetData

• Other explicit tuples in explicit dimension supersets.

Example: Implicit Tuples

This table lis

ts the field to which the BUSINESS_UNIT dimension is mapped. Empty cells indicate null values:

BUSINESS_UNIT field

US001

US002

This table lists the field to which the DEPARTMENT dimension is mapped.

DEPARTMENT field

DEPT1000

DEPT2000

DEPT3000

DEPT4000

In this example, departments 1000 and 2000 only exist in business unit US001, and departments 3000 and

4000 only exist in business unit US002.

If the BUSINESS_UNIT and DEPARTMENT dimensions do not comprise an explicit dimension set and both

dimensions are attached to the SALES data cube, the analytic calculation engine uses these implicit tuples to

calculate the SALES data cube:

(US001, DEPT1000),

(US001, DEPT2000) ,