Technical data

Creating Dimensions Chapter 6

Tree Attached to Dimension? Has Value? Resulting S tate of Dimension

Yes Yes

One of these resulting states applies:

• If you apply an aggregate function

to this dimension, the value that

you enter into th e Total M em ber

Name field serves as an alias to the

hierarchy root member.

This alias only appears to the user

functions within the analytic model;

the actual value o f the hierarchy root

member appears to the end user.

• If you do not apply an aggregate

function to this dimension and select

Calculate Aggregates, the aggregate

value of the hierarchy root member

appears to the end user.

No No

PeopleSoft Analytic Calculation

Engine does n ot create a hierarchy for

the dimension.

Attaching a Dimension to a Data Cube

To be useful, a dimension must work with one or more data cubes.

Note. When a cube collection is mapped to either a Writable-only record or a record with the Readable and

Writable attributes, all data cubes in the cube collection should share the same set of dimensions.

To attach a dimension to a data cube:

ight-click the data cube to which you want to attach the dimension.

elect Attach Dimensions.

he Attach Dimension(s) to Selected Cube(s) dialog box appears.

elect one or more dimensions.

•P

ress C

TRL and click the left mouse button to select multiple dimensions.

•C

lick Select All to select all of the dimensions.

•C

lick Unselect All to clear all of the dimensions.

•C

lick OK.