Previous Install SSDT-BI Manual Install Install BIDS Helper Next

Install MDX Studio

FineBuild can install and configure the MDX Studio as part of the SQL Server install process.
If you do not want to include MDX Studio in your FineBuild install, then do not download it.

MDX Studio is written by Mosha Pasumansky, one of the world leading experts in Analysis Services. It was chosen to be included in FineBuild because of the significant extra functionality it provides to developers of MDX queries.

The original web site that hosted MDX Studio is no longer available and a copy captured by Web Archive is used below. An alternative to the original download location is also used.

MDX Studio home page
MDX Studio download
Copy the and files into \Additional Components
MDX Studio demonstration
MDX Studio Forum

FineBuild MDX Studio Install

Automated silent installation of MDX Studio is performed by Process Id 4BB and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupMDXStudio FULL Yes Yes Yes Yes Yes
SetupSQLTools No No No No No
SetupMDXStudio WORKSTATION Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes
SetupMDXStudio CLIENT Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes

In order to maintain compatibility with older versions of SQL FineBuild, the parameters InstMDXStudio and InstSQLTools can also be used.

FineBuild also uses the following parameters to help install MDX Studio:
Parameter SQL Version Default Value Description
MDXzip SQL 2008 and above Name of file containing MDX Studio install media
MDXzip SQL 2005 Name of file containing MDX Studio install media
MDXexe Any MDXStudio.exe Name of MDX Studio program file

MDX Studio will be installed with CLIENT and WORKSTATION builds, but not with a FULL build.
If you want to install it with a FULL build, the following parameter should be added at run time:
The FineBuild install for MDX Studio includes the following:
  • Perform a MDX Studio install
  • Add a menu item for MDX Studio to the Analysis Services menu.

Manual MDX Studio Install

The following steps show what you would have to do to install MDX Studio manually. FineBuild does all of this work for you automatically.

Install MDX Studio

1) Navigate to the Additional Components folder, double-click on MDX Studio and select Extract All.

SQL Server 2008 and above Use
SQL Server 2005 Use

MDX Studio Explorer zip.png
2) Copy all files to:
For a 32-bit installation: C:\Program Files\MDXStudio2008\
For a 64-bit installation: C:\Program Files (x86)\MDXStudio2008\
MDX Studio Extract.png

Setup Menu Item

1) Setup Menu Short-cut. Highlight the MDX Studio file, then right-click and select Copy.
MDX Studio Shortcut Copy.png
2) Navigate to the SQL Server Analysis Services menu folder on C: and select Paste Shortcut.
MDX Studio Shortcut Paste.png
3) Rename the menu shortcut to MDX Studio.
MDX Studio Shortcut Rename.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install SSDT-BI Top Install BIDS Helper Next

Last edited Oct 8, 2014 at 10:47 AM by EdVassie, version 37