BI4 Auditing - scheduled vs. interactive

[Joe_Peters]

In BI4.1 auditing, is there an easy way to identify events associated with interactive actions vs. scheduled actions?

[former_member185603 · Accepted solution]

You mean scheduled report vs on demand report.

[Joe_Peters · Accepted solution]

Not the report itself, but the action that is associated with it.

[János_at_SAP · Accepted solution]

Hello Joe,

You can try the followings:

http://scn.sap.com/community/bi-platform/blog/2013/01/07/sap-businessobjects-40-auditor-configuratio...

You can check the universe there. please note, this universe is officically not supported by SAP Product support, but you may use it as a basis of your queries.

I hope it helps,

János

[Joe_Peters · Accepted solution]

I have the universe and reports, and I have auditing running.

How do I differentiate between scheduled and interactive actions?

[János_at_SAP · Accepted solution]

In  the auditing universe download page, when you open the zip file, you will find a documentation inside.

In the word doc, i have found the following:

if folder "Events"

Client   Application Type

The Client   Application Type associated to the event. For example “BI Launch pad”,   “Central Configuration Manager”, “Crystal Reports for Enterprise Scheduling   Service”, or a custom application may be returned.

I hope it helps,

János

[Joe_Peters · Accepted solution]

That seems to work.  Thank you.

[former_member190982]

Hi Joe,

Every event is identified or associated with and Eevent_type_ID.

For eg:  A View event has has 1002 as Event_type_ID.

You can check the admin guide for more details.

Regards,

RVS

[Former Member]

Hi Joe,

To identify events, events type such as logon, logout, refresh & view are interactive type whereas for scheduled reports we have event status ex- run/successful/failed.

Thanks,

Vizit

[Former Member]

there is an object which values are "run" and "refresh", i think there you can differentiate, will check the name of the object tomorrow.

[Joe_Peters]

Thanks, that sounds like Event Type.

Run might do it.  Refresh could occur for interactive or scheduled.

[Former Member]

yes, that is probably event type.

Can you test if it fits?

[former_member185603]

Run for schedule, Refresh fior Manual refresh of the report.