How to retrieve a Query from Webi-Document using Java-SDK in BI 4.2 SP4 ?

[robertloke]

HI All!

For documentation purposes, I try to retrieve the effective queries from a webi document using the Java sdk (running SAP BI 4.2 SP4 on Windows platform).

It's possible to retrieve properties (Name of DataProvider, Duration, Numer of rows, ...) for recent instances. However, I fail in trying to get the SQL. Any concept like retrieving the SQL directly (using getSQL) or retrieving the SQLContainer or considering CombinedQueries fail with throwing a "NotImplementedException" - although they worked with older Versions, apparently.

What has changed with 4.2? How can I retrieve the queries?

[john_weikert]

Hi Robert,

You have to use the RESTful Web Services SDK for Web Intelligence BI 4.2 to get the information you are after. You can see an example of a tool developed using the RESTful Web Services SDK at https://www.sulissystems.co.uk/pages/Webi_documenter_BI4.asp.

Regards

John

[robertloke]

Hi all!

Just found the Object Model Diagram [http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_rebean_omd.pdf] for BI Versions 4 and beyond. This indicates that almost all methods used for extracting Queries became deprecated and become disfunctional in time. So, this explains the NotImplementedException.

However, there should be a supported way to retrieve the Queries and their properties ...

Regards,

Robert