Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Hierarchy Ordering

Accepted answer
38
Views
2
Comments
GTA
GTA Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Hi Team,

Im using OAC and building hierarchy like below

scenario.png

I need to sort the above order to below

ROOM DEPARTMENT
OTHER OPERATING DEPARTMENTS(OOD)
F&B DEPARTMENT

Is it possible to sort the order or control the order of the nodes in OAC?

Regards

Tagged:

Best Answer

  • [Deleted User]
    [Deleted User] Mod
    Answer ✓

    Hi @GTA

    You have to define a Sort Order column in the RPD which holds that sequence.

    image.png

    In your case you'd have a sort order column which yields

    0 for ROOM DEPARTMENT

    1 for OTHER OPERATING DEPARTMENTS(OOD)

    2 for F&B DEPARTMENT

    …and so on. You can create the corresponding CASE WHEN in a new logical column as the column formula and then use said column as the sort order column for your display column.

Answers