Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

100

Creating Hierarchies Chapter 9

Detail Members and Leaf Members

If a tree is not a

ttached to a dimension, PeopleSoft Analytic Calculation Engine creates detail members for

each value of t

he field to which the dimension is mapped.

If a tree is attached to a dimension, PeopleSoft Analytic Calculation Engine creates detail members out of

the tree’s detail values to establish a dimension’s parent and child relationships (in a tree, detail values can

serve as children and parents).

See Enterprise PeopleTools 8.49 People B ook: PeopleSoft Tree Manager, “Introduction to PeopleSoft Tree

Manager,” Using Detail Values (Leaves).

Note. When detail values serve as parents, they are also referred to as detail nodes because they do not display

aggregated data. Instead, detail nodes usually display the key values of regular transactional tables.

When detail members serve as parents, they do not display aggregated data. Rather, they enable end users to

navigate through the hierarchy.

Be aware of these characteristics of detail members’ relationship to the main record:

• Detail member

names are either read from the main record or generated from the tree’s data.

• Navigation re

lated functions such as PREV, NEXT, and PREVSELF operate on detail member names

that are p ers

isted in the main record.

These functi

ons do not use trees to determine the order of members.

See C

hapter 11, “Using Bui lt-in Functions in Analyt ic Models,” PREV, page 182;Chapter 11, “Using

Built-in Functio ns in Analytic Models,” NEXT, page 1 75 and Chapter 11, “Using Built-in Functions in

Analytic Models,” PREVSELF, page 183.

A leaf member is a special type of detail member that does not have children.

For example,

suppose an end user enters 2004–01–01 as a new detail value. PeopleSoft Analytic Calculation

Engine gener

ates a new 2004–01–01 leaf member. This is a leaf member because its corresponding detail

valuedoesn

ot have any children.

Aggregate Members

Aggregate members are mapped to the nodes of a tree that have either children or leaf ranges. Aggregate

members display a grouping of data, rather than a specific discrete value.

For example

, suppose an analytic model’s DATE dimension is mapped to a tree that contains 2004–01–01 as

a leaf node a

nd Q12004 as a branch node. PeopleSoft A nalytic Calculation Engine generates the Q12004

aggregate m

ember out of the branch node.

The ana lytic calculation engine creates aggre ga te members out of any tree elements that remain after it

creates the hierarchy’s detail members.

Hierarchy Root Member

You can map t

he hierarchy root member to any node that you want to serve as the root of the hierarchy. All

sibling n o

des or nodes at a higher level of the tree are not used to create the hierarchy. You map the hierarchy

root membe

r by using the NodeName parameter of the Atta chTree method.

Note. Only one hierarchy root member can exist per dimension.

Consider this example of a tree’s parent-child relationships: