Random Thoughts

Views on life

Auditing II: How to import the auditing reports in BOE

Posted by Hemanta Banerjee on October 18, 2010

In my last post here I had explained how to enable auditing in BOE. This post focuses on using the provided universe and reports that give a great jump start to analysing the audit database.

Thankfully SAP provides a universe and some sample reports. While they are not exactly 100% of what you would need it is a great start. The universe is bundled with the BOE samples and can be found in “Program Files\Business Objects\BusinessObjects Enterprise 12.0\Samples\universe”.


Open the Activity.unv file using your universe designer. You will have to set the database connection to point to your auditing database. This can be done by setting the connection information in the properties for the universe.


Export the universe to BOE repository. I have created a separate folder called “Audit” for placing the universe as well as any reports that I will subsequently create against the audit database.



The key folders in the universe are

Class/Object Purpose
Activity Captures all the activity details including name, duration, object accessed (universe/document),
Job Time Frame This is used for scheduled jobs
Session Analysis Used to analyze the logon session, duration, client IP
Server Information Used to analyze the BOE services such as job server, RAS used to respond to end user queries.


There are some reports also bundled with the samples (D:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Samples) which can be imported using the BIAR tool. Unfortunately the reports have not been updated and you are probably better off developing your own (unless you are just demo’ing). Some key reports that you might want to develop:

Number of User Sessions – This metric will allow you to trend the adoption of the system based on number of user sessions by week, month, quarter.

Peak Usage – Analyze the number of users accessing the system by hour to determine peak usage patterns.

Average Refresh Time – Will allow you to report to the stakeholders the average refresh time for each report and also the system wide refresh time. Will keep the whiners away.

Top 5/10 Longest Average Refresh Time by Document – Will help pinpoint reports that probably need some work

Top 10 Longest Refresh Instances By User – The report would help you to proactively identify which users are experiencing bad performance and proactively try to address their requirement.

Least/Most Accessed Documents

One Response to “Auditing II: How to import the auditing reports in BOE”

  1. viagra said

    Man, talk about a fantastic post! I?ve stumbled across your blog a few times within the past, but I usually forgot to bookmark it. But not again! Thanks for posting the way you do, I genuinely appreciate seeing someone who actually has a viewpoint and isn?t really just bringing back up crap like nearly all other writers today. Keep it up!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: