Hi all,
I know this might seem a bit backwards but I want to set the select-able values of a prompt to the values that exist in an analysis.
I have set up an analysis which works out what access each logged in user has dynamically based on session variables and some fancy filters.
What i'm left with is a table that has the username in one column and a list of units that they have access to.....
eg:
| Username | Unit |
|---|
| Bob | 1234 |
| 5678 |
| 9876 |
| 5432 |
Reports that need to use this access will have a filter based on the above analysis where unit = "any unit in the above analysis".
This works great and means I have a central analysis which controls user analysis.
The problem is when I add the analysis to a dashboard and want to control it using a dashboard prompt.
If I include the unit column in the dashboard, there is no (obvious) way of me limiting it to only show the values in the analysis above.
I could potentially put the same logic i've got in my analysis in each dashboard prompt using "SQL" but I don't want to have to do it every time I create a dashboard.
Any help would be greatly appreciated.
Cheers,
Adam
