Thursday, July 15, 2010

And It Is Live...

The CTP1 of PivotViewer for Reporting Services has just shipped! Get your free download from here. As I was saying in an earlier post, it is a concept project. It's not supported, and not a feature.

However, it is really cool! It allows you to easily create stunning visualizations on top of your BI data - and these visualizations are fully dynamic: you decide at runtime which subset of data you should see, it shows the actual live numbers, and you decide how much (meta)data you associate with each card. Also, all of the cards are generated by the service, so it is very convenient. Of course it comes with sample data, and a tutorial.

I will continue to post articles here but if you have questions, I suggest you ask them on the PowerPivot forum. I will monitor it for questions related to PivotViewer for Reporting Services.

Videos will be posted soon - I'll keep you informed (also on twitter) about the location.


  1. Where might one see a 'stunning' example of this new technology? :)

  2. Few places:

    1. Check the demo at
    2. Check the TechEd keynote (from offset 1h:10m or so) at:
    3. You can install the software, and play with the sample app provided
    4. Stay tuned for more posts (one will come before you know it)
    5. Follow twitter #pivotviewer

  3. Thanks for the links. Glad to see it went from Amir's click-view demo at the BI Cust Panel last year, to shipping. Nice job! I just need to come up with a compelling use case at my company so I can put together a cool demo.

  4. Looks cool. However in video it didnt show much about what data to use it on.

    - Is it only to be used with powerpivot or also directly on AS without ´powerpivot ?
    - Is it for dimensions, numbers ?

  5. @Steve:
    Cool! There will also be more posts on best practices etc
    1. It also works with any Adomd.Net connection (and also with MS SQL Server data). But pay attention to delegation issues! (see the doc in the download)
    2. It usually is for dimensions, but you decide what it is for. It is for a query. There will be another video and/or posting on how exactly to build a collection, what to have in mind etc.

  6. Very cool - but do we need to have the full version of SharePoint (Enterprise) and PowerPivot installed to use this?

  7. @MAQ: I don't enforce full version of SharePoint but I haven't tested with anything else. If you manage to make it work otherwise, let me know :) About PowerPivot - technically might not be needed, although, you might need to install yourself the Adomd.Net for using against Analysis Services.

    The product (PivotViewer Extension for Reporting Services) allows you to (technically) build solutions on top of SQL or native AS (not only PowerPivot) as well as older versions of Reporting Services although testing has been done with only SQL 2008 R2 and PowerPivot installed.

  8. Hi Cristian,

    Thanks for your help. I have managed to get PivotViewer Extensions for SSRS to work on SharePoint Foundation 2010 pointing to a SSAS 2008 Cube. I just followed the same instructions as you posted.

    One further question though if I may. I'm building a collection for customer sales analysis. Is it possible for me to show numerics from the measures dimension alongside customers? For example [Measures].[Average Sale]? If so could you post an example of how the dataset query might look?

    Many thanks,


  9. @MAQ: Sure it is possible. Please read the chapter called "Dataset Query Specification" from the documentation. In a nutshell, you'll use two axes instead of one: whatever you were using on the axis 0 in the case of a single axis you would move on axis #1 (rows) and on axis 0 you will put Measures.[Average Sale]. Basically this has the effect of extending the "row" presented in the tuple on the current position of axis 1 with the cells for the headings in axis 0. The exact algorithm is in the chapter