Always Display Default Filter Selection in Dashboards


By default, dashboard filters remember the last selected item between sessions. This means user selections will be remembered, even if the dashboard is closed and reopened. For example, Anna opens the dashboard the first time and selects Illinois for District:

clip_image002

The dashboard content is updated for Illinois. Anna finishes her analysis session and closes her browser. The next week, Anna returns to the dashboard to see how her district is performing. Because her previous selection is remembered, Anna doesn’t have to select Illinois again to filter the dashboard:

clip_image004

In some cases, you may want to disable this capability to allow the default filter selection to be used anytime the dashboard is opened. In our example above, the District filter would display “All” anytime the dashboard is opened. Anna’s selection would not be remembered.

The following steps explain how to disable filter persistence in PerformancePoint Server:

1) Open Microsoft SQL Server Management Studio and connect to the Database Engine where the PPSMonitoring database is located.

2) Check to see if there are any saved parameter values in the ParameterValues table.  Remove these entries if they exist by executing the following:

image

2) Expand Databases > PPSMonitoring > Programmability > Stored Procedures.

3) Right-click dbo.ParameterValuesCreate and select Modify.

4) Comment out the following section of code, as shown in these images:

Start Comment Code

clip_image006

End Comment Code

clip_image008

5. Click Execute to make the changes.

clip_image010

 

NOTE:  You will also need toremove the saved values in the database

To enable filter persistence again, remove the comment markers from the code and click Execute.

 

Elaine Andersen (elainean@microsoft.com)


Comments (6)

  1. By default, dashboard filters remember the last selected item between sessions. This means user selections

  2. Ahmad Elayyan says:

    but if we update any thing in the PPS Database, it will be not supported from Microsoft any MCS is not response for any updates into the PPS Database.

    so it’s not efficant way to solve the Problem.

    also i can change the XML to solve this problem insted of update the SP from PPS Database.

  3. Josh Unger says:

    In PerformancePoint 2010, you can do the same thing.  On the SharePoint database server, find "Performance Monitoring Service_GUID_HERE" and look for Programmability > Stored Procedures > proc_PPS_AddParameterValue.  The name has changed.

    Also, in PerformancePoint 2010, filter values are not saved for an Anonymous SharePoint site.  You won't need to disable filter persistence.

  4. Ashish Kum says:

    Ahmad, could you tell me the name and location of the XML file that can be used to change filter persistence settings?

  5. SS says:

    From the above steps we can remove the defualt. But is it possible to then set to a default value like 'all'?

  6. abohra says:

    Hi,

    I have the same issue, performance point filters remember the previously selected value and we don;t have any option to dispaly all data in scorecard if we have selected any option in filter? do anyone have any solution for this?

    I have a performancee point filter which is connected to a scorecard , when i select a value from filter say "abc" it display the abc record in scorecard , now if i want to show all the rows from scorecard i don't have any option? any sugggestion.

    Thaks in advance.