I have a PPS filter that I added to a PerformancePoint Dashboard. The default field for the filter was selected. When the dashboard is deployed through Dashboard Designer and viewed, the filter does not display the default field but rather it displays the value that was last searched by the user.

I've tried clearing the browser history, cookies, etc because I figured that the filters were being saved based on that BUT I was wrong. The filter value that was selected last is still shown not the default value.

Thanks in advance!


To make sure I'm understanding this right -- you've got a filter with a particular set of values, one of which you've set as the default value. When you open up the dashboard, you're seeing that the filter has its value set to the last value that the user selected, and not the default. Is that about right?

PerformancePoint filter values are saved to a database on a per-user, per-filter basis. This means that when you change a filter value in PPS, you can log back in later and still see that same value, even on a different machine. Default values are really only used before the user has had a chance to change the filter value -- so, this is basically the intended behavior.

If you'd like to default the filter to a particular value on page load, you might want to try a JavaScript based approach:

  1. Define the function 'NotifyBrowserOfAsyncUpdate(elem)', which PPS will call after any PPS render request completes (i.e., when your filter renders).
  2. Within the function, check that elem.control exists and then check that elem.control.webPartTitle equals your filter's title.
  3. If it does, search elem (the filter web part's main container DIV) for the actual filter control and change the value. If you're using a dropdown, this is pretty simple - just remember to call the 'onchange' method on the select as well so that connected PPS objects refresh.

You'll only want to perform this 'force update' once, of course.

Hope this helps!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.