Skip to Content
Author's profile photo Poovin Kumar V

Auditing in SAP Design Studio 1.3

We have found the new auditing feature in SAP Design Studio 1.3 to be extremely useful. As of version 1.3, SAP Design Studio logs events to the audit database. This helps us track SAP Design Studio events and extract critical information like event duration, event status, cube connections etc.

In a Business Objects Server, auditing is used to track the progress, status and duration of system events like authentication update, scheduled refresh of reports and logon / logoff of users. Auditing serves as an administrator’s swiss army knife to track and manage events and issues in the system.

SAP Design Studio 1.3 logs just a handful of events to the audit data base, however they are very informative in tracking application performance and refresh times. In order to use this feature, necessary configurations need to be done on the BI platform. Please refer to the Business Objects Administrator’s Guide for detailed information on audit DB configuration.

Once the Audit DB is configured, we can deploy the Audit Universe on top of it and track events through it. Audit universe and sample reports can be downloaded from the following URL –

Steps to enable events

Step 1:

Logon to the CMC with a user account that has access to ‘Auditing Application’ and select ‘Auditing’ located under ‘Manage’ category.

CMC Auditing Application

Step 2:

Specify the Audit DB details in ‘ADS Database’ and select the details that need to be logged with an event in ‘Set Event Details’.

Step 3:

Select the list of events that need to be logged in the Audit DB. Setting it to ‘Custom’ will provide the option to select events. Other predefined values will enable selective events based on the template.

Step 4:

Once the above configurations are done, restart the APS server hosting the ‘Auditing’ service.

Step 5:

Download the auditing universe from the above mentioned URL and upload it to the BI platform. Once this is done, we can track SAP Design Studio events.

Auditing SAP Design Studio Events

Once the audit universe is configured, we can use WebI or Crystal Reports to create reports on event data.

Step 1:

Launch WEBI and select “Auditing Universe” as data source.

Step 3:

On executing the above, we get the following result set.

Similarly, we can view the applications that were accessed by ‘BI Mobile’ by restricting the ‘Client Application Type’.

These reports will help the administrators and developers to get critical performance information of Analysis Applications on the BI platform. However, these events are restricted only to the platform and do not include events generated by users at design time through client tool.

Happy Learning !

source :

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Arjun K T
      Arjun K T

      Hello Kumar,

      Very informative .Thank You for sharing.


      Arjun KT

      Author's profile photo Gabriel Motor
      Gabriel Motor


      Thanks for the information.

      My Audit setting are the same like you and i have a lot Design Studio Reports.

      But when i choice the same selection like you i receive only the EVENT TYPE "Modify and Create" no  EVENT TYPE Cube Connection.

      What version of BOE Server have you?

      I have

      Design Studio 1.3  SP1

      BOE 4.1. SP2

      Best Regards

      Gabriel Motor

      Author's profile photo Poovin Kumar V
      Poovin Kumar V
      Blog Post Author

      Hi Gabriel,

      I have BOE 4.1 SP04. I have tried this option in BOE 4.1 SP03 as well and it worked.

      I am not sure about SP02, however it should work.

      Please check your Analysis APS settings and Universe for correctness.

      Author's profile photo Gabriel Motor
      Gabriel Motor

      Which setting did you mean?

      I have check the audit table on DB and there is no Cube Connection event, too

      My settings i in the auditing is:


      Author's profile photo Poovin Kumar V
      Poovin Kumar V
      Blog Post Author

      Hi Gabriel,

      Your Audit configuration looks Good and i don't see any issues with it.

      However try setting the Audit level to complete and restart your Audit APS.


      Just give it a try.