SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Power View for Multidimensional Models – Preview Available

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:

  • SQL Server Analysis Services: This CTP updates SQL Server Analysis Services to expose tabular metadata for multidimensional models and support DAX queries based on the tabular metadata
  • SQL Server Reporting Services in SharePoint Integrated Mode: This CTP provides updates for Reporting Services integration with SharePoint products.  These updates allow Power View to understand tabular metadata for Analysis Services multidimensional models and create appropriate visualizations.  They also add support for Report Filters that affect an entire report and can be specified via URL parameters

More info:

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

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...