Share via


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.