Export (0) Print
Expand All
Expand Minimize

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

Use the Calculated Member Builder dialog box in SQL Server Data Tools (SSDT) to build a calculated member.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft