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

 

Applies To: SQL Server 2016

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

TermDefinition
NameType the name of the calculated member.
Parent HierarchySelect the hierarchy in which to create the calculated member.
Parent MemberThis 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.
ExpressionType the MDX expression that will be used.
CheckClick Check to test the MDX expression defined in Expression.
MetadataDisplays 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.
FunctionsDisplays 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.

Multidimensional Expressions (MDX) Reference

Community Additions

ADD
Show: