Previous Install Report Viewer 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 http://web.archive.org/web/20110714115801/http:/www.mosha.com/msolap/mdxstudio.htm
MDX Studio download http://www.sqlbi.com/tools/mdx-studio/
Copy the MDXStudio2008.zip and MDXStudio2005.zip files into \Additional Components
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 installation of MDX Studio is performed by Process Id 4BA and is controlled by the parameters below:

Install Parameter Build SQL 2005 SQL 2008 SQL 2008 R2 SQL 2012
InstMDXStudio FULL Yes Yes Yes Yes
InstSQLTools No No No No
InstMDXStudio WORKSTATION Yes Yes Yes Yes
InstSQLTools Yes Yes Yes Yes
InstMDXStudio CLIENT Yes Yes Yes Yes
InstSQLTools Yes Yes Yes Yes

FineBuild also uses the following parameters to help install MDX Studio:
Prameter SQL Version Default Value Description
MDXzip SQL 2008 and above MDXStudio2008.zip Name of file containing MDX Studio install media
MDXzip SQL 2005 MDXStudio2005.zip 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:
/InstSQLTools: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 MDX Studio and select Extract All.

SQL Server 2008 and above Use MDXStudio2008.zip
SQL Server 2005 Use MDXStudio2005.zip

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 - 2013 Edward Vassie. License and Acknowledgements
Previous Install Report Viewer Top Install BIDS Helper Next

Last edited Aug 9, 2013 at 12:55 PM by EdVassie, version 34

Comments

No comments yet.