You can specify a formula range to define the portion of the database that is the same for the current formula. The formula range is processed in conjunction with the business rule range and displays the values defined in the business rule range as the default in italics. You can redefine values inherited from the business rule range in the formula range to more narrowly define the portion of the database for this formula.
If you define a formula range that is outside the scope of the business rule range, no members meet both criteria so the formula does not calculate.
To specify a formula range:
If it is not open, open the graphical business rule for which you want to specify a formula range.
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. Select the type of formula to add, and double-click the formula or drag it to the desired location in the business rule on the Graphical tab.
If you did not select a source for the formula on the Formula tab, select a source. See Specifying a Source in a Formula.
Select the Formula Range tab, and do one of the following:
For each available dimension in the list, select <ALL> or the default value in the Selected Values text box and enter a member name.
Click the Member Selection button (magnifying glass) to the right of the Selected Values text box for the dimension. Use Member Selection to select members and variables to define the formula range.
Click Save to save the changes you made on the Formula Range tab.