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

Agents and Usage Tracking

Received Response
51
Views
5
Comments
Martin van Donselaar
Martin van Donselaar Rank 6 - Analytics Lead
edited Aug 13, 2024 5:53PM in Oracle Analytics Cloud and Server

Is it  possible to query Agent name, The analysis/analyses that where fired by it and Usage tracking measures such (Runtime, number of rows etc)?

I may have overlooked but this doesn't seem to be  possible to join this data together using the BIPLATFORM schema tables (OBIEE 12.2.1.2.0).

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    I don't have a DB with a RCU available right now so it's an answer based on what I remember ...

    There isn't a direct link (column = column) between the agents tables and the UT table.

    You can only try to go through the path of executed object.

    The real reference of what an agent execute is in the agent XML, in the DB you get it (in theory) also in the S_NQ_JOB_PARAM, but as it can be an analysis or a page you need to manage the various cases.

    Have a look in that direction (and will try to get my hands on a RCU schema)

  • Gianni Ceresa
    Gianni Ceresa Mod

    (missed a bit of my answer)

    If the agent send a page you will need to "solve" the 1 to many link between a page and objects, for that the scripts to parse web catalog you get from SampleApp 607 can help you getting this mapping.

    So you can link from agent name to agent analysis (via the agent ID) to UT (by the path) or from agent name to agent dashboard page (via the agent ID), from the page to analysis (via the SA607 scripts data) and then finally to UT (via the path).

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Thanks Gianni,

    I already checked this and unfortunately S_NQ_JOB_PARAM doesn't include the Dashboard Or Analysis name and/or path. That information seems indeed to be only available from the agent XML.

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Thanks, I will look into that. Will update on this but it make take me a few days.

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Haven't had time yet to look in to this further and there are more important issues now that I'm working on. I will mark this question as assumed answered for now.