Hi,
we have requirement where from a webi report…we need to pass
parameters to a xcelius dashboard.
we know that we can open a dashboard from a webi report by putting a cell as html link.
but here we need to pass a parameter on to the dashboard.
Please let us know how to do about this.
thanks
krishna
dardedisco (BOB member since 2007-02-10)
I haven’t implemented anything like your requirement. I implemented Dashboard to dashboard,crystal and web report.
You can try the below scenario
In Web opendoc sysntax use IsSvar to send the valeue
and Can you try using Flash Variable in Xcelsius to catpure the prompt values and bind with Prompt for a query.
/OpenDocument/opendoc/openDocument.jsp?sKind=Flash&sDocName=XXXX&sWindow=New&lsSvar=[/i]
BOxcelsius (BOB member since 2007-02-07)
Thanks BOxcelsius,
Please elaborate it (IsSvar)…how to do that.
if possible with eg
thanks
krishna
dardedisco (BOB member since 2007-02-10)
I posted a sample dashboards to navigate thru dashboards.
You can try using this scenario as work around
BOxcelsius (BOB member since 2007-02-07)
hi,
my requirement is passing parameters from webi report to a xcelsius dashboard.
we have two paramerters/prompts in webi report and these same parameters have to be passed to the xcelsius dashboard.
dashboard have the same parameters when we tried to open the dashboard separatly.
thnks
krishna
dardedisco (BOB member since 2007-02-10)
I have so much going around me and doesn’t have a chance to reply. I successfully tested the functionality for passing values from web I to dashboards.
I tested to pass couple of values,
For web Hyperlink: Servername:portnumber/OpenDocument/opendoc/openDocument.jsp?sKind=Flash&iDocID=157457&lsSvar=([Object 1 value])&lsSvar1=([Object2 value])
Svar and Svar1 are two flash variable to pass into dashboard
In the xcelsius select a data provider for flash variable and name it as var for instance
In the definition of flash variable, variable data ranges add two ranges one with var and other with var1(name should be same as syntax) and bond them with two cells in excel respectively.
And when your are binding the prompt cells for QAaws, bind them with above mentioned cells.
I am attaching the dashboard, I cannot send you the web I report.
Let me know if you have any questions
thanks,
Sunil
test2.zip (5.0 KB)
BOxcelsius (BOB member since 2007-02-07)
Thanks Sunil,
Sorry for replying so late…
let me work on this and i will get back to you asap.
thanks
krishna
dardedisco (BOB member since 2007-02-10)
Hi BOxcelsius,
I tried your suggestion and it worked but not 100% because everytime I save the hyperlink as you specified this one gets cut. I mean this, this is the link I configured in the webi report:
and then when I execute it it doesnt work so I check the configuration again and now the url is like this:
I have done this several time with the same result, what could it be??
Nevertheless, if I put this url in a browser and type the rest of the url correctly then It works…
hope you have an answer for this…
regards,
bili
bili 
(BOB member since 2009-10-15)
I was able to pass multiple values from webi and retrieve in Xcelsius using Flash Variables. Below link just works fine for me.
Iam using 3.1
OpenDocument/opendoc/openDocument.jsp?sKind=Flash&iDocID=73681&lsSvar1=([Month -Year])&lsSvar2=([Year])
Thanks,
Sunil
BOxcelsius (BOB member since 2007-02-07)
Hi are you keeping any Hyper link in the dash board ?
By clicking the hyper we can pass the parameters from dash board to Crystal reports
or
using Bi work space are you doing by Content Linkin In Bi work space
Please advise 
mohankrishna68 (BOB member since 2015-07-23)