DROPDOWN all shows wrong data in sap BO Design Studio 1.6

[chandrasekhar6]

Hi

We have data source contains Years: 2011,2012,2013,2014,2015,2016,2017

We have applied to background filter the data source level(2011,2012,2013,2014)

We are showing in the dropdown grater than 2014 values.

and I was removed 2011,2012,2013 and 2014 at On Startup.

and execute the application,in drop-down getting ALL_YEAR,2015,2016,2017.

and when I select ALL_YEAR then shows remaining all years data in charts.

How to restrict unwanted data through dropdown,

Please help me in the above error.

Thanks,

Chandrasekhar

[TammyPowlas]

Can you show your code at startup?

[chandrasekhar6]

Hi Tammy,

We are calling items from not in on startup.

We have 2 dropdowns, In dropdown1 I have written the below script:

DROPDOWN_3.setItems(DS_EQUIPMENT.getMemberList("0CALYEAR", MemberPresentation.EXTERNAL_KEY, MemberDisplay.TEXT, 10,"ALL"));


DROPDOWN_3.removeItem("#");
DROPDOWN_3.removeItem("2000");
DROPDOWN_3.removeItem("2001");
DROPDOWN_3.removeItem("2002");
DROPDOWN_3.removeItem("2003");
DROPDOWN_3.removeItem("2004");
DROPDOWN_3.removeItem("2005");
DROPDOWN_3.removeItem("2006");
DROPDOWN_3.removeItem("2007");
DROPDOWN_3.removeItem("2008");
DROPDOWN_3.removeItem("2009");
DROPDOWN_3.removeItem("2010");
DROPDOWN_3.removeItem("2011");
DROPDOWN_3.removeItem("2012");
DROPDOWN_3.removeItem("2013");
DROPDOWN_3.removeItem("2014");
DROPDOWN_3.removeItem("2015");


DROPDOWN_3.onSelect();

Thanks,

Chandrasekhar