webi report asking for prompt while passing hyperling from dashboard

[Former Member]

I am using this url for passing hyperlink with parameter “DS” to webi report from one excel cell on dashboard, but it is asking for a prompt in webi report. It is not directly pass the value to report.

=CONCATENATE("http://BFODB1.kalyanicorp.com:6405/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AfO...,"&sRefresh=Y")

Please suggest any solution for this.

[saurabh_sonawane]

=CONCATENATE("http://BFODB1.kalyanicorp.com:6405/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AfO...,"&sRefresh=Y")

A1=http://BFODB1.kalyanicorp.com:6405/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AfO...

b1=&sRefresh=Y

c1=concatenate("&lsSDS=",StagingOther!A5)

final output =CONCATENATE(A1,B1,C1)

[saurabh_sonawane]

=CONCATENATE("http://BFODB1.kalyanicorp.com:6405/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AfO...,"&sRefresh=Y")

A1=http://BFODB1.kalyanicorp.com:6405/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AfO...

b1=&sRefresh=Y

c1=concatenate("&lsSDS=",StagingOther!A5)

final output =CONCATENATE(A1,B1,C1)

[former_member215165]

Hello Amardip,

Please refer :

All you need to know about Open Document | David Lai's Business Intelligence Blog

Please refer point no.4 in this blog on the syntax to construct the hyperlink with prompts.

Regards,

Krupali

[former_member183777]

Look for OpenDoc guide and blogs on exact format for passing parameters. General recommendation is to build the link in another Webi using the Linking functionality of the WEBI first and then use the url generated in the test WEBI in your dashboard