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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

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

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.