cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (0)