MDX Builder Dialog Box (Analysis Services - Multidimensional Data)

Use the MDX Builder dialog box in Business Intelligence Development Studio 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.

Options

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.