Custom Member Formula Pane (Dimension Browser)
Use this pane to create and update custom member formulas for members of the selected level, if certain conditions are met. The browsed dimension must be write-enabled, and one of its level's Custom Members properties must be set to True.
The custom member formula pane displays the custom member formula for the member selected in the dimension members pane. If no formula is visible, none is defined.
A custom member formula is a Multidimensional Expressions (MDX) expression that determines the cell values associated with a member and overrides the aggregate functions of measures. For more information about custom member formulas, see Custom Rollup Formulas and Custom Member Formulas.
The custom member formulas are stored in the dimension table that contains the members.
Important Changes to custom member formulas are recorded in the dimension table after you click Close and then click Yes to confirm the changes. Thereafter, these changes cannot be undone except by browsing the dimension again and manually reversing the changes.
Options
Dimension Members
View dimension members in a tree format. Expand individual members to browse their descendents. Select a member to create or update members of that level.
Member properties
View member properties for the selected member. You can use this pane to modify properties if the dimension is write-enabled.
Custom Member Formula
View the custom member formula for the member selected in the dimension members pane. If no 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, and one of its level's Custom Members properties must be set to True.
Arithmetic operator buttons
Click to add operators to a formula.
Edit (...) button
Click to open MDX Builder, where you can create an MDX expression.
For more information, see Creating Custom Member Formulas.