Want to understand what is BI & DWH? Need help with your DWH design, Analysis Services, Panorama or MDX queries? Just call me.
10$
Mail me
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
As many of you already know, installation on Microsoft Excel on the SSAS 2005 server is needed in order to use Excel functions in MDX. That's very helpful because MDX is lack of many important functions such as Round (!). Many organizations don't like it at all, but here's something that may help. In the SSAS 2005 server you don't need to install the whole program, only the .Net programmability support. In the installation, choose to manually pick up which components you wish to install and then choose the .Net programmability Support as seen in the picture:
Notice that this issue will not be fixed in SSAS 2008, so this tip will be relevant for a long time.
Remember Me