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

    Regards,

    Mustafa.

  • Get RSS Feed

0 Answers