PivotViewer Extension for Reporting Services – a Cool BI Fusion with Confusing Name

Although late to the party, I announce the arrival of a very interesting BI technology – PivotViewer Extension for Reporting Services – CTP1. What’s interesting is that it leverages several BI technologies to provide great data visualization:

  1. The Microsoft LiveLabs Pivot which was developed by Microsoft Research.
  2. PowerPivot – a Microsoft self-service BI tool.
  3. Analysis Services R2
  4. Reporting Services R2
  5. SharePoint 2010

You should keep a close eye of this combination (or at least the last four) as it will become increasingly important in the Microsoft BI stack. Robert Bruckner has provided details about the new arrival. Christian Petculescu, a Principal Architect on the SSAS team, is the driving force behind it. Other MVPs have spread the news. But Kasper de Jonge made my day! He has written a GREAT blog about it with step by step instructions to create your own PivotViewer solution. His blog also cleared my confusion about the role of Reporting Services in this architecture. So, Reporting Services has not been extended in any way. It’s just been used an image generator to produce the Pivot images. A better name for the tool could have been a PivotViewer Add-in for SharePoint.

Interestingly, Microsoft Pivot does it work by counting items in collections. It doesn’t support any other aggregation functions. Therefore, PivotViewer is not a replacement for Excel PivotTable. It gives you an additional way to visualize you data.

UPDATE

Amir Netz, the mastermind behind PowerPivot, demonstrated PivotViewer during the second day keynote of the BI conference this year. Forward to 1:21. He also talks about the new features that the next version or PowerPivot (SQL Server 11) will bring in, including KPI support, BIDS development support, etc.