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.