A calculated member is a member whose value that calculates at query execution run time. You can specify an MDX formula for the calculation. The formula and definition is saved in the cube schema definition. No calculated data is stored.
Calculated members are not supported by Excel 2003 or earlier versions.
-
From the Schema Tree View, right-click the cube, and select New Calculated Member.
The Schema Element Properties View appears in the right pane.
- In the Name box, type a name for the new calculated member.
-
Click in the Caption box.
The caption automatically fills with the same name as the calculated member.
The caption is a name that is displayed and can be localized to different languages in the BI client application. See Cube Schema Localization.
- Select the parent hierarchy for the new calculated member from the Hierarchy menu.
- [Optional] To prevent measure visibility to BI client applications, uncheck the Visible check box.
-
Type the MDX query language formula for the new calculated member in the MDX Expression box, and click Validate Expression to validate the MDX expression. See MDX Expressions in Calculations.
For a list of supported MDX functions, methods and operators, see Supported MDX Functions and Operators.
If an MDX validation error occurs, see MDX Validation Errors.
-
Type a number in the Solve Order box.
Solve order is an integer priority for your calculated member relative to other MDX calculations. Unless a non-default solve order is required, leave the value at zero.
Find useful information by searching for solve order in the Microsoft Developer Network Library at http://msdn.microsoft.com/library/.