I need to calculate based on one column.
Table have below information.
Facility, Nurse Unit, Count, Avg Hours, min, Max,
Slightly old video but could be a good reference https://www.youtube.com/watch?v=MNgWJyQ-kbo
@Lalitha Venkataraman-Oracle thanks for sharing link.
But i am not able to calculate percentile based on above explanation
If the inbuilt function doesn't give you what you want, then you'll need to explore one of the other options (see previous posts) to see which works for your scenario.
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
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?
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
I am getting syntax error when im trying to add full table hint in evaluate for an obiee report analysis column. This is the function im adding the below: why isnt the syntax working, what is missing or incorrect here in the function?
Hello everyone, We use OBIEE 11.1.1.9, on Oracle Linux. We have set up Usage Tracking. It shows users but it misses some of them. How can I see all users?
