Report and Table element

former_member83847 — Tue, 27 Jul 2021 08:12:31 GMT

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

Re: Report and Table element

ayman_salem — Tue, 27 Jul 2021 10:49:33 GMT

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

...

I hope it helps