The destination values defined in a formula represent the portion of the database that stores the calculated values. Any dimension values you specify in the business rule range or the formula range are locked in for the destination and are displayed in italics.
The name of the destination is “Destination” by default. To help document and maintain the business rule, change the default name to a description of what the formula calculates.
To define a destination:
If it is not open, open the graphical business rule to which you want to add a 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. 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.
On the Formula tab, select the Destination icon.
In the Name text box, enter a name for the destination.
For each available dimension in the list, do one of the following tasks:
Click the Member Selection button (magnifying glass) to the right of the Selected Values text box for the dimension. Use Multiple Member Selection to select members and/or variables to define the destination.
Select the Selected Values text box and enter a value next to the dimension.
Leave the value <All> to use all members of a dimension.
Member expressions in italics are inherited from the business rule range or the formula range. These values can only be changed or deleted for the business rule range or the formula range. See the discussion of a business rule range in Creating a Business Rule or a formula range in Specifying a Range in a Formula.