As a admin, i would like to see and monitor who is running(refreshing) the reports on a particular webi server in a clustered environment. In CMC, we can only monitor the scheduled reports. Is there a option to monitor the manual refresh of the reports as well?
I do rely on the TOAD session browser to see how many queries are running on each webi server. But it doesn’t show any particular webi server being used if the report is being refreshed in Rich CLient.
How do you monitor the reports from within CMC or Business Objects?
I’ve done something along these lines - not sure how it would work in a clustered environment but this is the query I use (in Excel via LiveOffice - should work where ever though).
Result Objects
Activity->Actions->User Name
Activity->Actions->Action Details->Object Name
Activity->Actions->Action Details->Viewed Report Name
Activity->Actions->Path->Path
Activity->Actions->Action Time->Action Time
I filter on Action Time - due to poorly designed tables for reporting purposes the query is fairly inefficient, so you need to restrict by date range at least. I also filter out some users, administrators, report writers etc.
NB: For a reporting tool the underlying audit tables for BO are a complete mess to understand and self-report on. This uses the Activity Universe provided with BO, care needs to be taken in use as it is easy to select something you thing is logical which returns unexpected results.
One key point - you need to turn on auditing of reports in the CMC. Log on as admin -> Servers -> .WebIntelligenceProcessingServer -> Audit Events. We have Document Saved, Retrieved and Refreshed selected.
(BOB member since 2004-04-05)
(BOB member since 2009-05-12)