Skip to Content
0

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

Oct 19, 2017 at 02:48 PM

55

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Oct 20, 2017 at 10:13 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
John A. Weikert Oct 20, 2017 at 12:04 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded