Populating Dimension Members in drop down on initialisation of application.

[former_member624923]

Hello Gurus,

I am faced with the difficulty of populating the dropdown box of an analytical application on initialisation of the application. I am able to get the members of the Country dimension into the dropdown box on initialisation. It however populates all the master data country members in the country info object in the dropdownbox. I do not need all the country members but only the country members available in the model. I have attached my script for more understanding of the problem.

Script

//Populate Dropdown with Country Dimension

var i=0; var Dimension =Chart_2.getDataSource().getMembers("ZCNTY_SH");

for (i=0;i< Dimension.length; i++) { Dropdown_1.addItem(Dimension[i].id,Dimension[i].description);

}

Can someone be of help to me on this?. I get all the masterdata information from the backend into the dropdown on initialization.

[former_member624923]

Problem Solved.. Thanks Van for taking time to look at my question.. Appreciate it.

[former_member692417]

Hi Can you guide, how you did this?

[former_member223908]

Can you please help us with the solution?

[mfoeken]

Hi Bright,

Which data source are you using? Maybe you should read the dimension members from your fact table?

Kind regards,

Martijn van Foeken | Interdobs

[former_member624923]

Hello martin,

I am using a live connection with the data coming from a query. i get all the master data dimensions from the info object which I dont need all but only those used in the model. Is there e a way around this with java script maybe.

Kind Regards

Bright