Technical data

Chapter 8 Creating Explicit Dimension Sets

(US001, DEPT3000) ,

(US001, DEPT4000),

(US002, DEPT10

00),

(US002, DEPT2000) ,

(US002, DEPT3000) ,

(US002, DEPT400

Example: Explicit Tuples

This example u ses 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 ca

lculation engine uses these explicit tuples to calculate the SALES data cube:

(US001, DEPT10

00),

(US001, DEPT2000) ,

(US002, DEPT3000) ,

(US002, DEPT40

00)

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.

Defining Explic

it Dimension Sets

This section discusses how to:

• View explicit dimension set properties.

• Edit or add new explicit dimension sets.

Viewing Explicit Dimension Set Properties

Double-click the Parts branch in the part browser, and then select the Explicit Dimension Set tab.