Skip to Content
Author's profile photo Swapnil Yavalkar

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

This utility is developed to fetch the report details from the SAP Business Intelligence Repository.

This will give you the report name, it’s type(Web Intelligence/ Crystal Report/ Desktop Intelligence) and its unabridged folder path.

I have included the required JAR files in the utility so you can use it directly by executing the command given below.

The output will be generated in an excel file and this file will be saved at the same location from where you will run it.

Generated excel file will have three columns i.e. Report Name, Report Type and it’s folder path.

Output of below file would be in the format Report Name, Report Type and Folder Path.

<< content with personal information was removed by moderator >>

DownloadFile-V4

Output Of V4 File would be in the format Report Name, Report ID, Report CUID, Report Type, and  Folder Path.

In order to run this utility, following command needs to be executed from the command prompt.

Command:

java.exe -jar FolderDetails.jar SAPBISeverIPAddress AdminUserID Password FolderID

Points to note for running the above command:

1. Replace the keyword SAPBIServerIPAddress with the IP address of your SAP Business Intelligence Server.
2. Replace the AdminUserID keyword with the administrator user ID.
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 FolderID with the required SI_ID of the parent folder. E.g. 23 is the SI_ID of the public folder so if we use this SI_ID in the command then it will generate the excel file for all of the reports present under Public 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.

E.g. java.exe -jar FolderDetails.jar SAPBISeverIPAddress AdminUserID Password 23

Sample Generated File:

I have tested this utility with SAP Business Objects 3.1, 4.1 and 4.2 versions and it worked as expected. Please use it and let know whether it works for you all or not.

Regards,
Swapnil Yavalkar

