Hi Readers,

This is one of the frequently asked question in our forum and most of the steps are already there in our forum. Since I got a chance to work with this, am sharing the step by step configuration of Audit reports with screen captures.


BusinessObjects Enterprise Auditor provides you with a way to monitor and record key facts about your deployment. Auditor also allows you to better administer individual user accounts and reports by giving you more insight into what actions users are taking and which reports they are accessing. The information provided by the auditor answers the following queries.

  1. Who is using your Business Objects Enterprise system?
  2. Which objects they are accessing?
  3. Which groups within the company use our BusinessObjects Enterprise system the most?


And below are some of the auditable actions

  • Track when Objects are created, deleted of modified
  • Track when reports are opened, saved, refreshed, created, modified and deleted
  • Job monitoring and failure

Auditor Configuration

In SAP BusinessObjects 4.0 auditing database schema was changed, improved. SAP BusinessObjects Business Intelligence 4.0 does not include auditing sample Universe and auditing sample reports with the installation.

Configuration in CMC

To configure Audit database in BI 4.0, you need to follow the steps below

  1. Login to CMC and click on Auditing from Manage.
  2. In the ADS database configuration select type of the database.
  3. Provide the credentials of the database and click on save.


     4. You need to restart the Central management server (CMS) hence log off from CMC.

     5. Open Central configuration manager (CCM) and restart the Server Intelligence Agent.

     6. Wait for some time so that all the servers will come up because the Adaptive processing server should be running completely to enable auditing.

Auditor deployment package and contents

Compared to previous versions of BusinessObjects, Installation package will not come with a default Audit universe and reports. But SAP comes up with as- is sample to help administrators and report designers to develop custom auditing reports. This would be a starting point of the development of custom auditing universe and reports as per the requirement. Please refer http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/40711187-04e8-2d10-d190-851e20c7665a to know more.

The Audit Sample package contains:

     a) Seven sample auditing .UNX universes one for each of the following database types:

     b) Thirty-eight sample Crystal Reports referencing the universe.

Deployment and configuration of Audit Universe

To deploy Auditing universe please follow the steps:

  1. In SAP BusinessObjects 4.0 Information Design Tool create a new project and retrieve the sample auditing universe into it. This will result in a 3 objects appearing in your project: a connection, (.cnx or .cns), a data layer, (.dfx), and a business layer (.blx)



