WebI Prompts passing values to Multiple Bex Query Variables(Key and text)

[former_member221192]

Hi All,

I have parent and child report and passing values from parent report to child report.

Parent report taking values from user input as Company_code and plant.I want pass this two values to child report to Bex variables but unable to pass it but it is asking pass the values for palnt and compnay code. but if i pass single varialbe value it is taking .it is not taking when I pass multiple variable .please suggest.

I am using below syntax with multiple variable(Key and text(Comapny code and Plant)).it is not working and throwing above error message.

="<a href=\"../../opendoc/openDocument.jsp?iDocID=ARqsbeYMddRBtbq9ti.ljXI&sIDType=CUID&sType=wid&lsSZA_COM_AUTH ="+URLEncode(UserResponse("Company Code")) +"&lsIZA_COM_AUTH="+URLEncode(UserResponse("Company Code"))+ "&lsSZ_0PLANT_CESM01="+URLEncode(UserResponse("Plant"))+"&lsIZ_0PLANT_CESM01="+URLEncode(UserResponse("Plant")) +"\" title=\"\" target=\"_blank\" nav=\"doc\">"+UserResponse("Company Code")+"</a>".

When i pass values to single variable It is taking with below syntax

="<a href=\"../../opendoc/openDocument.jsp?iDocID=ARqsbeYMddRBtbq9ti.ljXI&sIDType=CUID&sType=wid&lsSZA_COM_AUTH="+URLEncode(UserResponse("Company Code"))+"\" title=\"\" target=\"_blank\" nav=\"doc\">"+UserResponse("Company Code")+"</a>"

Regards

Ganapathy

[sateesh_kumar1]

HI Ganapathy ,

If you are using BI 4.0+ , use Document Linking feature in view mode to set up linking or to extract link .

https://blogs.sap.com/2014/03/22/how-to-add-document-links-interlink-webi-reports-in-sap-business-ob...

Regards

Sateesh

[kohesco]

Hi,

check out

https://blogs.sap.com/2014/05/03/open-document-lingo-hyperlink-through-the-whole-bi-platform-incl-de...

Grtz

Koen