BI Publisher (MOSC)

MOSC Banner

BI Publisher Audit Table IAU_BASE

edited Mar 7, 2014 12:00PM in BI Publisher (MOSC) 5 commentsAnswered

Hello,

I have enabled auditing for our BIP environment (part of OBIEE) and I can see the IAU_BASE and XMLPSERVER being populated with records.

I was wondering if there's any documentation on what some of the columns in these tables are supposed to be. Most are self explainatory, but for instance in XMLPSERVER there's IAU_STARTDATE/ENDDATE columns which are not populated at all. Also, there's a column IAU_PROCESSTIME which is populated with some numbers but what's the unit? Is it in milliseconds?

I also noticed that IAU_BASE.IAU_EVENTTYPE = ReportRequest has the User_id of the user who started the report but this record does not have the XMLPSERVER.IAU_PROCESSTIME populated. And, event category of ReportExecution (with event type of ReportRendering, ReportDataProcess) that have the processtime populated don't have the user_id populated. There seems to be no way to associate for a given user how much time did a report take.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center