Skip to Content
Author's profile photo Swapnil Yavalkar

How To Fetch/Export Reports And It’s Associated Universe/Free Hand SQL Connection Details From SAP Business Intelligence 4.0/4.1/4.2 Servers.

I had developed an utility in the past to fetch basic report details, which can be found at the below link,

How To Fetch Report Name, Report Type and Folder Path From SAP Business Intelligence/Objects 3.1/4.0/4.1/4.2 Servers.

In the same way I have now developed this new utility with some extra details.

This utility will help you to fetch report details along with its associated universe and Free Hand SQL connection from SAP Business Intelligence Server Repository.

This utility takes Parent Folder SI_ID as an argument in the command and provides the details of the reports present under it and its sub folders.

Output Details:

Output of this utility will be an excel file which will be saved under the same directory from where you will run it.

Generated file name will have SAP Business Intelligence Server IP, Parent Folder SI_ID, Parent Folder Name which will be used in the command. E.g. 10.X.X.X_23_PublicFolder.xlsx

Generated excel file will have the details in the following format.

1) Report Name
2) Report ID
3) Report Path
4) Obj1 Name => This will either have the dependent universe name or dependent Free Hand SQL connection name.
5) Obj1 Type => This will either have the dependent universe type or dependent Free Hand SQL connection type.
6) Obj1 Path => This will either have the dependent universe path or dependent Free Hand SQL connection path.
7) Obj2 Name
8) Obj2 Type
9) Obj2 Path

Note: If any report has multiple queries using multiple universes or connections then only columns 7, 8, and 9 will have their information or else these columns would be empty.

Following is the command to run this utility.

JAVA.exe -jar ReportUC.jar SAPBIServerIP administrator “Password” Folder_SI_ID

JAVA.exe -jar ReportUC.jar 169.X.X.X administrator “jgkjs%43T#” 1544

Points to Note:
1. Replace the keyword SAPBIServerIP 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 Folder_SI_ID with the required SI_ID of the parent folder.
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.
7. Please do not use 23 as the PARENT Folder SI_ID as this will take so long to fetch all the report details.
8. Performance of this utility depends on the number of reports present under provided parent folder.
9. If any report does not have any associated universe or connection then the report details will be written in the excel file however other columns will be blank for its associated universe or connection details as shown in the below sample.
10) This utility will fetch the details about Web Intelligence reports only.

Output Sample File:

I have tested this utility on all of our SAP BI4.1/4.2 servers and it worked as expected. Please test it on your servers and let me know the outcome.


~ Swapnil Yavalkar

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Jawahar Konduru
      Jawahar Konduru

      Good Job Swapnil. Works great.

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

      Thank you for the comments Jawahar. 🙂

      Did you try it?

      ~Swapnil Yavalkar

      Author's profile photo Santhosh Katakam
      Santhosh Katakam

      downloaded and tested, working great. another good utility from you.


      Author's profile photo Former Member
      Former Member

      Hi Swapnil,

      I am not able to extract the zip file. Please could you help,

      Navneet Kaur

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

      Hi Navneet,

      What is the error you have encountered? Same file worked for other people, please provide more details about this issue.

      Swapnil Yavalkar

      Author's profile photo Former Member
      Former Member

      Hi Swapnil,

      Thanks for your response.
      Somehow i managed to download and run the jar file.This code works good.
      But this is not as per my requirement. We have 500+ hidden objects in our universe and we want to delete those objects. Before deletion we want to do the impact analysis like in which report those objects are being used. I just need a report list
      It would be great if you can provide any solution to that.

      Navneet Kaur

      Author's profile photo Richard Pare
      Richard Pare

      Hi Swapnil,


      i have interrest for you utilities.


      is it possible to retrieve the JAR ReportUC-V1

      at some place , because the LINK is broke.




      Author's profile photo VINOTH RAVI

      Hi Swapnil, In my project requirement, I am looking for the scripts which gives details about Last access date of universe Universes and last date access of Webi reports and Related universe name details excel format output.I trying to achieve my requirement through Excel Macro(scripts) not with Query Builder. Could you help in this?