Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Hierarchy Ordering
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
Best Answer
-
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.
2
![[Deleted User]](https://us.v-cdn.net/6037859/uploads/defaultavatar/nT2GKTLRQJ3P1.jpg)
Answers
-
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!
0
