How To Fetch/Export Universe Based Report Details ...
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!
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
ANNOUNCEMENT: On Tuesday, November 12, from approximately 7:00 a.m. to 10:00 a.m. CET, notifications will be unavailable for SAP Community. You'll still be able to log in and post as normal, but activity within the community will not trigger notifications during this time.
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.