Skip to Content
avatar image
Former Member

How to open webi report from last saved instance based on parameter from design studio

Hi,

I have gone through all the Opendoc blogs in community and applied the same and the logic is working when I open document inside launchpad. If I give document link to user and user select value and click details button, its throwing error like "An error occurred: Cannot find a document instance matching your prompt values".

Logic

var var1 = DS_3.getFilterText("Region");

APPLICATION.openNewWindow(“http://<Servername>:<Port number>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&sInstance=Param&iDocID=FnQma1RquQUA4g4AAADn9IQAEvyYXOcS&lsSCompany=var_end“);

Apologies if its a repeated question in community!!!

Thanks,

Siva

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Jun 15, 2017 at 12:53 AM

    Hi Siva,

    Based on your comments, you are talking about a number of different scenarios so it is a little difficult to understand without further details. I have the following questions for clarification:

    1) Firstly, let's take a look at your script code:

    var var1 = DS_3.getFilterText("Region");
    APPLICATION.openNewWindow(“http://<Servername>:<Port number>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&sInstance=Param&iDocID=FnQma1RquQUA4g4AAADn9IQAEvyYXOcS&lsSCompany=var_end“);
    

    The variable var1 is retrieving the data source filter string but it does not appear to be used anywhere. What is it's purpose?

    You have specified "sInstance=Param" in the URL, so this means that the target instance must have matching parameters to those that are being passed. Judging by the error message, such a matching instance does not exist. I suspect the issue is related to incorrect coding of your Company parameter value in the URL. If "var_end" is a variable value defined in your Design Studio application and not the literal value of your parameter, the your code should look like this:

    APPLICATION.openNewWindow(“http://<Servername>:<Port number>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&sInstance=Param&iDocID=FnQma1RquQUA4g4AAADn9IQAEvyYXOcS&lsSCompany=" + var_end); 

    Also, are you sure your reference to var_end is not a typo and you intended to specify var1 instead, which is the only variable definition in your code?

    2) "It's working when I Login to launch pad and Navigate to folder for particular file."

    Which file are you talking about here, the Design Studio application or the WebI reports?

    3) "And its not working if I take Document Link(Right Click on Application and get document link) and paste in word document and click on the click."

    Here, I assume you mean the document link is for the Design Studio application and not the WebI report? If that is the case, is the issue that the Design Studio application is not launching or that you are getting an error when the Design Studio application attempts to launch the WebI report via the OpenDoc call?

    4) "If i select any value from list and select my details button its throwing error."

    Can you provide a screenshot showing the list and button, as well as the resulting error?

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14, 2017 at 08:24 PM

    Hi - Have you seen Koen Hesters' blog? https://blogs.sap.com/2014/05/03/open-document-lingo-hyperlink-through-the-whole-bi-platform-incl-design-studio-lumira/

    It looks like he has all situations covered; if that doesn't work, please provide version and SP of Design Studio and BI launchpad

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2017 at 05:13 PM

    Hi Tammy,

    For users will be providing link where they go directly to access dashboard instead of navigating. Is there a way to get it work this opendoc in that situation?

    Thanks,

    Siva

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2017 at 05:12 PM

    Hi Tammy,

    For users will be providing shortcut link to access the dashboard instead of navigating folders. And the logic is not working If I click Run "Execute on BI Platform" from design studio designer as well.

    Please let me know is there a way I can achieve this.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 14, 2017 at 10:05 PM

    Hi Tammy, Yes I took that one as reference and Implemented the logic. It's working when I Login to launch pad and Navigate to folder for particular file. And its not working if I take Document Link(Right Click on Application and get document link) and paste in word document and click on the click. If i select any value from list and select my details button its throwing error.

    DS 1.6 SP4 Patch2

    Thanks,

    Siva

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2017 at 04:36 PM

    I apologies for inconvenience caused. Just going through the rules.

    Add comment
    10|10000 characters needed characters exceeded