Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View can only consume data from tabular models. At the PASS Summit (see PASS 2012 Announcements) it was revealed that you would soon be able to use Power View on a multidimensional cube. Well that time is now! The CTP is now available for download: Microsoft SQL Server 2012 With Power View For Multidimensional Models CTP.
The CTP contains enhancements in SQL Server Analysis Services and SQL Server Reporting Services to allow Power View connectivity to Multidimensional Models. The CTP includes all the updates up to SQL Server 2012 SP1. Here is what’s new:
Power View for Multidimensional Models – Preview
SQL Server 2012 with Power View for Multidimensional Models CTP Documentation
Power View Now Works with Cubes!
DAXMD Goes Public!
Querying Attributes and Measures in DAX Multidimensional
Power View for Multidimensional Models – Feature Drill Down