Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
1,222

While working on one of our internal requirement, I had developed an utility which will fetch the universe based reports details from the SAP Business Intelligence Repository.


This utility takes an Universe ID as an argument in the command and gets all the reports based on the same universe and their other details from the SAP Business Intelligence Repository.


This utility will give you an output in an excel file and it will have the details of the reports in the following format.




This will help you to get the report details which are based on UNV and UNX from SAP Business Intelligence 4.0/4.1/4.2 Server Repositories.


Following is the command to run this utility.


Command:
Java.exe -jar ReportDetails.jar BIServerIP administrator "Password" UniverseID


E.g.
Java.exe -jar ReportDetails.jar 169.X.X.X administrator "jhiih&%" 1544


Output Details:
Output of this utility will be generated in an excel file and it will be saved in the same directory from where you will run it.
Generated excel file name would contain the BOServerIPAddress, Universe Name and Universe ID e.g. 169.X.X.X_eFashion_1544.xlsx


Points to Note:
1. Replace the keyword BIServerIP with the IP address of your SAP Business Intelligence Server.
2. Use only enterprise administrator user.
3. Replace the Password keyword with the password of administrator user ID.
4. This utility will work only with Enterprise authentication since it is hard coded in the source code.
5. Replace UniverseID with the required SI_ID of the universe.
6. I have compiled this utility using JAVA 8 so please ensure you have it installed on the system from where you will run it.


I have also developed the same utility for SAP Business Objects 3.1 version, I will share it if requested or needed by anyone. Please comment if it is required to anyone.


Downloads:
ReportDetails-V1


~ Swapnil Yavalkar

9 Comments
Former Member
Another good utility from you, downloaded and tested working great. can you use to query multiple universe at a time.

Regards
Santhosh
former_member190781
Active Contributor
Must have utility! Thanks for sharing Swapnil. Will try it soon... 
Former Member
0 Kudos

Thank you for the comments Santhosh.

I will need some time in order to work on your request for multiple universes. I will post once it is ready for you.

~Swapnil Yavalkar
 

Former Member
0 Kudos
Thank you for the comments Sohel sir 🙂
 
Former Member
0 Kudos
Hi All,

Following error would be encountered if the provided universe does not have any dependent reports.

Error would be "Not a valid query. (FWB 00025)"
~Swapnil Yavalkar
robert_huff
Member
0 Kudos
Swapnil,

Thanks for this tool but I seem to get an error when it runs, See below. Does this require Crystal installed and running?

Initiating CMS Connection.....
com.crystaldecisions.sdk.exception.SDKServerException: Internal error.

cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:Internal error.

 

thanks,

Red

 
Former Member
0 Kudos
Hi Red,

Could you please confirm the BO Version you are using? Crystal is not required.

~Swapnil
former_member554937
Discoverer
0 Kudos
Hi Swapnil,

 

We are working on 3.1 and looking for the utility. Can you please provide it for 3.1 version.

 

Thanks,
0 Kudos

Can you please share the latest file.

Labels in this area