Technical data

Chapter 10 Creating Rules, Formulas, and User Functions

Note. PeopleSoft recommends that you do not enter an assumption directly into a rule. Instead, you should

create a data cube for the assumption and refer to the data cube in the formula. For example, do not calculate

TAXES b y multiplying INCOME by 0.38. Instead, create a data cube called TAX_RATE and enter 0.38 as its

value. Then calculate TAXES by multiplying INCOME by TAX_RATE. Performing the procedure in this

fashion simplifies the process of changing the assumptions and makes the analytic model easier to understand

and audit.

See Chapter 10, “Creating Rules, Formulas, and User F unctions,” Inserting a Data Cube Reference in to a

Rule, page 129.

Inserting a Data Cube Reference into a Rule

To insert a data cube reference into a rule:

• Place the cursor where you want to insert the data cube reference.

• Perform one of these actions:

- In the part browser, click on the data cube to which you want to refer.

- Enter the name of the data cube.

Note. If you enter a data cube reference for a data cube that does not exist, the analytic calculation engine

returns an error when validating the analytic model.

- Select Edit, Paste Cube Name and click on the data cube to which you want to refer.

Inserting a Dimension Reference into a Rule

To insert a dimension reference into a rule:

• Place the cursor at the location of the rule into which you want to insert the dimension reference.

• Perform one of these actions:

- Inthepartbrowser,clickthedimensiontowhichyouwanttorefer.

- Enter the name of the dimension.

Note. If you enter a dimension reference for a dimension that does not exist, the analytic calculation

engine returns an error when validating the analytic model.

- Select Edit, Paste Dimension and click on the dimension to which you want to refer.

Inserting a Dimension Member Reference into a Rule

This section discusses how to:

• Enter a member reference into a rule.

• Refer to one slice of a data cube.

Entering a Member R efe rence into a Rule

To enter a member reference into a rule: