Audit views of pre-run instances

[former_member226862]

We are using Business Objects version 4 patch 2.10

I am trying to set up auditing. What I would like to see is statistics how many times user views pre-run instance(s) via document history. Is it even possible? I could see lots of other event recorded in audit table but I can't see to get record of event when user views an instance.

[Former Member · Accepted solution]

Hi,

Auditing in BI 4.0 has certain common audit events that are common to most of the servers. Amongst them is the View audit event. The View audit event audits the viewing of any object like reports, instance, universe etc.; so it does not specifically have View Instance audit event.

Hope this helps!!

Regards,

Nakul Mehta

[former_member226862 · Accepted solution]

Let me elaborate more on the issue I am having.

We have few WEBI reports that are scheduled to run daily and to save daily report instance in history.

Here is workflow for users to access an pre-run instance:

- log into BO;

- navigate to particular report in public folder;

- select 'History' from context menu to open list of available report instances;

- open and view particular report instance.

There is an Audit event recorded of user logging into BO however there is no record of user selecting and viewing an instance.

Without seeing who is using pre-run instances we cannot tell if report is used or not. Asking user to view report and refresh data on demand is not always desired functionality, especially for long running reports. Opening pre-run instance takes few seconds vs. running some of the reports could take more few minutes or more. Therefore wherever we can we try to pre-run reports overnight.

[Henry_Banks · Accepted solution]

Hi,

When you go CMC > Auditing ... what level of detail are you recording?

is there an event type you need to select ?  or an action ?

there are quite a few setup options in that area, so please let us know what you've enabled (ticked)

Regards,

H

[former_member226862 · Accepted solution]

Audit 'Set Event' is set to 'Default'. I did not try 'Custom' or 'Complete' level yet.

[Henry_Banks · Accepted solution]

Yep, that's what i thought. if you go down further, there are tons of tickboxes that can be selected/deselected.

You might find your golden ticket there.

best of luck

H

[former_member226862 · Accepted solution]

Instance views are recorded in audit database after changing 'Setting Events' to 'Custom' and enabling 'Retrieve'

[Former Member · Accepted solution]

I have the exact same needs.  I think !  Say differently, I like to count how many time a report (Dashboard and Webi) are viewed by users.

So far, when I take Filter "View event" from the universe audit, it give me all scheduling query in there (in the count).

So simple question we like to have and think BO should have !

Imagine what you have to say to your boss. "Yes Mr. Boss, No, I can't know the number of view in that audit databse which take about 30 gigs of metadata "

[Former Member · Accepted solution]

Hi Patrick,

Check this query, tell me if it help.

By the way this server is set to "Default" for the audit database.

[Former Member · Accepted solution]

Hello David,

   your name seem to me familliar, not sure ! 

I will give it a try (retry) but from what I can remember, your suggestion work just fine for webi view but not for Dashboard.

Since this post, I found if I use the Condition ads_event_type.event_type_id = 1003 (refresh), it retreive all webi and dashboard which contains SQl query.  At least I can know if a query is refresh from a dashboard, it mean a user try to view it.  Not perfect but better then nothing.

Thanks again.