MDX Builder (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.
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. |
See Also
Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Cell Data (Role Designer) (Analysis Services - Multidimensional Data)