Skip to Content
avatar image
Former Member

cascading functinlaity for filter panel (DS 1.6)

Searched blogs before posting

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



k1ljw.png (7.7 kB)
Add comment
10|10000 characters needed 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());



  • Get RSS Feed

1 Answer

  • Dec 16, 2016 at 03:31 PM

    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.



    Add comment
    10|10000 characters needed characters exceeded