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 tuples are the valid combinations of members that are instantiated from an explicit dimension set and are instantiated from these sources:
Data loaded from the database.
Data loaded by using the SetData method.
Other explicit tuples in explicit dimension supersets.
Image: Field to which the BUSINESS_UNIT dimension is mapped
This example illustrates the field to which the BUSINESS_UNIT dimension is mapped. Empty cells indicate null values.
Image: Field to which the DEPARTMENT dimension is mapped
This example illustrates the field to which the 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)This example uses the same fields as the implicit tuples example.
If you create an explicit dimension set that includes the BUSINESS_UNIT and DEPARTMENT dimensions, the analytic calculation engine uses these explicit tuples to calculate the SALES data cube:
(US001, DEPT1000),
(US001, DEPT2000),
(US002, DEPT3000),
(US002, DEPT4000)Note: The analytic calculation engine also uses the input cubes that comprise the relevant data cube's formula to instantiate the explicit tuples that it uses to calculate the data cube.