Skip to Content
avatar image
Former Member

Can I getmemberlist that sorted like datasource in design studio

Hello, everyone.

Have you faced this qustion?

I've sorted a mearsure by Des,and the demission also set "only values with posted data".Like picture one.

but when I use DS_2.getMembers("VKBUR", 10) ,I can get 10 members,but those values wasn't I wanted.All of them was not I wanted that sorted in datasource.Like picture two.

My version is 16.4.0,datasource is OLAP.

Waiting for your help!

Thanks.

Jing

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 28, 2017 at 10:12 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vidhya V

      I have sorted my data source by dimension, but getMembers() still brings up the same set of values, which are random.

      Can you please show a screenshot of your example, perhaps I am missing something?

  • Mar 28, 2017 at 11:08 AM

    Hi,

    looks like a condition -> bottom 10 -> try to apply such a condition and then do get.members

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 29, 2017 at 09:29 AM

    Jing,

    If you can't set bottom 10 condition on your data source (sorry, I'm no HANA expert, so can't help with that) then you may need to resort to writing some JavaScript to sort your members in the correct order. Please have a look at this thread which shows code for sorting top 5 members. You will need to tweak it for you 10 bottom example:

    https://archive.sap.com/discussions/thread/3699715

    Add comment
    10|10000 characters needed characters exceeded