I am trying to get an array of a dimensions values in a data source alias. When using a universe as a data source, there is a function called getmembers that will return an array of a dimension's values. However, when I use Design Studio HANA and use a model as a data source, this method is not available. In fact, there are no data source methods that return a list of dimension values.
I was wanting to get a list of all the values of a dimension.
Then, I wanted to insert these values into three different listboxes. The first ten into listbox 1, the next ten into listbox 2, and the final ten into listbox 3.
This would be very simple, if I could assign the members to an array and then use the foreach method to loop thorough the values and assign them to the different listboxes.
I guess my questions are:
1. Is the getmembers method really gone for HANA data sources?
2. If it is gone, is there another way to populate an array from a data source?