Restsdk service for cancel the BO queries

[Former Member]

Hi All,

I need the rest sdk services to cancel the refresh of the report .

Thanks

Gaurav

[former_member197386 · Accepted solution]

Hi Gaurav,

As Eric said, you can cancel a refresh with the RESTful API, but this will work only if the refresh operation itself has been triggered by RESTful API too.

Regards,

Anthony

[Former Member]

will this cancel the query being executed in the backend(database)?

[daniel_paulsen]

My understanding is that an "End SQL" statement is sent to the back end database which should terminate the query.  Not all databases will support this, so there is a chance that the query will be abandoned and left running to completion on the back end.  Sorry, but I don't have a list of  which DB servers will work, so I can't give a specific answer for your case.  I did find that it will not work for a BW/BICS query.

See section 2.18 in the following guide:

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp7_webi_user_guide_en.pdf

Dan

[eric_festinger]

hello

This is also possible. Look for the section "Cancelling the refresh of a document" in the documentation".

Regards,

eric