Hope you all know that we can pass the parameters from one dashboard to another, Webi to Dashboard.

Here, am sharing the steps to pass parameter from Webi report to Dashboard.

Steps:

  1. Create Flash variables in child report

          Manage Connections –> Click Add –> Choose Flash variable –> from the list à Map the flash variable with some range in excel. (Here, I have created 2 flash variables
          “test” and “test1”)

               Dashboard - Flash variable.png

     If you need to pass single value means, map one cell in excel. Also we can pass multiple values. For that we need to map the range in excel.

    2.  In Parent report, We need to give hyperlink and pass the parameter. Before that note down the document link of that child report.

        …..&lsStest=(=[New])&lsStest=(=[New1])http://pepwap06609.corp.pep.pvt:8090/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AaP7uKNwIn9HkTmBRRq2KYk&lsStest=(=%5bNew%5d)&lsStest=(=%5bNew1%5d)

    • …..  –> Document link of that child report.

          [New] and [New1] variables are the parameters which we need to pass from Parent to Child.

     3. In Mobile devices, the open doc url displays “+” symbol for “space”, when we pass the parameter from webi report.

          So, We have to replace space with %20.

           [New]=Replace(Replace(UserResponse(“Prompt Text“);”;”;”,”);””;”%20″)

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply