Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

  • 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?

  • 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

  • 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?



Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.