Technical data

Creating Data Cubes Chapter 5

DEPTID Dimension Members

Note. In the application, the end users group or

categorize these members by categories that are

defined by the members o f the REGION d im e nsio n.

REGION Dimension Members

Note. In the application, the end users select members

from this dim e nsio n to group members of the DEPTID

dimension.

EUR01 NA

GBR01 NA

JAP01 NA

JAP02 NA

MEX01 NA

USA01 NA

USA02 NA

This association enables the end user to group the members of the DEPTID dimension into categories that are

defined by the members of the REGION dimension.

To create the DEPT_TO_REGION association data cube:

1. Cr

eate a new data cube named DEPT_TO_REGION.

2. Fo

rmatthedatacubeasamemberoftheREGIONdimension.

is dimension contains the categories that the end user will use to group the members of the DEPTID

mension. These members appear in the right-hand column of the data cube’s data. The end user can

lect these members from a drop-down list box.

3. At

tach the DEPTID dimension to the DEPT_TO_REGION association data cube.

is dimension contains the members that the end user will group or categorize. These members

pear in the left-hand column of the data cube’s data.

This example shows an association data cube and its drop-down list box in an analytic grid: