How to trace a SQL query back to BO user who issued it

[Former Member]

We have an Oracle 11g database and Business Objects user use this for reporting. We have identified queries that takes longest time to execute using Oracle DBA_HIST tables and found that theses are the queries issued by Web Intelligence or Crystal reports. Now we want to trace these queries back to the BO user who issued them. Oracle only gives the schema name which issued the query. I know we can use BO audit tables to track the user within BO but how to match Oracle DBA_HIST data to BO audit tables data. Or is there an another way of doing this?

Most of the crystal reports user query the database directly with their own queries without any universe, so use of END_SQL function to add the BO user name as a comment to all SQL statements is not possible.

Thanks for the help.

[Vidhya]

Hi Piyush,

Please check this, it mighty be will be helpful,

https://blogs.sap.com/2014/12/23/deep-dive-into-the-bi-4x-audit-data-model/

https://answers.sap.com/questions/85021/bo-42-how-to-query-a-webi-report-in-the-audit.html

Regards,

Vidhya.C