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 was written by Mosha Pasumansky, one of the world leading experts in Analysis Services. It is now maintained by Ihor Bobak. 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 http://web.archive.org/web/20110714115801/http:/www.mosha.com/msolap/mdxstudio.htm
MDX Studio download http://download.bitimpulse.com/public/helptoolz/sql_ssas/MDXStudio_0_4_15.zip
MDX Studio demonstration http://www.youtube.com/watch?v=MNUJkHYwOKI
MDX Studio Forum http://www.ssas-info.com/forum/3-mdx-studio/

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 SQL2016
SetupMDXStudio FULL Yes Yes Yes Yes Yes Yes
SetupSQLTools No No No No No No
SetupMDXStudio WORKSTATION Yes Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes Yes
SetupMDXStudio CLIENT Yes Yes Yes Yes Yes Yes
SetupSQLTools Yes 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 Default Value Description
MDXzip MDXStudio_*.zip Name of file containing MDX Studio install media
MDXexe 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:
/SetupSQLTools:Yes
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 the MDX Studio zip file. Click on the sub-folder and select Extract All.

MDX Studio Explorer zip.png
2) Copy all files to:
For a 32-bit installation: C:\Program Files\MDXStudio\
For a 64-bit installation: C:\Program Files (x86)\MDXStudio\
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 FineBuild Team © 2011 - 2016. License and Acknowledgements
Previous Install SSDT-BI Top Install BIDS Helper Next

Last edited Oct 29 at 11:28 AM by EdVassie, version 38