Skip to Content
author's profile photo
Former Member

Needs rows to be listed in a particular order(not ascending or descending)

Hi Friends,

I want rows to be listed in a particular order(not ascending or descending) when running a BEX query. for example, if there is a characteristic called name with the following values a,b,c,d , then i want it the rows in the output to be listed like a,d, b,c (not a,b,c,d or d,c,b,a). Can anyone help.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Mar 19, 2007 at 10:45 AM

    I think the only way to do that is to build a hierachy in wich you insert all the possible value in the order you like.

    If exist a logic, you can use this logic at loading time to set an order fields to be used in reporting.

    Hope it helps.

    Regards

    PS: assign points is the way to say thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      You create an hierarchy in BW. In BEx you may create a structure with the selections. The last mean is more rigid. The first one is more flexible - you may create several hierarchies and choose them during the query execution (through variable on hierarchy).

      Best regards,

      Eugene

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 02:28 PM

    solved

    Add comment
    10|10000 characters needed characters exceeded