Monday, January 21, 2013

SQL Server 2012 Power View for Multidimensional Models CTP And Microsoft Dynamics AX 2012


Microsoft will release SQL Server 2012 Power View for Multidimensional Models Customer Technology Preview (CTP) . This release will have the following features:

- The Power View reports will support reading from the normal Multidimensional Cubes this will have a great impact on Dynamics AX, because inspite the latest release of Dynamics AX 2012 R2 support the Power view reports but it cannot read from the shipped standard out of the box cubes (Nearly 16 Cube), and it will need a Tabular model which you will have to build from scratch.


(Role Center in AX 2012 R2 with embedded Power View)


But with the expected SQL Server 2012 Power View for Multidimensional Models CTP release you can access the standard and the customized cubes that Microsoft is providing out of the box.

- Another interesting features, if you don't know MDX query and you find it very complex and hard to learn, Microsoft now offers you the DAX which a lot of easier than the MDX (If you know Excel formulas  so you already know more than %60 of DAX)

For more information about SQL Server 2012 Power View for Multidimensional Models CTP

http://blogs.msdn.com/b/sqlrsteamblog/archive/2012/11/29/power-view-for-multidimensional-models-preview.aspx

For more information about DAX

http://blog.gobansaor.com/2011/07/14/dax-the-new-sql/

If you want to try Power View reports

https://businessintelligencedemoportal.com/sites/contosoenergy/SitePages/pvrsample.aspx


Thanks
Mahmoud Anass