TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

MDX Builder (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

Use the MDX Builder dialog box in SQL Server Data Tools (SSDT) or SQL Server Management Studio to build a Multidimensional Expressions (MDX) expression. You can display the MDX Builder dialog box by clicking the Edit MDX ellipsis button () for the Allow reading of cube content option, the Allow reading of cell content contingent on cell security option, or the Allow reading and writing of cube content option on the Cell Data page of Role Designer.

TermDefinition
ExpressionType the MDX expression to 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 from the context menu, or by dragging the selected item to Expression.
FunctionsDisplays 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 from the context menu, or by dragging the selected item to Expression.

Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Cell Data (Role Designer) (Analysis Services - Multidimensional Data)

Community Additions

ADD
Show:
© 2016 Microsoft