Skip to Content
0

Passing Multiple Values in Open Document using Linking in Design Studio

May 25, 2017 at 09:30 AM

286

avatar image
Former Member

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 2nd value, which is coming by default from BO.

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

pic1.jpg (17.5 kB)
pic2.jpg (27.8 kB)
pic3.jpg (10.7 kB)
pic5.jpg (2.4 kB)
pic6.jpg (17.4 kB)
pic7.jpg (10.0 kB)
pic8.jpg (10.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
May 25, 2017 at 10:37 AM
0

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/

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Feb 06 at 09:53 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded