In my previous PowerPivot post i created a SSRS report based on a published PowerPivot app with DAX measures. In this post we are going to create a PerformancePoint 2010 dashboard based on the published PowerPivot App and publish it to SharePoint. First you need to enable PerformancePoint in SharePoint 2010, to do this the PerformancePoint team has created an excellent blog post: Deploying PerformancePoint 2010 Soup to Nuts
Ok we start at the PerformancePoint site:
And click start using PerformancePoint Services:
Click the Run dashboard designer button to start the o so familiar dashboard designer (same as 2007). we start by adding a Datasource which points to our PowerPivot xlsx:
I selected the “Per user identity” because i haven’t got my installation really ok (the unattended service account is not installed). Next we can create a scorecard, right mouse on PerformancePoint content, new, Scorecard
Select analysis services and click OK, select the datasource we just created:
We need to create the KPI ourselves, so we select the measures created in PowerPivot, I want to see the the totals sales last month measured against the avg last year, we select the band method “increasing is better”, because more ordeer are better 🙂
We select the year we want our KPI shown against
The next steps we keep the default values, click finish to create and load the dashboard:
Now we want to show the sales kpi by Promotioncategory, you can drag the dimension you want into the scorecard. Don’t forget to click update to show the new result.
I rather like other indicators than the default, so go to the KPI, click scoring and patterns and doubleclick the indicator to select a new indicator, I like the indicator below:
save the indicator, go to the scorecard and update again:
Next i wanted to get a graph to show the orderquantity by year, create a new report and select graph. Put the measure in series and calendaryear on the bottom axis.
Last we create the dashboard to show the data, i created a 2 column dashboard with a top bar. I dragged the scorecard to the right column and the chart report in the left column. You can add a date selection in the top bar when want, or even the new time intelligent filter. I did not add one this time.
Next we save and deploy the dashboard to SharePoint:
It will automaticly open the dashboard in SharePoint, looks great in my opinion:
As last item I wanted to show you one neat thing: the new silverlight decomposition tree. Right click on a bar in the chart and click decomposition. I clicked on the 2007 bar.
When you click the value you can expand the value to a dimension and so on:
Using PerformancePoint on a PowerPivot App is another great way to show the data to you customers, the creation of dashboards are doable for the analysts.
Thanks Kasper.
Great stuff as usual!
Is there any official word on whether PerformancePoint 2010 will work when using Alternate Access Mappings? This does not work in SharePoint / PerformancePoint 2007.
@Matthew Lamb
Yeah, AAM is supposed to work in V2 / 2010 now that PPS is much more integrated with MOSS itself.
This is great stuff. However, I installed it on W2008SP2 and SQLSRV2008R2 CTP Nov and kept having problems deploying the final dashboard to SharePoint and instead of the dashboard, all I got was “updating” and “unexpected error occurred”. At the end it turned out I needed to install a hotfix KB975954.
hmm never seen that problem before, but thanks for sharing Marco !