Export (0) Print
Expand All
Expand Minimize

MDX Builder Dialog Box (Analysis Services - Multidimensional Data)

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.

Term

Definition

Expression

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

Functions

Displays 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.

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

Community Additions

ADD
Show:
© 2014 Microsoft