Technical data

Chapter 6 Creating Dimensions

Note. This aggregate function does not apply to leaf members or detail

members.

See Chapter 9, “Creating Hierarchies,” Understanding Override Order of

Precedence, page 82 and Chapter 9, “Creating Hierarchies,” Example:

Creating a Hierarchy with Mixed Aggregate and Detail Members, page 109.

Interpreting the Total Member Name Field

This table describes the state of the dimension based upon whether:

• A tree is attached to the dimension.

• The Total Member Name field has a value.

Values for the Total Member Name field come from either the value that you entered into the Total Member

Name field of the dimension’s properties, a converted BAM 8.8 model, or a PeopleCode command using the

Analytic Calculation Engine Metadata Classes.

Tree Attached to Dimension? Has Value? Resulting State of Dimension

Yes No

If you select Calcu late Aggregates,

the value of h

ierarchy root member

appears to the end user and to the

analytic calculation engine.

No Yes

PeopleSoft

Analytic C alcul ation

Engine creates a basic, one-node

hierarchy for the dim ension. By

default, t

he Show Hierarchy method is

used on the analytic model, and both

the one-node hierarchy and the name

that you en

ter into the Total Member

Name field appear to the end user.

Note. For

the actual value of the

hierarchy to appear to the end user, you

must select Calculate Aggregate. If

youdonot

select this check box, the

value of 0 appears to the end user.