Sorting Hierarchy Columns

User_D31JQ

Hello Experts

Is there way to sort hierarchical column in OBIEE.

+Total Rev

     +Service Rev

          Usage Rev

          Subs Rev

          Other Rev

     + Eqip Rev

Here I want Subs -> Usage ->  Other Rev.

Can you pls. suggest.

Gianni Ceresa

Did you try setting the "sort order column" in the logical column representing that level of your hierarchy?

Because for a random sort like the one you want there aren't miracles, you have to provide a column which does the sorting ...

User_D31JQ

Hi Gianni

Thanks I tried bringing in the hierarchy code columns pertaining to that level and included the sorting by writing the case.. when. But that didn't help in sorting that column.

Also tried including the sort order in the logical column in rpd ... but that didn't help either.

Any more suggestions pls....

[Deleted User]

What version are you actually on?

User_D31JQ

Hi Christian

it is OBIEE 12C.

User_D31JQ

Any suggestion pls.

[Deleted User]

I just built an example in my own environment and it works perfectly fine:

This is vanilla. Now I create a fake sort:

Result in attrib column

Result in hierarchical column:

Works. Your config must be wrong.