cancel
Showing results for 
Search instead for 
Did you mean: 

Cascading Filter in Dimension Filter using Universe

Former Member
0 Kudos

Hi Experts,

I have very basic function as a requirement.

I have two dimensions used in my Dimension filter (Origin Country and Origin Port).

Both dimension uses same data source (DS_1), if i filter US in my Origin Country dimension filter, i would expect to see only Port belong to US but thats not the case.

I am seeing all the values for the Origin port. I even tried to pass the country value to DS_1 in "On Apply" but didn't work.

I have read few blogs and found this is the limitation for universe.

This is so frustrating because we have sign off the requirement that this basic functionality will work but it end up works only for BW

Dropdown box is not an option because we want to select multi values.

Any Thoughts/recommendation/work around?

Thanks

VJ

Accepted Solutions (1)

Accepted Solutions (1)

MustafaBensan
Active Contributor
0 Kudos

Hi Vijayamohan,

A couple of questions:

1) What version of Design Studio are your running?

2) Have you set the Members for Filtering option for dimensions Origin Country and Origin Port to "Only Values with Posted Data" in the data source initial view?

Regards,

Mustafa.

Answers (2)

Answers (2)

former_member276213
Active Participant
0 Kudos

Hello Vijay,

I have replicated your scenario which is working for me, you can also try some thing below.

1.In the start up scrip write set items to pass the values to your country and port.

LISTBOX_1.setItems(DS_1.getMemberList("COUNTRY", MemberPresentation.EXTERNAL_KEY, MemberDisplay.TEXT, 800,"ALL")); LISTBOX_2.setItems(DS_1.getMemberList("PORT", MemberPresentation.EXTERNAL_KEY, MemberDisplay.TEXT, 800,"ALL"));

2.In the on select for Listbox_1 you can write below script

DS_1.setFilterExt("COUNTRY", LISTBOX_1.getSelectedValue());

LISTBOX_2.setItems(DS_1.getMemberList("PORT", MemberPresentation.EXTERNAL_KEY, MemberDisplay.TEXT, 800));

3.Out put will be some thing like attached.If you select one country from list box 1, then it will display respective port relevant to the selected country.

listbox.png

BR,

Lakshmikanth Adharapurapu

Former Member
0 Kudos

Hi Mustafa,

Thank you for your response and time.

We are using DS 1.6 SP4.

I set the members for filtering to "Only Values with Posted Data" and it worked 🙂

Thank you so much for your help.