Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

101

102

103

104

105

106

107

108

109

110

Chapter 9 Creating Hierarchies

• Use the member override user function.

This override operates on specific members of a dimension. You create the member override user

function in the analytic model. However, because members are often instantiated at runtime, you use

the PSACETREEOVRD subrecord to assign the m ember override user function to the dimension

rather than assign the member override user function to specific members within the analytic model.

For example, if the end user enters aggregate data, you can write a member override function that

uses the INPUT built-in function to capture the user input, and use the PARENT and CHILDCOUNT

built-in functions to push down the aggregate data and create new members. Then you can assign the

member override user function to the appropriate dimension in the PSACETREEORRD subrecord.

Note. If the member override user function does not contain a value, PeopleSoft Analytic Calculation

Engine applies the default aggregation (the plus operator) to the dimension members.

• If the member override function does not exist, perform Step 4.

4. Perform one of these actions:

• Use the dimension override function.

The analytic calculation engine uses this override user function to calculate all of a dimension’s

aggregates as they apply to all dimensions.

For example, suppose you create a dimension override function for the PRODUCTS dimension. If

this dimension is attached to both the SALES and COST_OF_GOOD S dimensions, the dimension

override function applies to the aggregates for both data cubes.

To set a dimension override user function, create a user function and select the user function in the

Aggregate Function field of the dimension’s properties.

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

• If the dimens

ion override function does not exist, perform Step 5.

5. Aggregate th

evaluesofthechildmembersbyusingtheoperators that are attached to each child.

The analytic

calculation engine iterates over each value to evaluate the aggregate.

The default o

perator for each member is the plus operator.

You set t he o p

erators in the OPERAT ION field of the PSACETREEOVRD subrecord. When the

default sum o

perator is used, the actual value in the OPERATION field is null.

If you do not w

ant to use the default sum aggregation, yo u can populate the OPERATION field with

one of these v

alues:

•MIN.

Usethisvalu

e for the analytic calculation engine to use subtraction aggregation. The analytic

calculation

engine iterates o ver each member and applies the subtraction operator to each iteration.

The aggrega

te value is the resulting value after the final iteration.

•IGN.

Usethisvalu

e for the analytic calculation engine to ignore the OPERATION field.