Report and Table element

[#1]

We are using BO Universe and build a report by Webi Report,

In some cases, we need to assist impacted reports if a certain universe element is removed or updated for example

We do this impact by generating a report that contains

1- a list of all webi reports

2- a list of all universe element

3- a Flag (Y/N) to indicate that this report is using this universe element,

We do this with the help of the audit table themself,

My Question here, this approach can not be used, if the report is using free SQL statement. It only work if the report is using BO Universe ,

Is there any way to generate a list of Webi reports and the table and column used within its SQL query

[ayman_salem]

You can use the RESTful API to get the information of any DataProvider in the documents.

ex: http(s)://<server>:<port>/biprws/raylight/v1/documents/<doc id>/dataproviders/<DP id>

..

for more information see

https://help.sap.com/viewer/58f583a7643e48cf944cf554eb961f5b/4.2.4/en-US/d5a3c0f9897344f5a337b9b71f2...

...

I hope it helps