Jump to Webi Query from Design Studio

[Former Member]

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

[kohesco · Accepted solution]

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 · Accepted solution]

Hi,

I updated my doc:

Hopes it helps

Grtz

Koen

[Former Member]

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]

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

[Arjun_KT]

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