Lumira Cascading Filter error

[Former Member]

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