Custom Member Formula Pane (Dimension Editor Data View)
Contains a custom member formula, which is an expression in Multidimensional Expressions (MDX) that determines the cell values associated with a member and overrides the aggregate functions of measures. For general information about custom member formulas, see Custom Rollup Formulas and Custom Member Formulas.
The custom member formula pane displays the custom member formula for the member selected in the dimension members pane. If no custom member formula is visible, none is defined.
You can use the custom member formulas pane to create and update custom member formulas for members of that level, if certain conditions are met. The browsed dimension must be write-enabled, it must be included in a processed cube, and one of the Custom Members property for one of its levels must be set to True. You can use any combination of the following methods:
- Type.
- Click the arithmetic operator buttons and parentheses buttons.
- Click the edit button (...) to display MDX Builder, and then drag and drop items to construct the custom member formula.
The custom member formulas are stored in the dimension table that contains the members.
Caution Changes to custom member formulas are recorded in the dimension table when you save the dimension. Thereafter, these changes cannot be undone except by editing the dimension and manually reversing the changes.
For more information, see Creating Custom Member Formulas.