Technical data

Creating Rules, Formul as, and User Functions Chapter 10
The CASE function evaluates multiple conditions and returns the result for the first true condition. Each
Condition:Result pair is separated by a comma.
See C
hapter 11
, “Using Built-in Functio ns in Analytic Models,” CASE, page 144.
In the preceding formula, the CASE function compares the invest type for an i nvestment to each member
in the TYPES dimension. The formula uses a member reference (for example, [TYPES:Stock] )to
refer to each member. When the CASE function finds the matching member from the TYPES dimension,
it returns the corresponding result. For example, if the invest type for an investment is Bond, the formula
returns BOND_RATE * BOND_AMOUNT / 12.
Working with
Circular Formulas and Circular Systems
This section provides overviews of circular formulas, circular systems, recursive system resolution, and
circular system resolution and discusses how to change circular formula and circular system options.
See Also
“Circular Re
ference”
Understanding Circular Formulas
When a data cu
be’s formula refers either directly or indirectly to that same data cube, it is considered to
be a circula
rformula.
Note. The analytic calculation engine determines—on the data cube level—whether formulas are circular.
However, the analytic calculation engine resolves circular systems and recursive systems on the cell level.
Direct Circular Fo rmulas
This is an ex
ample of a direct circular formula for the SALES data cube:
SALES + SALE
S_GROWTH
This formula states that sales equals sales plus the sales growth.
It is a direct circular formula because the data cube’s formula refers directly to that same data cube.
Indirect Ci
rcular Formulas
In an indirect circular formula, a data cube’s formula refers indirectly to that same data cube, as in this example:
• Formula for BONUS data cube
BONUS_PERCENTAGE * NET_INCOME
•Formulafor
EXPENSE data cube
SALARY + BON
US
• Formula for NET_INCOME data cube
INCOME - EXPENSE
134 Copyright © 1988-2007, Oracl e. All rights reserved.