Technical data

Chapter 5 Creating Data Cubes

Note. Even though an input cube that uses either the INPUT built-in function is considered to be a type of

calculation data cube, it would not serve a purpose in an intermediate/calculation cube collection.

See Chapter 11, “Using Built-in Functions in Analytic Models,” INPUT, page 165.

See Also

Chapter 5, “Cr eatin g Data Cubes,” Creating Calculation Data Cubes, page 39

Chapter 7, “C reatin g Cube Collections,” Types of Cube Collections, p ag e 54

Association Data Cubes

An association d ata cube is a data cube that is formatted as a member of a dimension and has one or more

attached dimensions. An association data cube associates two dimensions, enabling the end user to group

members of one dimension into categories that are defined by the members of a different dimension. When

an association data cube receives its values from dimension members, it can be considered to be a type of

input data cube. When an association data cube receives its values from a calculation formula, it can be

considered to be a type of calculation data cube.

Association data cubes can exist in all types of cube collections.

Example: Creating the DEPT_TO_REGION Association Data Cube

This example associates the DEPTID dimension with the REGION dimension. This table lists the members

that are included in each dimens i on:

DEPTID Dimension Members

Note. In the

application, the end users group or

categorize these members by categories that are

defined by the members of the REGION dimension.

REGION Dimension Members

Note. In the

application, the end users select members

from this dim ension to group members of the DEPTID

dimension.

AUS01 APAC

AUS02 LATAM

BRA01 NAMER

CAN01 EUROP