Skip to Content
avatar image
Former Member

GetMembers Method

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?

Thanks,

Robert

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 21, 2014 at 06:07 PM

    I thought about populating a listbox with the dimension values using the getMembersList method, and then looping through the values in the listbox. However, there is no foreach method associated with the listbox control.

    Can the listbox control be extended to contain a foreach method?

    Add comment
    10|10000 characters needed characters exceeded

    • I had seen that note before and knew there were restrictions on the APIs available for the HANA deployment.  You could also search under the category bi-ra-ad* from http://service.sap.com/notes

      The ListBox or Dropdown doesn't seem to have an option to read all the members to an array (for BIP deployment also).

      HANA deployment at this point definitely has lot of limitations, I am sure those will be fixed in the future releases.

      Thanks.