Open doc syntax to pass report filter

[Former Member]

Hi All,

I am trying to drill from Xcelsius dashboard to Webi report scheduled instance based on some prompt value but resulting Webi report refresh it self.

I want that on drill webi report just open scheduled instance with filter, no refresh required because data on dashboard and webi report become out of sync.

I am using following syntax to open instance and expecting that report will jus open scheduled instance:

https://<SERVER NAME>/OpenDocument/opendoc/openDocument.jsp?iDocID=AXY.YppbgI5LikDNEuu7pSc&sIDType=CUID&sType=wid&sRefresh=N&sInstance=Last&sReportName=Detail&sWindow=New&lsSBSD=GPF&lsSClosed=Closed

Is there any way I can open scheduled instance with filter value and report does not refresh?

Thanks in advance

[julian_jimenez · Accepted solution]

Hi Kumar,

Instead of opening the last instance with these parameters, that will force the refresh, you need to open the latest instance with the same parameters. The correct syntax for your OpenDocument URL should be:

https://<SERVER NAME>/OpenDocument/opendoc/openDocument.jsp?iDocID=AXY.YppbgI5LikDNEuu7pSc&sIDType=CUID&sType=wid&sRefresh=N&sInstance=param&sReportName=Detail&sWindow=New&lsSBSD=GPF&lsSClosed=Closed

More information in this KBA:

https://service.sap.com/sap/support/notes/1554262

For full documentation about OpenDocument:

http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_url_reporting_opendocument_en.pd...

Regards,

Julian

[Former Member · Accepted solution]

Hi Julian,

Thanks for your reply, I am getting error when I am using modified URL "OpenDocument/opendoc/openDocument.jsp?iDocID=AXY.YppbgI5LikDNEuu7pSc;sIDType=CUID&sType=wid&sInstance=param&sReportName=Detail&sWindow=New&lsSBSD=GPF&lsSClosed=Closed&sRefresh=N"

Changing sInstance value back to Last is working but with refresh.

Error I am getting :

An error has occurred: Cannot find a document instance matching your prompt values

[julian_jimenez · Accepted solution]

Hi Kumar,

The option sInstance=param only works if you have already an instance with the same parameters. Have you scheduled one instance using these parameters?

Also, I will simplify the URL. If you are using CUID, you don't need ReportName

/openDocument.jsp?iDocID=AXY.YppbgI5LikDNEuu7pSc;sIDType=CUID&sType=wid&sInstance=param&lsSBSD=GPF&lsSClosed=Closed&sRefresh=N"

Regards,

Julian