Skip to Content

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

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

capture.png (8.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 08, 2017 at 06:57 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2017 at 02:39 PM

    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-objects-web-intelligence-40/

    Regards

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded