Technical data

Creating Rules, Formul as, and User Functions Chapter 10

Insert an equal symbol into the rule.

Insert an AND operator into the rule.

Insert an OR operator into the rule.

Insert a NOT operator into the rule.

Paste a built-i

n function and its arguments into the rule.

Paste a data cube name into the rule.

Paste a dimension name into the rule.

Paste a member reference into the rule.

Paste a user fun

ction into the rule.

Exit the formula without canceling the changes or validating the formula.

Rules, Formulas, and User Functions

In PeopleSoft Analytic Calculation Engine, you use the rule bar to create rules that define the calculation of

data. You use rules within formulas and u ser functions.

Formulas defin

e the calculation of data cubes. You enter the formula within the rule bar of the data cube that

youwanttocal

culate.

You can create a formula and save it as a user function, which can be reused with various data cubes by

entering the name of the user function in the rule bar of the relevant data cube. You also create user functions

to create filters and to define the calculation of aggregates.

PeopleSoft Analytic Calculation Engine enables you to create rules that contain references to other parts. When

the values of these other parts change, the analytic calculation engine recalculates the rule and stores the results

in the field mapped to the calculated part. These kinds of rules can be useful for working with assumption data.

When end users work with analytic instance data within an application, they can e nter assumption values into

one data cube, and then view the results of those assumptions in the values of other calculated data cubes.

For e xample,

suppose a n analytic model contains three data cubes called PROFIT, INCOME, and EXPENSE.

The PROFIT da

ta cube contains this formula:

INCOME - EXPE

NSE

When an end user changes a value that is tied to t he INCOME or EXPENSE data cube, the analytic calculation

engine recalculates the formula and stores the result in the field that is mapped to the PROFIT data cube.