My PerformancePoint experiences
Finally I made some time to write about my experiences with PerformancePoint 2010 and then focused on my dashboard specially for the iPad and the new SP1 features.
Last April the was a business request to enable the existing PerformancePoint dashboard for viewing on a iPad. The first step was, besides getting an iPad with the correct WiFi, 3G and VPN connections, trying the existing dashboard opening in the iPad Safari browser.
As at that moment we were running a RTM version of SharePoint, so the only dynamic option for filters was the visibility, not the initial content. And there were two filters based on the same dimension which controlled the content of the scorecards and reports. So how to make the dropdownbox as small as possible, say one region and respect the original behavior. Luckily I could use a extra filter to ‘pre-filter’ the main filter. But that filter could only set the visibility of the main filter. In the end I could solve it the following way:
First I added an extra dimension, which was just an extra copy of the original dimension used in the main filter. After that I based the second filter on a SharePoint list mainly with members of that extra dimension. Only the All level of that filter was from the other original dimension hence the reason for the SharePoint list. After that I created for every child level a corresponding filter with the visibility linked. The last part was to attach all filters, in my case +/- 30, to all parts of the dashboard.
Now with the new functionality of dynamic filters in SP1 for PerformancePoint, the content of a filter can be based on another filter. In my case I can redesign my dashboard by using just two filters for the situation above. Just link the filters together and let PerformancePoint filter the content for you. How easy can it be. One important thing for everyone who is upgrading from RTM to SP1: redefine your filter be simply step thru the wizard or else you cannot link the filters. Looks like the PerformancePoint items are notupdated automatically.
Jan Pieter Posthuma
My name is Jan Pieter Posthuma and I am a Microsoft Data Analytics consultant working for Rubicon, a local consultancy firm in The Netherlands.