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
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.
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!
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
![Photo of [Deleted User]](https://us.v-cdn.net/6037859/uploads/defaultavatar/nT2GKTLRQJ3P1.jpg)
