I need your help. I struggle to find a good solution for the below problem.
We have data that is secured on UserId level – Source Filter is applied to all reports. Whenever a user logs it, he can see only data that is relevant to him.
We have several dashboards that have multiple dependency in filters and some of the filters are mandatory, so the value always has to be returned into the filter for reports to run.
The problem is with ‘Default’ filter value. When you create a dashboard, you can pick only one SPECIFIC/STATIC default filter value. And it’s good if I have access to this let’s say region. However, when another user logs in and he doesn’t have access to a specific region that was used as a default value for the filter, dashboard doesn’t run as the ‘omit’ option that appears in the main filter doesn’t trigger the rest of the filters to populate.
Is there any way to set up default filter value on the Dashboard based on the userId (source filter)?
The only solution I found is to create a copy of the dashboard, set up default filter value that is relevant to the user and then secure this dashboard for this user.
However this solution becomes unmanageable nowadays. If I have 25 users with access to 25 different regions, I have to maintain 20 versions of similar dashboards and security around it. Any suggestion will be highly appreciated.
3rd Floor, 20 Council Street, Hawthorn East, Victoria, Australia 3123
Tel +61 3 9804 2200 Fax +61 3 9804 2299 Dir +61 3 9804 2200 Mob +61 424 936 773
Tank Integrity Solutions For Those Who Know
Disclaimer: The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on it is prohibited and may be unlawful