create-and-run-an-mdx-script-in-sql-server-data-tools.md

title	Create and Run an MDX Script in SQL Server Data Tools | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	analysis-services
ms.topic	conceptual
helpviewer_keywords	MDX [Analysis Services], scripts scripts [Analysis Services], creating scripts [MDX], creating
ms.assetid	aa54b8cc-ff3b-4ef6-a64e-11b9e9d7fa11
author	minewiskan
ms.author	owend
manager	craigg

Create and Run an MDX Script in SQL Server Data Tools

To create and run an MDX Script in [!INCLUDEssASnoversion], you need to be in [!INCLUDEssBIDevStudioFull] with a cube already created and ready for editing.

To create a Multidimensional Expressions (MDX) script

1. Open the cube for which you want to create an MDX script, and under View, click Calculations.

2. If you are not in Script View mode, click the Script View icon.

3. In the script window, under the CALCULATE command, type an MDX expression. Click the Check Syntax icon and verify that the expression is syntactically correct.

4. To run the MDX script, deploy and process the cube with the new MDX script changes.

See Also

The Basic MDX Script (MDX)
MDX Scripting Fundamentals (Analysis Services)
MDX Scripting Statements (MDX)