Calling a webi query from xcelsius dashboard

[former_member194977]

Hi Experts,

I have created an xcelsius dashboard with a URL link to a detailed webi report. I'm using open document to launch the webi query and with 1 parameter value to pass over from xcelsius to webi.

The URL is http<server:8080/OpenDocument/opendoc/openDocument.jsp?mode=full&appKind=InfoView&isApplication=true&nbPrompts=1&sIDType=CUID&sRefresh=Y&iDocID=AbgeiGFRMSlGtxcmjJeCRJM&appKind=InfoView&service=%2FOpenDocumentls%lsSProject=$A2.

Cell $A2 contains the value of the project selected by the dashboard user.

This URL does call the correct webi query but the webi query still prompts for the project. The 'Project' prompt in my webi report is set as optional and I have ticked the 'Refresh on open' check-box before saving the webi query.

How and what else do I need to do to by-pass the webi prompt for project?

Please let me know.

Thanks very much,

Anthony

[former_member194977]

I managed to resolve this problem myself. All I did was to put the lsSProject= at the beginning of the url ie. just after http://kc1sapdev02:8080/OpenDocument/opendoc/openDocument.jsp? and it works!

[Former Member]

Hi

Place the url in one cell and your passing prompt in another cell.concatenate both the cells and pass that to your url button.

eg:

in cell I6: http://sever:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&iDocID=AaHo4EFB5rhPplDJTrHLM6o&sID...

in cell D5: 1002

in cell I7: concatenate(I6,D5)

Pass this cell to your Url button.

Regards,

Peri.