Install MDX Studio
| Previous Install SSDT-BI | Manual Install | Install BIDS Helper Next |
|---|
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 Cosmin Ioan. 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.
| Site | Location |
|---|---|
| MDX Studio home page | https://web.archive.org/web/20110714115801/http:/www.mosha.com/msolap/mdxstudio.htm |
| MDX Studio download | https://www.sqlbi.com/tools/mdx-studio/ |
| MDX Studio demonstration | https://www.youtube.com/watch?v=MNUJkHYwOKI |
Automated silent installation of MDX Studio is performed by Process Id 4BB and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupMDXStudio: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2017 | /SetupMDXStudio: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2016 | /SetupMDXStudio: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2014 | /SetupMDXStudio: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2012 | /SetupMDXStudio: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008R2 | /SetupMDXStudio: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008 | /SetupMDXStudio: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2005 | /SetupMDXStudio: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes |
In order to maintain compatibility with older versions of SQL FineBuild, the parameters /InstMDXStudio: and /InstSQLTools: can also be used.
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
SQL Server versions SQL2016 or higher should use MDX Studio v0.4.20. Older versions of SQL Server should use MDX Studio v0.4.15.
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 |
The FineBuild install for MDX Studio includes the following:
The following steps show what you would have to do to install MDX Studio manually. FineBuild does all of this work for you automatically.
-
Navigate to the Additional Components folder
Double-click on the MDX Studio zip file. Click on the sub-folder and select Extract All
-
Copy all files to:
For a 32-bit installation:
C:\Program Files\MDXStudio\For a 64-bit installation:
C:\Program Files (x86)\MDXStudio\
-
Setup Menu Short-cut
Highlight the MDX Studio file, then right-click and select Copy
-
Navigate to the SQL Server Analysis Services menu folder on C:
Select Paste Shortcut
-
Rename the menu shortcut to MDX Studio
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
| Previous Install SSDT-BI | Top | Install BIDS Helper Next |
|---|