Skip to Content
0
Former Member
Aug 04, 2016 at 09:05 PM

Cascading DropDown's not working

75 Views

Hi All,

I am creating a cascading drop-down's on a single data source. (Data Source is Universe).

1) Created 3 drop downs box's SALES_ORG, SALES_OFFICE, SALES_ORG, and a cross tab.

2) On application StratUp used the following script

SALES_ORG.setItems(DS_1.getMemberList("_U8n991j0Eea90s6DE4t_Rw", MemberPresentation.TEXT, MemberDisplay.TEXT, 100,"All"));

SALES_OFFICE.setItems(DS_1.getMemberList("_Wbxcg1j0Eea90s6DE4t_Rw", MemberPresentation.TEXT, MemberDisplay.TEXT, 100,"All"));

SALES_GROUP.setItems(DS_1.getMemberList("_Zghm81j0Eea90s6DE4t_Rw", MemberPresentation.TEXT, MemberDisplay.TEXT, 100,"All"));

3) Used the following script in the drop-down's OnSelect

1st drop down SALES_ORG onSelect : DS_1.setFilter("_U8n991j0Eea90s6DE4t_Rw", SALES_ORG.getSelectedValue());

2nd drop down SALES_OFFICE onSelect : DS_1.setFilter("_Wbxcg1j0Eea90s6DE4t_Rw", SALES_OFFICE.getSelectedValue());

3rd drop down SALES_GROUP onSelect : DS_1.setFilter("_Zghm81j0Eea90s6DE4t_Rw", SALES_GROUP.getSelectedValue());

2nd and 3rd drop-down's not filtering based on the value selected in the 1st drop down.

Is some thing wrong with my code? How to achieve Cascading Drop-Down's

Environment: Design Studio 1.6

Data Source : Universe (Business Objects 4.1)

Note: I searched some existing SCN pages, but it didn't help

Thanks,

Kumar.