mdx-builder-analysis-services-multidimensional-data.md

title	MDX Builder (Analysis Services - Multidimensional Data) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	analysis-services
ms.topic	conceptual
f1_keywords	sql12.asvs.mdxbuilderdialof.f1
helpviewer_keywords	MDX Builder dialog box
ms.assetid	fecbf093-65ea-4e1b-b637-f04876f1cb0f
author	minewiskan
ms.author	owend
manager	craigg

MDX Builder (Analysis Services - Multidimensional Data)

Use the MDX Builder dialog box in [!INCLUDEssBIDevStudioFull] or [!INCLUDEssManStudioFull] 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 [!INCLUDEssASnoversion] 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 [!INCLUDEssASnoversion] 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)