Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multiple audit records per one report refresh

We use BO XI R3 on Windows with CMS on DB2.

I need to create audit reports on BO report usage with following data:

username, timestamp, duration, report name for DeskI and WebI reports.

I use auditing on DesktopIntelligenceCacheServer and WebIntelligenceProcessingServer.

The problem is that I'm getting multiple records in AUDIT_EVENT table with different event_ids and timestamps per one refreshed report.

Following SQL brings 2 records from WebI server all the time (first with duration=0) and from 1 to 5 records from DeskI server, all of them with real report duration.

SELECT

start_timestamp,

ae.EVENT_ID,

user_name,

duration,

object_type,

detail_id,

detail_text

FROM BO_XI_R3.AUDIT_EVENT ae,

bo_xi_r3.AUDIT_DETAIL ad,

bo_xi_r3.EVENT_TYPE et

where ae.EVENT_TYPE_ID=et.EVENT_TYPE_ID

and ae.EVENT_ID=ad.EVENT_ID

and ad.DETAIL_TYPE_ID=8

and ae.EVENT_TYPE_ID=19

order by 1;

How to separate unique refresh info?

Edited by: Valentin Volk on Oct 3, 2008 9:03 PM

replied

Hi Valentin,

The BO CMS stores the audit record for the reports with refresh duration = 0 by default. We had the similar situation and always we used to append REFRESH_DURATION != 0 in our audit sql, thus removing the duplicates from the audit query output.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question