Skip to Content
avatar image
Former Member

Listout Webi Reports using a specific Universe Object

Hello,

I am new to SAP BO and need your help in achiving below requirement:

Our requirement is to pull list of all Web Intelligence reports using a specific universe object in BI 4.1. Based on my research I got to know that this was possible using JAVA Enterprise SDKs in BO XI 3.1; however same is not supported BI 4.0 SP3 onward; and possible using RESTFul Web Services SDKs only.

I have followed few links where in same question were asked; however no one has documented RESTFul SDK code to achive this requirement for SAP BI 4.1 on Windows Platform.

Please suggest.

Regards,

Anamika

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 22, 2016 at 04:07 PM

    Hi Anamika,

    In BI 4.1 REST SDKs it is possible to get all of the Universes used in a Webi Document, but it is not possible to get a list of all of the reports using a universe.  This is still possible with the BI Platform Java and .NET sdks though.  You can create a query returning the properties of a universe and get a list of document IDs that reference that universe.

    In BI 4.2, the Platform RESTful SDK has the ability to pass a query to the CMS database ( ../biprws/infostore/cmsQuery) so this can be used to achieve the same result.  Again this is only available in BI4.2.

    I hope this helps,

    Dan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Anamika,

      If this is a one-time thing where you know which universe you want to delete, there is a QueryBuilder tool that ships with BOE that you can use to get a list of report IDs using a universe.  If its something you will need to do more often, then an application would help.

      If installed, the tool that ships with BOE (QueryBuilder) can be found at:

              http://<boeServerName>:8080/AdminTools

      You can log on and run a query similar to: 

              Select * from CI_APPOBJECTS where SI_ID=<yourUniverseId>

      The query will return the properties for the uinverse and one of the properties, SI_WEBI, will contain a list of webi document IDs which use the universe.

      If you need to build an application to do this, the cmsQuery API in the BI Platform RESTful SDK will work in BI4.2.  If you don't have BI4.2, then you would need to write an application that executes this query using either the Java or .NET SDK.  All of our samples on SCN ( http://scn.sap.com/docs/DOC-51445 ) will show how to log on an execute a query.

      Once you have the list of Webi Documents using the universe, you can follow Prithviraj's suggestion to loop through the elements of each report in each document using the REST SDK to see if the Universe object is used.

      Dan