Need to Extract User sessions report " Running / Finished / Cancelled " on Daily Basis in OAS (Oracle Analytics server )
Hi @User_DLT8W ,
Have you already tried to setup and use Usage Tracking to achieve your goal?
SUCCESS_FLG column tells you about the completion status of the query (successful, timed out, failed). END_DT and END_HOUR_MIN columns are null when a query is still running. I'm not 100% sure that you can track canceled queries as well, probably a combination of SUCCESS_FLG and ERROR_TEXT columns should provide you with this information.
Welcome to the forum,
User sessions report " Running / Finished / Cancelled "
Can you be a bit more explicit in what you are looking for?
Is that a question? What is a report for you? A report is generally a Publisher report, or you mean a "classic" analysis or maybe a DV workbook? What would the status be related to?
Also keep in in mind that in a community forum, the time you invest in writing a question is generally the time you could expect people to invest of their own free time to post a reply…
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
