Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2017 at 12:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded