Hierarchy Ordering

GTA

Hi Team,

Im using OAC and building hierarchy like below

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

[Deleted User]

Hi @GTA

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

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.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24413/hierarchy-ordering

Hi @GTA,

Quick Question:

Have you tried doing the re-ordering in Semantic (RPD) layer? If yes, what issues are you getting?

If possible share the screenshots for better understanding.

Thank you!