Prompt values based off the results of an analysis

Adam Wickes

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

[Deleted User]

why not just have those values written into their own, bespoke session variable? Bob's your uncle.

Adam Wickes

So put the logic into a init block?
That does make a whole lot more sense doesn't it.
I'll give it a go and report back.

Cheers Christian

Adam Wickes

So yeah... Putting the logic from the analysis into a session works like a charm. Not sure why I made it so difficult for myself.

Thanks again Christian!!

[Deleted User]

You're welcome! Sometimes our brains just insist on taking a convoluted path rather than a straight line