Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need to Extract User sessions report " Running / Finished / Cancelled " on Daily Basis in OAS

Accepted answer
21
Views
2
Comments
User_DLT8W
User_DLT8W Rank 1 - Community Starter
edited Aug 13, 2024 7:31PM in Oracle Analytics Cloud and Server

Need to Extract User sessions report " Running / Finished / Cancelled " on Daily Basis in OAS (Oracle Analytics server )

Best Answer

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod
    Answer ✓

    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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited Jul 8, 2024 7:18AM

    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…