How to extract list of Tables used in a Webi Report using Java SDK - BI 4.1

[Former Member]

Hi Experts,

I would like to extract the list of Tables used in a Webi report using Java SDK in BI 4.1. I am able to get the Data Provided/SQL Query of a Webi report successfully and I got stuck in getting the Table names from the Data Provider/SQL or from Webi Report.

Is there any way to get such information using Java SDK. I have gone through Report Engine SDK but I didn't find any such method/class to fulfill my requirement.

Kindly advise me on this.

Thanks in Advance.

Regards,

Madhu.

[Former Member]

Hi Madhu,

Would request if you can tell us like how were you able to get the sql.

We  have around 5000 Reports where in we are looking to retrieve SQL of all of them.

Did you performed any thing which at one go can give us the info ?

Doing manually is Not an option for us Plus We are on BOXI 3.1

[Former Member]

Database table structure is stored in universe and cannot be retrieved using Report Engine sdks. Also report engine sdks have deprectaed a ot a functionalities and it is best to move towards restful web services which is the future in terms of web intelligence as of now.

Check the below guide

http://service.sap.com/~sapidb/012002523100011674662015E/sbo41sp6_webi_restws_dg_en.pdf

For any queries relating to restful web services, you can post here

Thanks,

Prithvi