Skip to Content

Problem in retrieving the QueryPlan of a WEBI Document using RESTful API call on BOBJ 42SP3

Hi,

This observation is on BOBJ 42SP3. Below RESTful api call for retrieving QueryPlan of a WEBI document is resulting a queryplan without statement.

Steps to reproduce:

Created a new WEBI document on BOBJ 42SP3 using BI launch pad by selecting columns from default universe "eFashion", ehich comes with installation. Executed the report, its working fine and able to see the data.

Now if i try to get the QueryPlan of the document created above, its resulting QueryPlan without "statement" element. like below,

WEB Service Method: GET

URI: http://BOBJ42SP3Server:6405/biprws/raylight/v1/documents/7036/dataproviders/DP0/queryplan

Logon Token:

X-SAP-LogonToken: "BOBJ42SP3Server:6400@{3&2=7004,U3&2v=BOBJ42SP3Server:6400,UP&66=60,U3&68=secEnterprise:Administrator,UP&S9=12,U3&qe=100,U3&vz=C.kORfyRmcnei9mOSGrPA4OF3t1h8rOM_1jv_k1yOqM,UP}"

Content-Type: application/xml

Response:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> <queryplan custom="false" editable="true" />

Expected Behavior:

Performed the same above steps on BOBJ 41SP5. But the result queryplan has a statement with the Select statement like below,

WEB Service Method: GET

URI:

http://BOBJ41SP5Server:6405/biprws/raylight/v1/documents/91381/dataproviders/DP0/queryplan

Logon Token:

X-SAP-LogonToken: "BOBJ41SP5Server:6400@{3&2=91374,U3&2v=BOBJ41SP5Server:6400,UP&66=60,U3&68=secEnterprise:Administrator,UP&S9=12,U3&qe=100,U3&vz=EXza_Ko9CpBFJlgnmc12_KVJV44Qg0BBqQvIqOcklZo,UP}"

Content-Type: application/xml

Response:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> <queryplan editable="true" custom="false"> <statement index="1">SELECT Outlet_Lookup.City, Outlet_Lookup.Shop_name, Outlet_Lookup.State FROM Outlet_Lookup</statement> </queryplan>

We are appending some additional query to the "statement" and update it using RESTful call.

Could any one please let us know if there were any changes done in RESTful API in the latest version of BOBJ 42+ releases?

If it is, then what is the alternate for retrieving QueryPlan using RESTful API? Thanks in advance.

Regards,

Mahendra

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 02, 2017 at 11:01 AM

    Solved.

    This problem is resolved after upgrading to the latest fix pack on BOBJ 42 SP3. Below is the reference.

    https://launchpad.support.sap.com/#/notes/2354210/E

    Thanks,

    Mahendra

    Add comment
    10|10000 characters needed characters exceeded