Skip to Content
0

cascading functinlaity for filter panel (DS 1.6)

Dec 16, 2016 at 01:33 PM

47

avatar image

Searched blogs before posting

https://archive.sap.com/discussions/thread/3847924

HI Experts,

can we achieve cascading functionality for filter panel ?

i have filter like below

when i select profit center i need to get corresponding Sales org and so on

but i don't see such kind of functionality in design studio do we need to see for any workaround with scripting

any help really appreciated

Thanks,

Varun

k1ljw.png (7.7 kB)
10 |10000 characters needed characters left characters exceeded

Hi Varun,

check once below script,

Set up cascading filter in an Application:

Application script://Enable DROPDOWN1,DROPDOWN2 and ALL display in DROPDOWN//

DROPDOWN_1.setItems(DS_1.getMemberList("0CALYEAR", MemberPresentation.EXTERNAL_KEY, MemberDisplay.TEXT, 20,"ALL")); DROPDOWN_2.setItems(DS_1.getMemberList("0CALMONTH2", MemberPresentation.EXTERNAL_KEY, MemberDisplay.TEXT, 20,"ALL"));


DROPDOWN1://Year as a Prompt//

DS_1.setFilter("0CALYEAR", DROPDOWN_1.getSelectedValue()); DROPDOWN_2.setItems(DS_1.getMemberList("0CALMONTH2", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 20,"ALL"));


DROPDOWN2 : //Month as a Prompt //

DS_1.setFilter("0CALMONTH2", DROPDOWN_2.getSelectedValue());

Thanks,

sekhar

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Poovarasan Boopalan Dec 16, 2016 at 03:31 PM
0

Hi Varun,

I think you can use auto apply option to get the cascading feature in your filter panel.

Or You have to use multiple dimension filter or dropdown components to achieve this.

Thanks,

Poovarasan

Share
10 |10000 characters needed characters left characters exceeded