Example: Implicit Tuples

This example illustrates the field to which the BUSINESS_UNIT dimension is mapped. Empty cells indicate null values.

Field to which BUSINESS_UNIT dimension is mapped

This example illustrates the field to which the DEPARTMENT dimension is mapped.

Field to which DEPARTMENT dimension is mapped

In this example, departments 1000 and 2000 exist only in business unit US001, and departments 3000 and 4000 exist only 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),
(US001, DEPT3000),
(US001, DEPT4000),
(US002, DEPT1000),
(US002, DEPT2000),
(US002, DEPT3000),
(US002, DEPT4000)