cancel
Showing results for 
Search instead for 
Did you mean: 

Jump to Webi Query from Design Studio

Former Member
0 Kudos
221

HI,

I have a requirement where I need to open a Webi Report when user clicks on a particular button in BODS dashboard. With the condition that filter remains intact i.e if user has selected particular Plant on DS, the same plant value shall get passed to Webi and data for that plant shall get displayed.

I found below document to do that but I am unable to make it work.

Jump to a Web Intelligence report from Dashboards in BI4 | Just-BI | Business Intelligence

I am able to jump to the Webi query but I get the prompt screen for plant which defeats the purpose of the whole exercise, can anyone help me out here?

Regards

VJ

Accepted Solutions (1)

Accepted Solutions (1)

kohesco
Active Contributor
0 Kudos

Hi,

in your webi you have to define a prompt on plant.  use this prompt name in your opendocument url you put in design studio.

it is the same like you jump from one webi to another.

grtz

Koen

kohesco
Active Contributor
0 Kudos

Hi,

I updated my doc:

Hopes it helps

Grtz

Koen

Answers (3)

Answers (3)

Former Member
0 Kudos

Tanks Everyone, the issue is resolved now, I already had prompt value at Webi.

I made two mistakes,

1. I was not using + sign instead of space.

2. It was a typo, while writing the URL

TammyPowlas
Active Contributor
0 Kudos

In addition to what Koen said, you can check the tutorials at

Arjun_KT
Participant
0 Kudos

Hello VJ,

Which component you are using in Design studio to display you filter value?

If you are using a drop down box then use following syntax in design studio

APPLICATION.openNewWindow("http://<serverip:port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AQgit8TjLNZAmd8wPQu6rbU"+ "&lsMPlant=" + DROPDOWN_PLANT.getSelectedValue() );

Note

iDocID :- it is your webi CUID

lsMPlant :- it is the Prompt text in the webi report . Ex :- In webi when you use Plant as prompt and if your prompt text is "PlantName" then give parameter text in  above url as "lsMPlantName".

DROPDOWN_PLANT:- It is your drop down component name .

Hope its helps..

Regards

Arjun KT