Dear Experts,
I have 5 dimension filters (Dropdown) in my lumira document in lumira designer 2.2.
1. 0SALESORG
2. 0CUST_GRP
3.0DISTR_CHAN
4.0SALES_OFF
5.0SALES_GRP
When I select 5.dimension filter then automatically values in 4, 3 , 2 and 1 dimension filter get filtered out. my following script worked fine.I have 2 Datasource (DS_FILTER, DS_BW_QUERY)
my problem; I can't see the values "ALL" (#). it did not work.
Another Problem; If the user only has "0sales_off" authorization, query variable is not set up. document was not updated.
any correction?
Startup :
DROPDOWN_SALESORG.setItems(DS_FILTER.getMemberList("0SALESORG", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 50, "ALL")); DROPDOWN_CUSTGRP.setItems(DS_FILTER.getMemberList("0CUST_GROUP", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 50, "ALL")); DROPDOWN_DISTR_CHAN.setItems(DS_FILTER.getMemberList("0DISTR_CHAN", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 50, "ALL")); DROPDOWN_SALES_OFF.setItems(DS_FILTER.getMemberList("0SALES_OFF", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 50, "ALL")); DROPDOWN_SALES_GRP.setItems(DS_FILTER.getMemberList("0SALES_GRP", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 50, "ALL"));
Dropdown_0sales_grp:
DS_FILTER.setFilter("0SALES_GRP", DROPDOWN_SALES_GRP.getSelectedValue()); DROPDOWN_SALES_GRP.setItems(DS_FILTER.getMemberList("0SALES_GRP", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 100, "ALL"));
Dropdown_0sales_off:
DS_FILTER.setFilter("0SALES_OFF", DROPDOWN_SALES_OFF.getSelectedValue()); DROPDOWN_SALES_OFF.setItems(DS_FILTER.getMemberList("0SALES_OFF", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 100, "ALL")); DROPDOWN_SALES_GRP.setItems(DS_FILTER.getMemberList("0SALES_GRP", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 100, "ALL"));
Dropdown_0distr_Chan:
DS_FILTER.setFilter("0DISTR_CHAN", DROPDOWN_DISTR_CHAN.getSelectedValue()); DROPDOWN_DISTR_CHAN.setItems(DS_FILTER.getMemberList("0DISTR_CHAN", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 10, "ALL")); DROPDOWN_SALES_OFF.setItems(DS_FILTER.getMemberList("0SALES_OFF", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 100, "ALL")); DROPDOWN_SALES_GRP.setItems(DS_FILTER.getMemberList("0SALES_GRP", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY, 100, "ALL"));
end another....
Thanks alot
Sascha