Calculated Member Builder Dialog Box (Analysis Services - Multidimensional Data)

Use the Calculated Member Builder dialog box in Business Intelligence Development Studio to build a calculated member.

Options

Term	Definition
Name	Type the name of the calculated member.
Parent Hierarchy	Select the hierarchy in which to create the calculated member.
Parent Member	This option is enabled if you select a parent hierarchy (other than the Measures dimension) that has more than one level. Click the ellipsis (…) button to select a parent member. The parent member determines the location of the calculated member in the dimension structure.
Expression	Type the MDX expression that will be used.
Check	Click Check to test the MDX expression defined in Expression.
Metadata	Displays metadata for the current Analysis Services object that can be included in the MDX expression defined in Expression. You can copy the MDX syntax for the selected item by right-clicking the item and selecting Copy, or by dragging the selected item to Expression.
Functions	Displays the available MDX functions for the current Analysis Services instance. The items listed are retrieved from the MDSCHEMA_FUNCTIONS schema rowset. You can copy the MDX syntax for the selected item by right-clicking the item and selecting Copy, or by dragging the selected item to Expression.