on 04-05-2013 9:58 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.