OBIEE Dashboard Prompt Variable

Aspirer1234

But then the issue is while we select each prompt the report is getting refreshed everytime. My team doesn't need that.

[Deleted User]

So your team needs the prompts to not have buttons but not apply themselves to the analysis?

Say that out loud once and think about it...

KashSidd

I think there is a solution but its your call if its really worth it... Create your prompts as RPD View, join that View to the existing Star Schema with a proper relational join, create all your prompts using that View so you can use "Limit Values" option

[Deleted User]

"worth it".....wow that's a loooong shot