Skip to Content

Calling a webi query from xcelsius dashboard

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 06, 2011 at 04:56 AM

    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&sIDType=CUID&lsSPlant=

    in cell D5: 1002

    in cell I7: concatenate(I6,D5)

    Pass this cell to your Url button.

    Regards,

    Peri.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2011 at 06:38 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded