Exciting times ahead for the SAP Community! We've outgrown our home, so we'll be migrating to a new platform later this year. Let's continue the journey together!
How To Fetch/Export Universe Based Report Details From SAP Business Intelligence 4.0/4.1/4.2 Servers.
8
2
815
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.
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.
Another good utility from you, downloaded and tested working great. can you use to query multiple universe at a time.
Regards
Santhosh
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
Must have utility! Thanks for sharing Swapnil. Will try it soon...
Thank you for the comments Sohel sir 🙂
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
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
Hi Red,
Could you please confirm the BO Version you are using? Crystal is not required.
~Swapnil
Hi Swapnil,
We are working on 3.1 and looking for the utility. Can you please provide it for 3.1 version.
Thanks,