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:

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