Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Create and Run an MDX Script in SQL Server Data Tools

To create and run an MDX Script in  Analysis Services, you need to be in SQL Server Data Tools (SSDT) 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.