Technical data

Creating Cube Collections Chapter 7

Note. You can map a data cube or dimension to one field within one record.

Once you have mapped a data cube or dimension to a particular record field,

you cannot use that record field in another mapping. You can, however, reuse

the same field if that field is from a different record.

When mapping dimensions and data cubes, you may want to map dimensions

to the key fields in the main record and data cubes to the non-key fields in

the main record. The PeopleSoft system, however, does enable you to map

dimensions to non-key and data cubes to key fields. To perform the most

appropriate mapping, you must have a deeper understanding of the relationship

between data cubes and dimensions.

See C

hapter 3, “Un derstanding Analytic Models,” Data Cubes and

Dimensions, page 16.

Aggregate Field

Select a field to store the cube collection’s aggregate data.

Defining Ad

ditional Cube Collection Dimension Properties

This section discusses how to:

• Set additional cube collection dimension properties.

• View additional cube collection dimension properties.

Setting Add

itional Cube Collection Dimension Properties

Select the cube collection that c ontains the dimensions whose properties you want to set, and then select the

Dimensions tab. Double-click any of the cells in the row of a d imension to access the Edit Cube Collection

Dimension dialog box.

Edit Cube Collection Dimension dialog box

Persist Aggregate:

Select whether to persist the dimension’s aggregate values to the database.