Use a Variable formula to store the intermediary values results of calculations in a business rule. This is similar to the use of variables in Essbase. You may define multiple variables within one business rule. A variable must be defined before it can be used in another component; it represents one numeric value that is specified directly or derived from a calculation.
To add a Variable formula to a business rule:
If it is not open, open the graphical business rule to which you want to add a Variable formula.
If the BR Language tab is not selected, select it in the bottom of the left frame of the Analytic Administration Services window.
Expand the Formulas folder, and double-click the Variable formula or drag it to the desired location in the business rule on the Graphical tab.
On the Formula tab, enter details for each operand of the formula. Do the following tasks:
Define the destination for the formula. The destination stores the calculated values from the formula. See Specifying a Destination in a Formula.
Define the source for the formula. See Specifying a Source in a Formula.
Define the ratio by specifying the numerator and denominator. See Specifying a Source in a Formula.
Select the Formula Range tab and specify the members that remain constant throughout the formula.
The formula range more narrowly defines the business rule range. See Specifying a Range in a Formula.
Select the Data Condition tab and enter criteria that must be met for the formula to be calculated. Define the destination for the variable by entering a name that describes the variable. See Specifying a Data Condition in a Formula.
Define the numerical value you want to assign to this variable.