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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

I was able to solve the issue. Like all of you have already mentioned, once the dashboard was published onto the infoview portal it was not prompting for logon details.

As far as passing parameters from the Xcelsius chart to Webi report, I had to modify the Webi report Prompts to "match pattern" instead of using the "in-list" or "equal-to" options. It could be an issue with the way the dashboard was passing the prompt values from excel to the open document syntax URL. Thanks for all your help. I appreciate it.

Kalyan Sanagavaram

[Former Member]

Hope I can jump in here...

I have a dashboard that uses the webi open doc functionality... works great in Dev!. Migrated to test, works great there also... However, now in our prod environment, we keep gettibng the logon screen when we try the url link to a webi report?

Difference in prod is that prod is ldap, whereas dev and test are enterprise. and prod is also a dual server environment, test and ev are single servers.

I have tried publishing to prod with both ldap and enterprise authentication mdes, however, everytime we have to logon again...

Syntax is same from all three environments, not sure why they would be different?

[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.

[Former Member]

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.

[Former Member]

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