Oracle Analytics Cloud and Server

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

How to know Report Name via Usage Tracking

Accepted answer
44
Views
2
Comments
Saroj Kumar Behera
Saroj Kumar Behera Rank 5 - Community Champion

Hi Team,

We already do have usage tracking in OAC.

But wanted to understand - how to know exact report name used by User.

Can it be viewable through Usage tracking, let me know.

Thanks

Saroj

Tagged:

Best Answer

  • Gianni Ceresa
    edited May 26, 2025 3:17PM Answer ✓

    Hi Saroj,

    If you look at the second link posted above you see the meaning of (most of) the columns in your usage tracking.

    If you focus on the columns of the "Query Origin-related Columns" part in the doc, you have all the elements to get the exact name of the catalog object that generated the query. SAW_SRC_PATH is probably what will give you the exact info (I don't have a UT schema handy to just have a look inside to be 100% sure…).

    I believe DV does record infos in a bit of a "different" way, because in a single DV workbook you have canvases and multiple visualizations, each generating a query. But everything is there, maybe requiring to manipulate those columns a bit to split the info into individual elements (DV workbook path + canvas name + visualization name/number).

Answers