Skip to Content
0

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

Dec 13, 2016 at 06:33 AM

104

avatar image

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

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

1 Answer

Best Answer
Mahendranath Reddy Jan 02, 2017 at 11:01 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded