Technical data

Chapter 10 Creating Rules, Formulas, and User Functions
Predefined Constant Definition
#FORWARD
Use this predefined constant as the second argument in the FORMEMBERS
function to loop through the di m ension memb ers in a forward dir ectio n.
See C
hapter 11, “Using Built-in Functions in Analytic Models,” FORMEMBERS,
page 157.
#N/A
Use this predefined constant to test whether a value in a data cube is not available,
or to return N/A as a result.
#PI
The value of Π (3.14159265 36), which is the ratio of a circle’s circumference to
its diameter.
#REVERSE
Use this predefined constant as the second argument in the FORMEMBERS
function to loop through the dimension m e mb ers in a reverse direction.
See C
hapter 11, “Using Built-in Functions in Analytic Models,” FORMEMBERS,
page 157.
#TRUE
A true value. Use this predefined constan t to test whether a data cube is true or to
return a true value as a result.
Mathematical Operators
This table describes PeopleSoft Analytic Calculation Engine’s operators and their order of execution:
Symbol Mathematical Operation Order of Execution
^
Exponentiation
1
* Mul tiplication
2
/ Division
3
+
Addition
4
-
Subtraction
5
Order of Precedence
If you use more than one kind of operator in a rule, you must understand the precedence that the analytic
calculation engine follows with the operators . Precedence refers to the order in which the different operators
are evaluated.
For an example of precedence, the rule 3+2*4evaluates as 11, not as 20. The analytic calculation
engine performs the multiplication of 2 and 4 before it adds the number 3 because m ultiplication has a higher
precedence than addition.
Copyright © 1988-2007, Oracl e. All rights reserved. 125