Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

101

102

103

104

105

106

107

108

109

110

Creating Hierarchies Chapter 9

•Treedata.

Tree data includes:

- Aggregate data:

PeopleSoft Analytic Calculation Engine persists aggregate data in the aggregate record.

See C

hapter 9, “

Creating Hierarchies,” Understanding the Persistence of Aggregate Data, page 79.

Note. Records that are used as aggregate records should be read after records that are used as main records.

See Chapter 12 , “Understanding the Relationship of Analytic Types to Analytic Models,” Synchronization

Order, page 208.

- Pushed down data.

PeopleSoft Analytic Calculation Engine creates detail data out of pushed down aggregate data. For this

reason, PeopleSoft Analytic Calculation Enginepersiststhisdatainthemainrecord.

See C

hapter 9, “

Creating Hierarc hies,” Pushed Do wn Data, page 80.

• Detail data.

Detail data is d

ata that cannot be broken down a ny further. PeopleSoft Analytic Calculation Engine persists

detail data to

the main record.

A detail member

is generated out of one value of detail data in the database.

Aggregate R ecord Properties

On a case-by-c

ase basis, you must determine which aggregates you want to save for each dimension in the

cube collecti

on. You may select either ALL, NONE, or ROOT in the Persist Aggregate field of the Edit Cube

Collection Di

mension dialog box. Here are explanations for these selections:

• ALL: Select to persist all of the dimension member aggregate values to the database.

• NONE: Select to persist none of the dimension member aggregate values to the database.

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

See C

hapter 7, “Creating Cube Collections,” Defining Additional Cube Collection Dimension Properties,

page 60.

Pushed Down Data

Sometimes a parent member in a hierarchy may contain aggregate data that is not derived by aggregating the

parent member’s children. When this is the case, you may want to break down the parent member’s value to

generate the detail data for the parent member’s children. You create user functions that employ the PARENT,

CHILDCOUNT, and FORCHILDREN built-in functions to push down aggregate data.

These user fu

nction examples push down parent member data:

AT (DIMENSIO

N, Parent(DIMENSION), THISCUBE() * 0.2)

And:

AT (DIMENSIO

N, Parent(DIMENSION), THISCUBE() / CHILDCOUNT(DIMENSION, #DIRECT))