cancel
Showing results for 
Search instead for 
Did you mean: 

Need help on audit database in BOXI r3.1

Former Member
0 Kudos

Hi Experts,

We have boxi r3.1 and do not have bomm installed.

Now we have requirement where i need to find out the report names which are using a particular table.

The only option i can think of is to check which universes have this table and put in a audit query to get the reports build on the top of this universe.

Then check these report query one by one  to find out the reports using this table.

Is their any other way available to retrieve this information.Thanks in advance for your suggestions.

Accepted Solutions (1)

Accepted Solutions (1)

former_member182521
Active Contributor
0 Kudos

Hi Bhankakishore,

to get the required information your approach would be to extract the metadata from the repository and get the details as required. you can refer the sample code available here.

http://www.forumtopics.com/busobj/viewtopic.php?t=185636

Regards

Mani

Former Member
0 Kudos

Thanks Mani,

For your help on this.

I am not expert in access.hence could you let me know what are the changes i have to make to run it againest a sql server repo db.

Also do you have excel version(macro) or vba code to retrieve these information.I am more comfortable with them.

or else could you tell me what are the audit queries you have put in to get the desired details.

Many thanks for your help on this.

Thanks Kishore

Answers (1)

Answers (1)

DayaJha
Active Contributor
0 Kudos

Hi  Bhanjakishore,

Please refer the below thread & URL regarding "Audit database in BOXI r3.1"


Links:

http://scn.sap.com/thread/2116841

http://businessobjects4.wordpress.com/2012/10/01/business-objects-xi-r3-1-auditing/

Hope this will help you as well.

Thanks,

Daya