Once auditing is configured, you can use BI Publisher to create your own reports to visualize your auditing data.
To create a report on your auditing data in BI Publisher:
Register the audit data source (JNDI/JDBC connection) that you created in the previous procedure as a JNDI data source in BI Publisher.
Because you created a JDBC connection registered as JNDI, you do not need to create a new JDBC connection by typing the connection URL, username/password, and so on. You can just register it using the JNDI name (for example: jdbc/AuditDB).
Run SQL queries against the BIPUBLISHER_V view to create data models.
To create a data model from your auditing data source:
For the complete guidelines for developing data models in BI Publisher, see Data Modeling Guide for Oracle Business Intelligence Publisher.
The following sample SQL query returns only BI Publisher audit data common to all event types:
Select IAU_EVENTCATEGORY, IAU_EVENTTYPE, IAU_EVENTSTATUS, to_char("IAU_TSTZORIGINATING", 'DD-MON-YYYY HH24:MI:SSxFF') as IAU_DATETIME, IAU_INITIATOR, IAU_RESOURCE, IAU_MESSAGETEXT from BIPUBLISHER_V;
Auditing records different attributes depending on the event category and type. You can create separate queries for each event type or category to fetch event category or type specific attributes.
The sample query below returns the audit records of resource access such as creating a report, deleting a data source, or renaming a folder. For a complete list of attributes recorded for each event type, see Audit Events in Oracle Business Intelligence Publisher.
SELECT IAU_EVENTCATEGORY, IAU_EVENTTYPE, to_char("IAU_TSTZORIGINATING", 'DD-MON-YYYY HH24:MI:SSxFF') as IAU_DATETIME, IAU_INITIATOR, IAU_EVENTSTATUS, IAU_FAILURECODE, IAU_MESSAGETEXT, IAU_RESOURCE, RESOURCETYPE, RESOURCESUBTYPE, NEWPATH, NEWNAME from BIPUBLISHER_V where IAU_EVENTCATEGORY = 'ResourceAccess'
Now you can use one of the BI Publisher's layout options to design the report layout and visualize the auditing data.
For complete instructions on using the layout editor, see Creating BI Publisher Layout Templates in Report Designer's Guide for Oracle Business Intelligence Publisher.