EDIT: Original issue resolved (thanks @aaron.roma) . However…
If you have placed a DB restriction on a a user, if there are no results due to the restriction, it would be great if the alert was hidden from view. I.e. if the user does not have access to the data, why show the alert as its not specific to them?
Also, there are times when the opposite is true. I.e. you want to display a global KPI for all to see (I.e. Sales Percentage growth for entire business), but they dont have access due to restrictions.
This suggestion should also be considered for favourites as I have had the need in the past to show a “global” favourite which I cannot do, as the “run as” option is missing which we use in dashboards.
So the suggestion is:
- Hide alerts if the user has no means of seeing the data. In the design of the alert “Hide if no records”
- Have the “Run As” option the same as in widgets, this will allow you to override the DB security if it is for a global KPI that you want them to see, but not analyse.