Sorting Hierarchy Columns — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sorting Hierarchy Columns

Received Response
31
Views
6
Comments
User_D31JQ
User_D31JQ Rank 2 - Community Beginner

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.

Answers

  • 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
    User_D31JQ Rank 2 - Community Beginner

    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]
    [Deleted User] Rank 2 - Community Beginner

    What version are you actually on?

  • User_D31JQ
    User_D31JQ Rank 2 - Community Beginner

    Hi Christian

    it is OBIEE 12C.

  • User_D31JQ
    User_D31JQ Rank 2 - Community Beginner

    Any suggestion pls.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

    pastedImage_0.png

    pastedImage_1.png

    pastedImage_2.png

    This is vanilla. Now I create a fake sort:

    pastedImage_3.png

    pastedImage_4.png

    Result in attrib column

    pastedImage_5.png

    Result in hierarchical column:

    pastedImage_6.png

    Works. Your config must be wrong.