Dec 13, 2016 at 06:33 AM

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

252 Views Last edit Dec 13, 2016 at 06:41 AM 3 rev

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