Skip to Content
avatar image
Former Member

How to pass dynamic values from Query Prompt to Open Document URL

Hi All,

I created a dashboard, in that I am using Query Browser to retrieve the data and Query Prompt for filtering the Date.  I want to sent Date parameter to Open Document URL to open WebI document.

How can I pass dynamic Date to Open Document URL?

Thanks and regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 27, 2015 at 05:46 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Take the date separated as year,month & date in different cell and call them in the syntax what you have written like "&lsS[prompt_name]=Date(yyyy,mm,dd)" -- "&lsS[prompt_name]=Date(A1,B1,C1)".

      Pass the year,month & date in the A1,B1 & C1 cells.

  • avatar image
    Former Member
    May 27, 2015 at 11:23 AM

    Arif,

        What is the question?

    • How to pass the parameter from dashboard to webi? In this case, you need to create the url in a cell of the excel file in the Dasboard reading the prompt that you have choosen in the dasboard screen.
    • How to add the parameter to the webi link? at webi level use User Response function.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2015 at 05:35 PM

    Hi Arif,

    As Suman said take the date separated as year,month & date in different cell.


    eg:


    In cell A1 put base url http://<Open Document Url>

    In cell A2 put filter values which are dynamically calculated.

    In cell A3 use concatenation function to concatenate A1 & A2.


    Then Use A3 cell as source cell for your dynamic URL.


    Best Regards,

    Pushkar Dhale

    Add comment
    10|10000 characters needed characters exceeded