A design pattern that may help you link to dashboards from existing systems is passing filter values in the URL. For example:
Although this pattern’s as old as the web, you asked us to make PerformancePoint dashboards work with it. In SharePoint 2010 it works!
The steps are the same whether you deploy a page that uses only PerformancePoint web parts using Dashboard Designer, or build a more complex page using SharePoint web or SharePoint Designer.
To illustrate we’ll add URL filtering to a simple dashboard that has one PerformancePoint Report web part.
We will specify Geography on the URL:
The Query String (URL) Filter accepts the name and value parts, separated by an equals sign, and multiple filters separated by a semi-colon (this is quite common and not unique to SharePoint.)
You’ll have full control over the name part. We’ll explain how to specify it in the next step.
The value depends on the web part the value’s passed to. In the case of PerformancePoint Services web parts you’ll need a member unique name for the data source(s) referenced by the content.
Unfortunately a Query String (URL) filter and another filter can’t be synchronized with the same consumer field of a web part. Although you can connect more than one filter web parts to the same consumer field, this won’t result in the multiple filters being synchronized with the field. You will have to choose one mode or the other.
We laid out the analytic chart “Local Sales Report” in Dashboard Designer. The only detail of interest is we put the Geography hierarchy in the Background well so we can connect filters to it in SharePoint.
If you’re going to do URL filtering we recommend you do your page editing outside Dashboard Designer. Dashboard Designer’s web part page deployment is very simplistic and removes all changes not possible within Dashboard Designer, including URL filtering.
For this example we didn’t use Dashboard Designer at all except to create “Local Sales Report.” We started with a blank web part page, added the PerformancePoint Report web part, then configured it to show “Local Sales Report.”
For each query string parameter you want the page to have:
For each web part you want the filter to affect:
John Hall & Wade Dorrell SharePoint BI
(Please note that to simplify all URL examples, we’ve left the value parts un-encoded. RFC 3986 requires that most characters in this part of a URL, notably space, [ and ], be encoded in a specific way that’s not particularly human-readable. If you don’t encode values in real applications, as the URLs are passed along they often get truncated at the space or garbled.)