2. In Information Design Tool create a connection (.cnx or .cns) to your auditing data store (for SAP Business Objects 4.0. Then change the connection of the dfx to use the one you have created.



3. In Information Design Tool check integrity of the universe before re-publishing. Please ignore all cardinality and unlinked table warnings.


4. In Information Design Tool publish the modified universe to your SAP BusinessObjects Enterprise system.  If you are using a .cnx, you will be prompted to create and switch to a secure, published .cns connection. You can publish your .cnx connection to your SAP BusinessObjects Enterprise repository to generate a secured .cns.

Deployment and configuration of Audit Reports

  1. In Crystal Reports Design for 4.0 open the sample auditing reports


2. Click the ‘Data’ menu and ‘Set Data Source Location’ to point the report to the auditing universe published in the previous step.


3. Publish the sample reports to the SAP Business Objects Enterprise




Audit reports are deployed in your BusinessObjects environment. You can now start using the deployed reports.

Hope this is interesting and useful. We will see BusinessObjects Monitoring in my next few blogs.

Related references :

BusinessObjects Administration – Audit reporting vs Metadata reporting

BusinessObjects Auditing – What is changed in BO 4.0?

BusinessObjects Auditing – Considerations & Enabling

BusinessObjects Administration – Extending capabilities of BI 4.x Audit reporting

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. S man


    Its really good and helpful document.

    Still I am not sure why I am not able to connect to auditing universe.

    we are on bo 4.o sp4 p6 and 2011 crystal as client tool

    First time trying to create crystal report based on sample report

    Procedure what I followed:

    1. copied audit sample file on my client desktop

    2. launched crystal 2011

    3. opened “User-most active ” sample report

    4. Selected “set data source location”

    5. Selected “Universe” from replace option

    6. provided system ID and password

    7. selected audit universe

    Now once I click on audit universe, I dont see universe itself…. But On same universe webi, explorer reports are working fine.

    some one please help me out..

    Thanks in advance…

    1. Manikandan Elumalai Post author
      Hello SJ, Please note Crystal 2011 uses 32 bit connection contrary to 64 bit connection used by others such as WebI and explorer. Instead I would suggest you to try with Crystal Enterprise.  Regards Mani
      1. S man


        So you do not recommend crystal 2011..

        Actually we dont have plan to install crystal enterprise, still could you let me know on what name I can find this software in sap market place?


          1. S man


            Yes we did..I see it in BI..

            As I mentioned above my client do not have any idea to install crystal enterprise on client machines.

            If I launch crystal enterprise through BI, its asking me to install crystal enterprise client tool on local machine.

            So only I am trying to avoid it. We already installed crystal 2011 on clients machines.

            Really thanks for comments and suggestions

            1. Manikandan Elumalai Post author
              I suggested you to use the CE installed in BOE server instead of client side installation. since Audit reports export is going to be a one time activity, I followed this way
  2. Thomas Russell

    I have followed your steps but it gives me this error:You cannot publish the universe because it references an unsecured connection.

    when I try to publish the universe.

    Any idea to why?


    1. Mark Richardson

      What is the database you are connecting to…?

      I had the same error when I was connecting to Audit Connection running on Oracle DB, had to follow the two steps that I added in the posts above.

      1. Thomas Russell

        SQl Server ’08 R2.

        What do you mean by Proper Owner? Context?

        I have BOE140_Audit as Qualifier and dbo as Owner.

        I changed BOE140_Audit to BOE120_Audit which is the schema that I want. Still doesn’t work. I am also trying different Owners too.


    2. Manikandan Elumalai Post author

      Hello Thomas,

      Your connection should be of .cnx type instead of .cns type. Then  only you should be able to export the universe to repository.



      1. Daniel Llauger


        I’m trying to set it up for BI 4.1 SP3, but when I try to use the secured connection (.cns), i get Unable to connect to the repository, even though I’m connected to it, otherwise I could not create the shortcut. Any advice on this?


  3. Arvind Pandalai

    Hello Mani;

    I am also curious to know the audit that can be performed for BW functions. It would be great if you could share a blog for the same as well.

    Thank you.

  4. Keith Fisher

    Hi, I have set up the audit universe and CR for Enterprise reports in a couple of places in the last two weeks, however both times they suffered from being unable to refresh reports that had date prompts.

    The query compiled by CR for Ent was trying to send American (mm/dd/yyyy) date formats to the database instead of UK English ones (dd/mm/yyyy). Nothing I cold think of to change (the odbc connection regional settings, the language settings of the IDT and Crystal, the language settings of the SQL 2008 user) made any difference – are there some settings in CR for Enterprise iteself that will help?



  5. Brett Medalen

    I had a question about a BO Audit DB query but it was “rejected” by the moderator on main BI forum.  Any idea where I can ask questions about the BO Audit DB on the forum?

      1. Brett Medalen

        Thanks Jawahar.  Maybe you or someone else would know this question then:

        I have a query below that gives me all of the Web Intelligence report view events in the BO 4.x Audit database.  I am trying to figure out how to display the folder and universe associated with this report in the query.  Any ideas?



        SELECT *




            ON ADS_EVENT.Event_Type_ID = ADS_EVENT_TYPE.Event_Type_ID


            ON ADS_EVENT.Object_Type_ID = ADS_OBJECT_TYPE_STR.Object_Type_ID

        WHERE ADS_EVENT.Object_ID  >  ”

        AND  ADS_EVENT.Object_ID  <>  ‘unknown’

        AND ADS_OBJECT_TYPE_STR.Object_Type_Name  = ‘Web Intelligence’

        AND ADS_EVENT_TYPE.Event_Type_ID = 1002

  6. Sree Nair

    Hello Mani,

    As usual, a great and informative blog.

    I have one doubt though and would appreciate if you could please help me with the same.

    Lets say I choose not to have an Audit DB at the time of installation of BI4.x system. After installation, can I add an Audit DB?

    Thanks & Rgds,


  7. Venkateswarlu Ganjikunta

    Hi Mani

                  Is this Audit configuration works for BI4.1 Sp1?. We are having BI4.1 SP1 and i have performed the above steps for Audit configuration. I am getting the following error when i map the universe in ‘set database location’


    “The original query could not be mapped exactly to the new data source because some objects or metadata are missing in the new data source. Verify your new report’s query and query filter, as well as any sub report links in your report”

    Can you please help?



      1. prem kumar

        Hi mani

        Our BASIS/NW admin is not aware of the Database port.

        While creating odbc connection in  client System it is asking Database port with logon credentials..

        How to find that?



  8. Manjiree Dwivedi

    Hi Mani,

    I would like to find out the number of users accessing each webi report in a particular folder, reporting in the format: webi report name, no. of users accessed it in past 3 months. Can I find that using querybuilder and can you give me sample query to use?

    I can find it the other way by finding out the webi reports recently accessed by each user by the following query:


    I might get close to finding my answer if I can get SI_LAST_ACCESSED_TS>’2014.′, however I do not get any result if I add this in the statement above:


    Any thoughts?

  9. Hari Sagar Pacca

    Hi is it possible to monitor the log-in activity done through iPhone .I am aware we can monitor the activity done thorough SAP Mobile BI app but for specific iPhone activities ?

  10. Maruthi Yarapathineni

    Hi Mani,

      Thanks for your blog. its really helped me to start my work on Audit universe. Is there any way I can bring the User Full Name into the report? At present we are able to view only UserName in ADS_EVENT table. Could you help me to find this .



  11. Andrew McFarlane

    Really excellent article, thanks! Do you have any advice for ADS maintenance? I discovered auditing events were not being recorded because the ADS had reached the 10GB limit I had set. Ideally I would keep ‘Delete events after…’ set to 365 days, but I don’t really want to increase the size of the DB much more.

    Can you tell me, if Auditing is set to Default, what a good size for the ADS db would be? And also tell me if there specific things I could purge from the DB that would help in this case.

    Thank you very much for your time! 🙂


  12. Jamie Roman

    Thanks for your article. We recently upgraded to 4.1 sp4, but our system admin did not install the ADS. We have looked for documentation on how to add it at this point, but haven’t found instructions anywhere. We’ve only found instructions on configuring it. Do you know of any instructions on installing it? This is not handled by the System Configuration Wizard.

    Any suggestions would be appreciated!



    1. Mark Richardson

      Jamie :

      Usually the job of creating the “Empty” ADS database is the responsibility of your Database Administrators (DBAs).

      They should be creating a “New” SCHEMA – and the UserAccount that you are using to configure the ADS in Manikandan’s 1st screen-shot should have FULL (Create/Read/Write) Rights on that new database.

      What database are you using for your CMS database..? The ADS database creation should be using a similar process from when you set that up.

      1. Jamie Roman

        Thanks for your quick response. Yes we are moving forward on this. Our database for the CMS is Oracle and the DBA will set up the empty schema in Oracle.

  13. Henrik LAURIDSEN


    Hope someone can tell me I can still do this …

    In 3.1 we monitored the usage of objects inside the universes in order to clean up obsolete and un-used objects.

    In 4.1 I cannot seem to find this. Has anyone succeeded in doing so or can it be confirmed whether or not this is actually possible ?



  14. Amandeep Sharma

    Hello Manikandan,

    We have got everything running..means have Audit database configured…there are many default report published by SAP but still our requirement is not fullfilled.

    We want list of reports usage(ran by users) summary and detail in below format:


    Data Range as variable prompt.

    Report name    No of times it was run



    Reportname  username of who ran this   Timewhen users ran this report

    Any idea how to achieve this?


  15. Supriya Das

    While reviewing the exiting crystal Report on Events, we found that Folder path is not populated unless it is LCM job execution. Is this how Audit captures data or we need to enable something else.

    1. Daniel Llauger

      In order to see the folder path, you need to enable it on the CMC-Auditing.

      If you go there under Set Event Details, you’ll find “Folder Path Details” which is NOT enabled by default.

  16. Oscar Alvarez


    I would like to know if exists a query to get this data from audit database:

    • Username
    • IP Address
    • Date and Time
    • Report or object

    Best regards,

    Oscar Alvarez

  17. shyam kumar

    Hi Mani,

    Is it possible to see the data in Audit Report  related to Universe Connection details like Connection Name,Connection Modified By , Connection Modified Date/Time.If it’s possible please let me know the table and object name or send me the query which can be execute in Query Builder.

    Thanks in advance.

  18. Alex Golub

    Hi everyone,

    When I try to run a report I got this message:

    The authentication provider associated with this logon session does not support inter-process Single Sign-On. Please contact your system administrator for details. : The authentication provider (secEnterprise) associated with this logon session does not support inter-process Single Sign-On.

    What should be done to fix it?

  19. Amy Melendez

    These reports look like they would be very useful, but I am having an issue when I try to run an integrity check (I use Oracle 12):

    Column STATE referenced in the table ADS_AUDITEE does not have the same data type as in the database table STATE …….

    There are several of these errors.  Does anyone have any suggestions?


Leave a Reply