BusinessObjects Board

Taking all members of calendaryear and adding to dropdownBox

Hi Experts,

I am developing a dashboard in Lumira designer and Backend source is BEX.
BEX is using Calendar year as a mandatory prompt.
I need to supress this prompt for my dashboard.
To do this I made “Load in scripts” true and wrote following code on Application start up

DS_1.loadDataSource();
//
DS_1.setVariableValueExt(“ZYEAR”,“2019;2018;2017;2016;2015”);
//
DS_1.reloadData();

I can supress the prompt only if I provide the fixed values for years. I don’t want this. I want to add all years from the BEX to my dropdown box without asking fro prompts.
I used the getMembers function to get all years and the using ForEach function to add the years to my dropdown box. But no success.
Can anyone help me please?

Any help will be appreciated.

Thanks!!!


Afreen (BOB member since 2016-10-25)