Skip to Content
0

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

Sep 07, 2017 at 02:23 PM

195

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Sep 08, 2017 at 06:57 AM
0
Share
10 |10000 characters needed characters left characters exceeded
Sateesh Kumar Bukkisham Sep 10, 2017 at 02:39 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded