Skip to Content
avatar image
Former Member

Syntax for passing Xcelsius parameters to Webi Report (Drill Down)

Hi,

I am trying to drilldown from an Xcelsius chart to a webi report by passing the prompts. And I have given the following syntax:

http://<CMS SERVER>:<PORT>/OpenDocument/opendoc/openDocument.jsp?iDocID=<DOCID>&sType=wid&sRefresh=Y&mode=full&lsSCalendarYear/Month=JAN2009&&lsSBusiness+Category=

Corporate.

When I click on the chart in Xcelsius, it opens the webi report in a new window. First & foremost, it asks me to login again(this is during testing from the Xcelsius application itself and I am not sure this would happen when I publish the dashboard to BOBJ infoview server). And then in the Webi report, it is showing the prompts screen, instead of directly accepting the passed on values and displaying the report. Am I doing something wrong? Can anyone please help?

Kalyan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 24, 2010 at 07:25 PM

    Hi, Kalyan!

    I do not know exactly what the problem of your URL/syntax is, but I know that I successfully managed to call a WebI report out of an Xcelsius dashboard. So, let's have a look at my URL/syntax:

    http://<CMS SERVER>:<PORT>/OpenDocument/opendoc/openDocument.jsp?
    iDocID=<ID>&
    sIDType=CUID&
    sRefresh=Y&
    lsSCountryKey=DE&
    ...

    So, the differences are:

    -> I use the WebI report's CUID and I put this ID type ("CUID") into the URL: "...&sIDType=CUID&..."

    -> I do not use "sType" and "mode"

    -> The rest, i.e. the report's specific parameters/prompts - all starting with lsS... is the same.

    As I said before: I do not know if there is a relevant difference, but why not giving it a try...? 😉

    Regards

    Micha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2010 at 07:30 PM

    Hi Kalyan,

    If you publish the dashboard to Infoview then you will not get the logon screen.It will take the user credentials from BOE server. you dont worry about this.Coming to your second question once run the dashbaord and click drilldown its asking for the report prompt values? where your saving the report and dashboard? like your personal floder or common floder..Please check correct report CUID are you using and also check prompt names are similier to ls prompt name.

    Please do export the dashboard to Infoview and let me know.

    Thanks

    srinivas

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 07, 2010 at 03:54 AM

    Hi Kalyan,

    As for the credentials in the webi report, this won't happen when you publish your xcelsius dashboard in infoview. When you log into infoview, an authentication token is created for that session and that token is pass to the emergent windows that get opened, including your dashboard.

    With regards of the webi refresh, try eliminating the parameter sRefresh=Y.

    Hope this helps and tell us if any of the suggestions worked.

    Cheers,

    xtian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Kalyan

      I´m experiencing the same issue I do not make successfully pass parameters my link is the following:

      http://<CMS SERVER>:<PORT>/OpenDocument/opendoc/openDocument.jsp?

      iDocID=<DOCID>&

      sIDType=CUID&

      sRefresh=Y&

      &mode=full&

      IsSCompany=xxx

      I have read the article and change the prompts and set "Match Pattern", but still not working, the links only open me the webi report and the prompts screen.

      could you help me?

      I would appreciate any  help.

      thanks in advance.

  • avatar image
    Former Member
    Sep 02, 2010 at 02:52 PM

    If you are not trying to run this all from inside InfoView, then your Xcelsius (assuming it has already logged on to BOE) needs to pass a session token to avoid teh WebI logon prompt. Trying googling "Xcelsius CELogonToken" and you should get lots of hits on this.

    Another option to consider is using the Dashboard Builder functionality in Infoview. You can create a dashboard that includes the Xcelsius and the WebI, and lets you specify what data you want to pass between them. There are samples on SDN and there is doc for it.

    Add comment
    10|10000 characters needed characters exceeded