Skip to Content
author's profile photo Former Member
Former Member

Open doc syntax to pass report filter

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 15, 2011 at 12:45 PM

    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.pdf

    Regards,

    Julian

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.