Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

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


Leave a comment on the original post [, opens in a new window]

Loading comments...