The source values defined in a formula represent the portion of the database referenced in the calculation. You can use the Add Source toolbar button to add another source or specify a source that is part of a formula.
Source values default to members, expressions, or runtime prompts specified in the business rule range, formula range, and destination. The inherited/default values can be overridden by a member, function, or member runtime prompt.
To define a source in a formula:
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 Select Source icon.
In the Name text box, enter a name describing the source.
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 Single Member Selection to select members and/or variables to define the source. If you select a member, specify whether to use alias tables by selecting an alias table and if so whether to use alias names for the members.
Double-click on the value in the Selected Values text box and enter the 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 Specifying a Range in a Formula.
Right-click the Source icon in the Custom Toolbar, and select one of the following sources:
For a Typical source, select the dimensions to be used in the calculation. (This is the default selection.)
For a Percent to Total source, select the dimension to be used in the denominator of the calculation.
For a Percent to Parent source, select the dimension and generation or level to be used in the denominator of the calculation.
For a Percent to Member source, select the dimension and member to be used in the denominator of the calculation.
For an Evenly Split by Selected Members source, select the dimension and members to be used in the calculation. Then select whether you want to divide the parent by the total number or selected members or number of selected members with data.
For an Evenly Split by Children source, select the dimension to be used in the calculation. Then select to divide the parent value by the total number of children or number of children with data.
You can use a remote source (XREF) to reference data in a remote cube.
Click Save to save the changes you made on the Formula tab.