Installing PivotViewer Extension for Reporting Services including the sample app

First of all the PivotViewer Extension for Reporting Services is ready for download here. The installation is described in an excellent installation guide that is included in the package, a must read for anyone who wants to start with the PivotViewer Extension for Reporting Services.

What do you have to do to install it into your SharePoint machine, in my case i have a single box. My sharepoint is at http://powerpivotand have integrated SSRS with the following service url http://powerpivot/ReportServer_SQL  my SQL Server is installed at PowerPivotpowerpivot (machine nameinstancename).

The following steps you need to do:

  • Open an command prompt with Administrator access and run:
    BICollectionDBProvision.exe -sPowerPivotpowerpivot -op
    This will create a database on a local database in my case “PowerPivotpowerpivot”
  • Open the SharePoint 2010 Management Shell command prompt with Admin access:
    .installBIPivot.ps1 “-whttp://powerpivot” -oi -y
    This will install SharePoint specific features for the Pivotviewer, like the Crawler and viewer control on my SharePoint machine “http://powerpivo”. This syntax is different than from the intallation guide, i had to run it with . in front of it because my location wasn’t a certified location.

This is all you have to do. Remember this is not a replacement for the installation guide just gives you what i did.

Next up is installing the Demo app. Again open the command prompt with admin privilages and run

BICollectionSampleBuilder -rhttp://powerpivot/ReportServer_SQL -whttp://PowerPivot -gSampleGallery -dSampleDocuments

this installs the app files on your SharePoint.

Now all you have to do is create a page in sharepoint and add a “PivotViewer BI Report Crawler” webpart to your page. Select the Accountmanagers invetory and start crawling, the report is now rendererd for all options in the pivot viewer.

Finaly create a second page and add the “PivotViewer BI Data Browser” webpart to the new page and in the properties set the Inventory to “Accountmanagers”. Your Pivotviewer app will now be working:

Again make sure you read the manual, i had trouble as well because i didn’t read it as well as i should !

Check out this video about installation as well: