Passing Multiple Values in Open Document using Linking in Design Studio

[#1]

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.jpgpic2.jpgpic3.jpgpic5.jpgpic6.jpgpic7.jpgpic8.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.

[P13119501]

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.

[TammyPowlas]

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/