Dependency filter - selecting options from a filter should affect options on the other filters

[Arpita_Solanki]

Hi,

Is there any way we can create dependency filter? I have two dimensions - Team(s) and Themes under Pages.

There are close to 70 themes and at a time, a team may have worked for only 5-6 themes. I want the Theme filter to show only those Themes so that I can select one instead of showing me all the Themes. So, basically hiding all the Theme options where that particular team hasn’t worked.

Thank you

[ilze.krauze]

Hi Arpita_Solanki,
Welcome to the eazyBI community!

Yes, in the Pages section there is an option Nonempty that limits dimension members for the page filter drop-down lists. The dependancy is based on the dimension order - the selected value on the left dimension will limit the value lists for all dimensions on the right.

I hope this helps.

Kindly,
Ilze