Technical data

Chapter 7 Creating Cube Collections

Aggregate data is persisted to the a ggregate record that you select on the

General tab.

ALL: Select to persist a ll of the dimension member aggregate values to

the database.

NONE: Select to persist none of the dimension member aggregate v alues to

the database.

ROOT: Select to persist only the value of the hierarchy root member to

the database.

See C

hapter 9 ,

“Creating Hierarchies,” Und erstanding the Persistence of

Aggregate Dat

a, page 79.

Filter User Function:

Select a filter user function to apply to the dimension.

Select None if you do not want to apply a filter user function to the dimension.

See C

hapter 10, “Creating Rules, Formulas, and Us er Functions,” Rules,

Formulas, an d User Functions, page 112.

Sort Type:

Sort by Name: Select to sort the dimension member values by name.

Sort by Key: Select to sort the dimension member values by data cube values.

Note. You can only select from the fields that are mapped to data cubes.

Sort Key #1

If Sort by Key is selected, select the first data cube name by which you would

like to sort the dimension m ember values. Select to sort the dimension’s key

values in ascending or descending order.

Sort Key #2

If Sort by Key is selected, select the second data cube name by which you

would like to sort the dimension member values. Select to sort the dimension’s

key values in ascending or descending order.

Sort Key #3

If Sort by Key is selected, select the third data cube name by which you would

like to sort the dimension m ember values. Select to sort the dimension’s key

values in ascending or descending order.

Viewing A dditional C ube Collection Dimension Properties

The Dimensions tab displays additional properties that you have set for t he dimensions in a cube collection.

Select the c ube collection that contains the dimensions whose properties you want to view, and then select the

Dimensions tab.