Auditing (BI4)

SAP BusinessObjects includes a powerful auditing capability integrated within it.  The auditing system captures all system activity including what actions users have performed on an ongoing basis.

For example, let's suppose Martha, a member of the Sales Operations team, is responsible for reviewing the company's weekly sales forecasts each Monday.  The first thing she does is log onto her computer and launch her company's BI Launchpad application using a web browser.  After going through several folders, she finally right-clicks and selects View to review the report.  It appears that the report, which is a Web Intelligence report, has old data.  She refreshes so it now reflects current information.  Then, she proceeds to re-save the report, but to her Favorites folder.  The following events (abbreviate details shown) may be captured:

9:01:05 | LOGON
9:12:07 | DOCUMENT RETRIEVED
9:12:07 | VIEW
9:16:07 | PAGE RETRIEVED
9:24:05 | FORMATTING APPLIED
9:26:05 | OBJECT CREATED
9:26:09 | TEMPLATE SAVED

 

light_on Tip
 Some objects have the term base in them.  This refers to, if present, a propery of the audited object's underlying source object.  For example, if we're examining the audit properties of an instance and we wanted to learn about when that instance's originating (base) report was created, we would use the Base Created object.

 

Universe Class

Object Name

Description / Purpose

universe-audits-bi4

CMSID

CMSID

Year

Year the action happened

Quarter

Quarter the action happened

Quarter Year

Quarter + Year the action happened

Month Date

Month date the action happened

Month Year Date

Month/Year  the action happened

Month Number

Month number the action happened

Days Ago

Days ago the action happened

Day Of Month

Day of the month the action happened

Day Of Week

Day of the week the action happened

Hour Of Day

Hour of the day the action happened

Audit Date Time

Audit date time

Base Created

Date/time the original object was created.  This is essentially a reference to the non-instance, or "base" report when auditing instance+base reports.

Base Kind

The kind or type of the original (base) object.  This is essentially a reference to the non-instance, or "base" report when auditing instance+base reports.

Base Object Name

The kind or type of the original (base) object.  This is essentially a reference to the non-instance, or "base" report when auditing instance+base reports.

Base CUID

The CUID of the original (base) object.  This is essentially a reference to the non-instance, or "base" report when auditing instance+base reports.

Base Parent CUID

The base object's parent CUID.

Event ID

Event ID - unique only to that particular CMSID

Event Type Name

Name of the Event being audited

Last User Name

Most recent person to have audited this object

Object Name

Name of the audited object

Object CUID

CUID of the audited object

Object Type

Type

Folder CUID

Folder CUID

Parent CUID

Parent CUID

Server CUID

Server CUID , or the server where this action was audited

Session ID

The related Session ID to this audit event.  Sessions can be found in the AUDIT_SESSIONS table as well as the Sessions  - Audit class.

Status Name

The status of the event

User Name

User name of the person responsible for the action

User CUID

User UID

Nbr Events

Total number of events related to the action

Nbr Users

Total number of users related to the action

Nbr Users (distinct)

Distinct total number of users related to the action

Nbr Objects

Total number of objects

Nbr Objects (distinct)

Distinct total number of objects

 

 

 
See also

MetaMiner Database Fields

 

© 2013-2015 by Infolytik