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)
- 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
For more information about DAX
If you want to try Power View reports