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.

[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/