You must install SQL Server 2005 Analysis Services with Service Pack 2 or higher before installing the Analysis extensions.

SQL Analysis Services for DAX 2009 is one of the most annoying components to install. My typical DAX installation is built on the following: Windows Server 2008 R2 with SQL Server 2008 Reporting Services and SQL Server 2008 R2, Microsoft Dynamics Axapta 2009 with Service Pack 1 and Roll-up 7. However on running the installation I got the following error: You must install SQL Server 2005 Analysis Services with Service Pack 2 or higher before installing the Analysis extensions.

This error message highlights that there is an Analysis Services 2005 version of the Microsoft.AnalysisServices.dll file in the Global Assembly Cache. Microsoft Dynamics AX does not support running Analysis Services 2005 and Analysis Services 2008 on the same computer. To resolve this issue, uninstall the Microsoft.AnalysisServices.dll file that has a version number of 9.0 from the Global Assembly Cache (typically located at C:\Windows\assembly). Go to this folder and remove all references to the of the Microsoft.AnalysisServices.dll version 9.0. For more information on removing and adding reference see this page gacutil. On running the installation once again, you get the following,

I can see the smile on your face. Complete the installation steps and you should get the following screen.

AX Company Name in SSRS Reports

Often the need to show the company name is very important in SSRS reports for Microsoft Dynamics AX 2012. This is very useful in Multi-company set-up.

To achieve this create your textbox, right click and in the context menu select expressions. Use the following expression to return the current company =Microsoft.Dynamics.Framework.Reports.DataMethodUtility.GetFullCompanyNameForUser(
  Parameters!AX_CompanyName.Value,Parameters!AX_UserContext.Value)  I hope this is helpful.