I need to implement dynamic dependency for the filters inside webi report.
I can use "cascading prompts". But this will will be like (filter 2 dependent on filter 1, filter 3 dependent on filter 2).
But in my case I need all the filters to be interdependent to each other. This means at any time if I select any filter, other filters should show only those values available for selection (NOT ALL VALUES).
Could you please suggest me the best approach to achieve this requirement?
Saranga T A