BI Publisher Report Inputs

Question

Summary

Content

Hello Guru,

Version:  Obiee 12C (12.2)

Database: Oracle 11g

We have a report with Employee Id, Employee Name, Employee SSN and report is accessed by multiple users. (Example: User A, B, C..)

Prompt - SSN

We would like to capture what user entered in Prompt (i.e. we would like to track or create report with user id, ssn entered and store this in db table)

Please post your inputs and thoughts to meet this requirement.

Thanks.

Sherry George · Answer

You can enable BI publisher auditing, but not sure if it helps with your requirement. Take a look below if you haven't already.

https://blogs.oracle.com/xmlpublisher/entry/how_to_audit_and_monitor_bi_pu

ArijitC · Answer

If the underline database is oracle, then you can use DBMS_FGA - Oracle Fine Grained Auditing. That can log every query run against Employee table.

Thanks

Arijit