Skip to Content
0

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

Dec 04, 2017 at 09:29 AM

35

avatar image

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

10 |10000 characters needed characters left characters exceeded

Hi Robert,

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

0

capture.jpg

Thanks Mustafa for your response

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

capture.jpg (199.9 kB)
0

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?

0

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

0

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.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers