Sorry if posted before, couldn’t see a topic. A suggestion I would like to put forward is to allow the dashboard designer to place an overriding filter for a dashboard which is using the common dimensions.
Note this is not security, rather we want to reduce the dashboard down to a specific area of the dashboard and all widgets want to be pre-filtered with this criteria.
Although currently we could either add these as criteria at the top of the dashboard, it is a manual process for the user to do. Alternatively we have to place the filter on each widget. It would be beneficial if we could have a place on the dashboard design override all the widgets from one location to apply the filters you need.
Real life example.
In financial statements from time to time we get instruction from finance to adjust the criteria of a specific hierarchy to include/exclude certain Financial departments. This means we have to update numerous dashboards and there associated widgets. By having a master criteria on the dashboard we could get it to be already pre-filtered without the several widget adjustments.
The functionality already exists in Phocas when you create a shortcut link to another dashboard in the designer (placing a Parameter on the URL), it would be great if we had this option on the dashboard design as well, would save a lot of dev time.
How it could work
Perhaps an options button available to the dashboard owner/administrator.
Clicking on the gear cog would then show this dialog:
Since the dashboard will know the databases being displayed, the drop down would show the dimensions/measures associated.
If the user wants to remove the filter, they can do so by clicking on the “X” as normal, but the dashboard would be by default in the critiera we want to display.
Please let me know what you think.