Author: Joyce Zhou
When users first open a Dashboard, Form Filters are set to the default members configured in the Modeler. After users save their edits and additions to the Dashboard, all filter selections are saved and associated with that App going forward.
The saved filter settings for an App are stored to the dbo.[Filter_Planning] table. Currently, the only mechanism to shift existing filters to a new member is to update the dbo.[Filter_Planning] table.
1. Open SQL Server Management and Studio and connect to your server.
2. Select New Query and enter an update query.
Here's an example query to update the Scenario Dimension:
SET Selected = N'[Scenario].[Scenario].&'
WHERE Selected = N'[Scenario].[Scenario].&'
3. Select Execute.
Once the table is updated, users will see the latest setting once they open the updated App.