Using OpenDocument hyperlink in a Webi

[Former Member]

I am trying to use opendocument in a webi.  I have a cell set up with a hyperlink to the document.  Linking to the report works, but I am having trouble passing the value of the cell as a parameter in the opendocument url to the prompts in the linked report.  Here is the url I am currently using that does not work:

http://sapojd.cnsl.com:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=M1L5G0UAA0..."+URLEncode(""+URLEncode(Char([Do Uid]))) +"&lsSInclude_Expired_Parties=Y

The parameter for which I am trying to pass the cell value is the lsSEnter_DOI_UID.  Any ideas on what I am doing wrong?

[Former Member · Accepted solution]

I will suggest to use Open doc wizard to create open doc with parameter rather than writing freehand..

Check the link below for detailed steps

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0daee1d-0e38-2d10-0c91-8bb4ab5aa...

[Former Member · Accepted solution]

I discovered this myself.  The catch is that you have to use the web version of webi instead of the rich client to create the link.  then it works very well.  thank you.

[Former Member · Accepted solution]

Yes , that is a known limitation with this release..

[former_member207878]

If you want to include some characters like SPACE,#,:,$ etc in your prompt; then you can use URL encoding mentioned in below document on Page:9

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=4&ved=0CD4QFjAD&url=http%3A%2F%2Fwww.p...

Example:

lsMEnter%20values%20for%20Country%3A= Enter values for Country:

Here %20=space and

%3A = :

Rest of the list is available on page 9 in attached link