Skip to Content
Author's profile photo Swapnil Yavalkar

How To Fetch/Export Universe Based Report Details From SAP Business Intelligence 4.0/4.1/4.2 Servers.

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

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Santhosh Katakam
      Santhosh Katakam

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

      Regards
      Santhosh

      Author's profile photo Swapnil Yavalkar
      Swapnil Yavalkar
      Blog Post Author

      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
       

      Author's profile photo Sohel Ahmed Syed
      Sohel Ahmed Syed

      Must have utility! Thanks for sharing Swapnil. Will try it soon... 

      Author's profile photo Swapnil Yavalkar
      Swapnil Yavalkar
      Blog Post Author

      Thank you for the comments Sohel sir 🙂
       

      Author's profile photo Swapnil Yavalkar
      Swapnil Yavalkar
      Blog Post Author

      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

      Author's profile photo Robert Huff
      Robert Huff

      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

       

      Author's profile photo Swapnil Yavalkar
      Swapnil Yavalkar
      Blog Post Author

      Hi Red,

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

      ~Swapnil

      Author's profile photo Abhilasha Alapati
      Abhilasha Alapati

      Hi Swapnil,

       

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

       

      Thanks,