Assigned Tags

      27 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hello Swapnil

      Download link is missing.

      I'm very interest to try this tool, so please provide this link ASAP! 😉

      Have a nice weekend.

      Guillaume

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

      Hi Guillaume,

      Please note that this utility will work with only JAVA 8, since it was used to compile the program. Please do not use 23 as SI_ID since the utility will take long time for fetching all the reports.

      ~Swapnil Yavalkar

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

      Hi Guillaume,

      I forgot to provide the link, thank you for pointing it out. I have provided the download link above.

      - Swapnil Yavalkar

      Author's profile photo Former Member
      Former Member

      Hi Swapnil,

      Nice work on this, I was able to get it to work no problem.  The download jar file was v2 "FolderDetails-v2.jar" so wanted to mention that because all the instructions you provided were for just FolderDetails.jar.  Not that renaming was an issue, just might cause simple confusion for some.

      I do have some suggestions about the output file naming for improvement.  Currently the output name is always "Details.xlsx", with multiple file path selection options along with clusters and several different servers it would be helpful if the file output could be more specific to what was pulled.  For example, include the SI_ID and IP address or even Folder Name and SIA that the information was taken from in the file names created.  Not sure there is a perfect solution but something to give the name more definition of values in the file so as to prevent the need to always rename.

      Good work!

      Regards,
      David

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

      Hi David,

      Thank you for the comments and suggestions.

      As requested,I have changed the JAR file name to  FolderDetails.jar in the main post.

      Regarding ths output file name suggestion, I will make these changes for you however would need some time to work on it.

      I will let you know once the filename specific JAR is available to download for you.

      Thanks once again. 🙂

      ~Swapnil Yavalkar

       

      Author's profile photo Former Member
      Former Member

       

      Hi again Swapnil,

      I just wanted to let you know tested the latest JAR file (V3) you have made available and think the changes are great.

      Thanks for your work on this.
      David

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

      Hi All,

      Based on David”s request and suggestion, I have developed a new version of this utility which will save the generated excel file with  the name as BOSERVERIP_FOLDERID.xlsx.

      In this file name, BOSERVERIP would be the BO server IP used in the command to run this utility and FOLDERID would be SI_ID used in the command. E.g. 10.10.10.254_23.xlsx

      << content with personal information was removed by moderator >>

      @David,

      I could not add more details to the file name as it was increasing the queries used in the source code and which would have had an impact on the performance of this utility.

      ~Swapnil Yavalkar
       

      Author's profile photo Former Member
      Former Member

      Thanks Swapnil for the brilliant work, downloaded and test, working perfectly.
      would it be possible for you to retrieve reports ID's as well.

      Thanks
      Santhosh

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

      Hi Santhosh,

      Thank you for taking time to test this utility. I have uploaded new JAR File DownloadFile-V4 in the above post.

      ~Swapnil Yavalkar
       

      Author's profile photo Former Member
      Former Member

      Thanks again for the quick response 🙂

      Regards
      Santhosh

      Author's profile photo Santhosh Katakam
      Santhosh Katakam

      Hi Swapnil,

      can we get the similar info for universe as well.

      Regards
      Santhosh

      Author's profile photo Raja Mandala
      Raja Mandala

      Hello Swapnil,

      Could you please help me here.

      I am getting the below error :

       

      Initiating CMS Connection.....
      com.crystaldecisions.sdk.exception.SDKServerException: The error message is unkn
      own. This is likely caused by version inconsistencies between components. Here i
      s the value that caused the problem: 42023 and the additional information: .

      cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.se
      agatesoftware.com/OCA/oca_abuse:3.2
      detail:The error message is unknown. This is likely caused by version inconsiste
      ncies between components. Here is the value that caused the problem: 42023 and t
      he additional information: .

      The server supplied the following details: OCA_Abuse exception 10503 at [.\sisec
      server_impl.cpp : 428] 42023 {}
      ...FIPS mode does not support old APIs

       

      at com.crystaldecisions.sdk.exception.SDKServerException.map(SDKServerEx
      ception.java:107)
      at com.crystaldecisions.sdk.exception.SDKException.map(SDKException.java
      :196)
      at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLo
      gon(LogonService.java:719)
      at com.crystaldecisions.sdk.occa.security.internal.LogonService.userLogo
      n(LogonService.java:295)
      at com.crystaldecisions.sdk.occa.security.internal.SecurityMgr.userLogon
      (SecurityMgr.java:166)
      at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon(SessionM
      gr.java:425)
      at com.external.spy.common.utilities.folders.InitCmsExcelFolder.initCMSC
      onnection(InitCmsExcelFolder.java:60)
      at com.external.spy.folder.structure.details.FStructure.main(FStructure.
      java:27)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoa
      der.java:58)
      Caused by: com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:i
      mg.seagatesoftware.com/OCA/oca_abuse:3.2
      at com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuseHelper.
      read(oca_abuseHelper.java:106)
      at com.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAs._LogonEx4St
      ub.UserLogonEx4(_LogonEx4Stub.java:80)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at com.crystaldecisions.enterprise.ocaframework.ManagedService.invoke(Ma
      nagedService.java:425)
      at com.crystaldecisions.sdk.occa.security.internal._LogonEx4Proxy.UserLo
      gonEx4(_LogonEx4Proxy.java:222)
      at com.crystaldecisions.sdk.occa.security.internal.LogonService.doLogon(
      LogonService.java:347)
      at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLo
      gon(LogonService.java:693)
      ... 10 more

       

      We are on 4.2 SP3 patch 5.

       

      Thanks,

      Raja

       

      Author's profile photo Former Member
      Former Member

      I'm also having this error. Any luck in resolving? I'm on 4.2 SP4. My error is below:

       

      Initiating CMS Connection.....
      com.crystaldecisions.sdk.exception.SDKServerException: The error message is unknown. This is likely caused by version inconsistencies between components. Here is the value that caused the problem: 42023 and the additional information: .

      cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
      detail:The error message is unknown. This is likely caused by version inconsistencies between components. Here is the value that caused the problem: 42023 and the additional information: .

      The server supplied the following details: OCA_Abuse exception 10503 at [sisecserver_impl.cpp : 428] 42023 {}
      ...FIPS mode does not support old APIs

       

      at com.crystaldecisions.sdk.exception.SDKServerException.map(SDKServerException.java:107)
      at com.crystaldecisions.sdk.exception.SDKException.map(SDKException.java:196)
      at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLogon(LogonService.java:719)
      at com.crystaldecisions.sdk.occa.security.internal.LogonService.userLogon(LogonService.java:295)
      at com.crystaldecisions.sdk.occa.security.internal.SecurityMgr.userLogon(SecurityMgr.java:166)
      at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon(SessionMgr.java:425)
      at com.external.spy.common.utilities.folders.InitCmsExcelFolder.initCMSConnection(InitCmsExcelFolder.java:58)
      at com.external.spy.folder.structure.details.FStructure.main(FStructure.java:26)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
      Caused by: com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
      at com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuseHelper.read(oca_abuseHelper.java:106)
      at com.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAs._LogonEx4Stub.UserLogonEx4(_LogonEx4Stub.java:80)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at com.crystaldecisions.enterprise.ocaframework.ManagedService.invoke(ManagedService.java:425)
      at com.crystaldecisions.sdk.occa.security.internal._LogonEx4Proxy.UserLogonEx4(_LogonEx4Proxy.java:222)
      at com.crystaldecisions.sdk.occa.security.internal.LogonService.doLogon(LogonService.java:347)
      at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLogon(LogonService.java:693)
      ... 10 more

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

      Hi Sai and Jason,

      I have tested this jar file with SAP BI4.2 SP02 and it worked fine. It seems that the new libraries of SAP BI4.2 SP03 or SP04 would need to be added in the jar file. I will let you know once new file is created.

      ~Swapnil

       

       

      Author's profile photo Former Member
      Former Member

      Swapnil,

      Has any progress on this been made yet?  I am experiencing the exact same issue.  Currently using 4.2 SP4 Patch 3

      Mark

      Author's profile photo Former Member
      Former Member

      Not to over post but can you define the missing Lib or Jar files?

       

      Thank you,

      Mark

       

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

      Hi,

      Can you share the libraries of your BI Server version so that I can compile my code and provide it to you?

      Regards,
      Swapnil Yavalkar

      Author's profile photo Abhilasha Alapati
      Abhilasha Alapati

      Hi Swapnil,

       

      The utility works great in my Dev and Stage environments. But I have 2 problems :

       

      1. It doesn't list the reports in subfolders
      2. In my Production the utility fails with CMS operation timed out after 9 minutes even for a folder which has a single report.

      Also if last modified column can also be added to the script, then it will be a very big help.

      Much Thanks for a easy setup to get the folder path!!

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

      Hi,

       

      Followings are answers to your queries.

      1. It doesn’t list the reports in subfolders [Swapnil Y] This is true because it takes folder id as an argument and checks the reports available in that folder only. You are want the reverse of this utility. If we search for the type of WEBI reports then it will fetch the folder details of all reports. I will let you know once I develop such utility for you.
      2. In my Production the utility fails with CMS operation timed out after 9 minutes even for a folder which has a single report. [Swapnil Y] Check for the network issues in your network or run this utility directly on your BO Server. Dont worry it wont have any impact on your BO Server.

      Regards,

      Swapnil Yavalkar

      Author's profile photo Former Member
      Former Member

      Exactly  what I'm after. I want to try it in Pre Prod env before I run on Production but don't have Java 8 installed in pre prod. Anyone run in Prod directly and had any issues?

      Author's profile photo Former Member
      Former Member

      Hi Swapnil

      I'm getting the error Server Not Found or Server maybe Down error and its timing out. I can however login to the server and know its active. Any idea why this could be happening?

      I'm trying to retrieve path for some 300 Live Reports and this would be very useful if I can.

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

      Hi,

      It does not matter how many reports you are pulling from the server.   Error Server Not Found or Server maybe Down error and its timing out, it means that the system from where you are running this utility is not able to communicate with your BO Server perhaps because of Network issue/Security.

       

      Try to use this utility on BO Server itself or make a host file entry of BO Server on the system from where you are running it.

       

      Regards,

      Swapnil

      Author's profile photo Prasanth Sathyapalan
      Prasanth Sathyapalan

      Hi Swapnil,

      Please advise if you have the utility any where else .. Kindly assist if you have one.

      Regards

      Prasanth

      Author's profile photo Tom Du
      Tom Du

       

      Hi Swapnil,

      Could you please provide an alternate download link again for this helpful utility? This is what I've been looking for but somehow the link in your original post is disabled.

      Thanks,

      Tom

       

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

      Hi Tom,

      It seems that the moderator has removed the download links from all of my blogs. I will upload all file at the forum http://www.forumtopics.com/ and will let you know once these available to download.

      Regards,

      Swapnil Yavalkar

       

      Author's profile photo R k
      R k

      Hi Swaonil

      Greetings!

      hope you have already uploaded the files to forun topics

      could you please guide me on which subject files are available in forun topics EX BOBJ downloads

      if you have not uploaded , could you please provide the link

      Raghu

      Author's profile photo Mynyna Chau
      Mynyna Chau

      Dear Swapnil,
      as a moderator, I have removed content and files that include personal data. For security reasons and the protection of personal data, please don’t share closed and downloadable zip-files. Thanks and best, Mynyna (SAP Community moderator)