I need to go from an Xcelsius dashboard that feeds a Web Intelligence Report a prompted value and then I need another Xcelsius report load the results from that report. Can this be done and if so, how to load the 2nd dashboard automatically?
fknaut 
(BOB member since 2005-08-04)
Xcelsius dashboards do not load anything automatically. They dont store data. On open, they can retrieve data.
I suppose you could make a button on dashboard one, that fires two OpenDoc links, 1 for webi, and 1 for another dashboard. Both of these objects would have the same parameters…that is what your asking right?
Cairmor (BOB member since 2008-06-05)
Not exactly.
Dashboard A has a parameter prompt that passes customer name to the customer name prompt in the Web Intelligence Report. When the results of that refresh come through it needs to pass the values to Dashboard B. I will be using Dashboard Builder as well.
fknaut (BOB member since 2005-08-04)
[quote=“fknaut”]Not exactly.
When the results of that refresh come through…[/quote]
what are the results going to look like…one dimension…two, more, and whats the estimated row count that will be coming back?
Cairmor (BOB member since 2008-06-05)
Dashboard A - Combo Box, Filtered Rows, passed single value to report.
Webi Report - generates values based on selected parameter passed.
Dashboard B - Needs to feed in those results.
fknaut (BOB member since 2005-08-04)
is the webi report being viewed in any way, or are you simply using it to generate a query result set, based on parameters from Dashboard A?
Cairmor (BOB member since 2008-06-05)
Dashboard pass value to Webi. Then Webi Values pass to Dasboard B
fknaut (BOB member since 2005-08-04)
Webi is not seen by user at all.
fknaut (BOB member since 2005-08-04)
do you have a Live Office connector available?
Cairmor (BOB member since 2008-06-05)
Yest it is using LO.
fknaut (BOB member since 2005-08-04)
ok…
i got a small sample working in my envirnoment.
you can open a webi doc from xcelsius using xcelsius values as parameters with opendoc.
your webi will then be populated with Dashboard A’s values. Using a Webi column (or section header) as a link, you can open another dashboard. I dont think you can automatically do this, unless you figure out how to code in a re-direct into an Open doc statement. Regardless, Dashboard B can open based on values from the Webi doc, but an end user will have to click a link (not automatic).
I found another thread which talks about a similar concept.
Cairmor (BOB member since 2008-06-05)