Microsoft Dynamics AX 2012 R2 includes the ability to use Power View, an ad-hoc data exploration and visualization experience in Microsoft SQL Server 2012 Reporting Services, to create compelling data analysis based on multidimensional models (a.k.a. SQL Server Analysis Services cubes). However, at the time of the Microsoft Dynamics AX 2012 R2 release in December 2012, Microsoft SQL Server 2012 (that supports Power View for Multidimensional Models) was only available as a Community Technical Preview (CTP).
The Microsoft SQL Server 2012 Service Pack 1 Cumulative Update 4, released on May 31, 2013, gives Microsoft Dynamics AX 2012 R2 customers the ability to create Power View reports against their existing multidimensional models.
Customers will need to upgrade their Analysis Services instance and the Reporting Services add-in for Microsoft SharePoint Server (2010 or 2013) with this Cumulative Update to create Power View reports against existing cubes.
In addition to the cumulative update mentioned above customers who upgrade their existing Microsoft Dynamics AX 2012 R2 implementation will need to install the following hot fixes for Microsoft Dynamics AX (requires PartnerSource/CustomerSource access):
KB2851882: https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2851882 KB2851881: https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2851881 KB2851883: https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2851883 KB2859123: https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2859123
These hotfixes are planned to be included in the Cumulative update for Microsoft Dynamics AX 2012 R2 (CU-6).
Power View connectivity for Multidimensional Models enables Microsoft Dynamics AX 2012 R2 customers to:
For more information on the release please read the announcement here: http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/05/31/power-view-for-multidimensional-models-released.aspx.
Yvonne Haarloev Senior Product Marketing Manager, Microsoft Dynamics ERP
I have R3 installed and the Analyze Data button does not work and gives the same error message as R2 did before the hot fixes came out. Should R3 work 'out of the box"?