How to dynamically populate a multiselect listbox to only contain dimensions with a measure value

[rnuma]

Hi experts

I am trying to populate a multiselect list box to only contain a dimension with a measure value. Any dimensions with a null value should not be available on the list. This is the code am currently using to populate the listbox with all of the available dimensions

CATEGORY_TYPE_SELECT.setItems(DS_1.getMemberList("ZMATERIAL__ZCATEG_ID", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 20,"ALL"));

Thanks for your support

[MustafaBensan]

Hi Robert,

Can you post a screenshot of the Initial View of data source DS_1?

[rnuma]

capture.jpg

Thanks Mustafa for your response

Please attached screenshot of the initial view of the data source as requested.

[MustafaBensan]

Hi Robert,

Your data source initial view does not include dimension ZMATERIAL__ZCATEG_ID in either the Columns or the Rows, so how do you define "dimensions with a null value" in this context?

[rnuma]

Hi Mustafa,

CATEGORY_TYPE_SELECT.setItems(DS_1.getMemberList("ZMATERIAL__ZCATEG_ID", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 20,"ALL")); was defined as part of the Event On Startup script for the Dashboard

[MustafaBensan]

Hi Robert,

I understand that the script code loads all member values of dimension ZMATERIAL_ZCATEG_ID. What I don’t understand is your requirement that “Any dimensions with a null value should not be available on the list” when this dimension is not even in the initial view of the data source. Perhaps you can be clarify what you are trying to achieve with some screenshots of your application?

Regards,

Mustafa.