Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

101

102

103

104

105

106

107

108

109

110

Chapter 9 Creating Hierarchies

See Also

Chapter 11, “Us

ing Built-in Functions in Analytic Models,” PARENT, page 179

Chapter 11, “Using Built-in Functions in Analytic Models,” CHILDCOUNT, pa ge 145

Chapter 11, “Using Built-in Functions in Anal ytic Models,” FORCHILDREN, page 156

Data Type Considerations

Aggregate members can have different data types than their child detail members, even though they both

display data for the same dimension. When this is the case, you must reconcile the situation if you want to

persist aggregates.

For example, s

uppose the PRODUCTS dimension is mapped to a numeric field in the main record and

contains memb

ers from this tree:

ALL_PRODUCTS

Release Less than 8

<Leaf Range (Low = 0, High= 799)

Release 8

<Leaf Range (Low = 800, High= 899)

Notice that the Release 8 member is not totally numeric; instead, it is a string that contains letters and a

number. If the detail value 846 is added to the tree, the member 846 (which is numeric) is added to the parent

member Release 8 (w hic h is a string). To reconcile this situation, you should persist the aggregates for this

dimension to a field with a data type of String and a length of at least 20.

Note. It is not necessary for the main record’s fields to have the same data types as the aggregate record’s fields.

Working with Overrides

This section p

rovides overviews of default aggregation, override order of precedence, and the

PSACETREEOVR

D subre cord and discusses how to:

• Use default aggregation.

• Create overrides.

• Crea te a hierarchy with mixed aggregate and detail members.

Understandin

g Default Aggregation

By default, PeopleSoft Analytic Calculation Engine sums all of the values of a pare nt member’s direct children

to calculate the value of the parent member. PeopleSoft Analytic Calculation Engine executes this default

aggregation by iterating over all child members and applying the plus operator. The default aggregation

operates on all c hildren, even if the child member itself is an aggregate value.

Note. This default aggregation is not used if you specified a cube dimension override user function, a member

override user function, a dimension override user function, or do not have any aggregates in the relevant part

of the analytic model.

This is an exa

mple of PeopleSoft Analytic Calculation Engine’s default aggregation: