Which all WebI reports are using a customize SQL/FHSQL

[former_member590614]

In our system we have around 3000 WebI Reports.

Now we need to know out of these how many are using Free Hand SQL or Customize SQL.

Motive behind this activity: We are doing some changes at universe level so if any report is using FHSQL, universe changes will not be effective.

[daniel_paulsen]

You could write a script using the Webi RESTful SDK to do this.

Loop through the webi documents and check each dataprovider in the document.

The api:

GET /biprws/raylight/v1/<documentID>/dataproviders

will return the list of dataproviders in a document and the type of datasource used.

A datasource can be: unv, unx, bex, excel or fhsql. For freehand SQL the datasource would look something like:
<dataproviders>
<dataprovider>
<id>12345</id>
<name>Query 1</name>
<dataSourceId>678</dataSourceId>
<dataSourceType>fhsql</dataSourceType>
</dataprovider>
</dataproviders>

https://help.sap.com/viewer/5431204882b44fc98d56bd752e69f132/4.2.6/en-US/45f8ab646e041014910aba7db0e...

Dan