Question Re: Passing Multiple Values in Open Document using Linking in Design Studio in Technology Q&A

Passing Multiple Values in Open Document using Linking in Design Studio

Former Member — Thu, 25 May 2017 09:30:01 GMT

Passing Multiple Values in Open Document using Linking in Design Studio

1.Setting did in webi report for making in enable for Linking:

Prompt is as below:

PFA (pic1)

pic1.jpg pic2.jpg pic3.jpg pic5.jpg pic6.jpg pic7.jpg pic8.jpg

And setting of prompt is as below:

PFA (pic2)

2.URL used for passing the parameters:

var V_VERTICAL = DS_1.getVariableValueExt("ZAUTH_VERTICAL");

APPLICATION.openNewWindow("/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=ARjs7KES7EJHvp3EiBDFOx8&lsMVertical:="+V_VERTICAL);

3.This URL is working fine when we are passing single value in prompt. In given below example I am passing single value “LMD”

PFA (pic3)

4.It’s also working fine when we are passing hardcoded values like given below (even in case of multiple value 😞

APPLICATION.openNewWindow("/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=ARjs7KES7EJHvp3EiBDFOx8&lsMVertical:=HD;BUS");

PFA (pic4)

5.But when we are passing more than 1 value using variable then it’s not getting pass.

PFA (pic5)

Below error in coming through URL

PFA (pic6)

But values are passing in variable as shown below:

Passing 2 values

PFA (pic7)

Passing 3 values

PFA (pic8)pic1.jpgpic1.jpg

I am guessing the cause of error is the space coming after “;” in 2^nd value, which is coming by default from BO.

Please suggest is this feasible or not. I have tried many things from my end.

Re: Passing Multiple Values in Open Document using Linking in Design Studio

TammyPowlas — Thu, 25 May 2017 10:37:14 GMT

Hi Mohd - have you searched for this? Have you seen Victor's document which goes through all the scenarios (assuming your data source is BEx)? See https://blogs.sap.com/2013/03/11/how-to-use-opendocument-with-bex-variables/

Re: Passing Multiple Values in Open Document using Linking in Design Studio

P13119501 — Tue, 06 Feb 2018 21:53:00 GMT

mohit,

I have the same issue as you posted and that reference to that blog above does not help as his document is not address the issue that when passing single value in the prompts works fine, its when you change from "&lsS" to "&lsM", it starts passing "; " after every value. Did you find a work around and I'm using 1.6 latest sp.