Hello
We r using excelsius 2008…how to update dashboard dynamically, if we change the excel that shud update the dashboard…we r not getting any perfect solution for this…pls suggest…
dipti@eclerx (BOB member since 2011-09-27)
You can look for example at XML/XML maps or an Xcelsius AddOn: CSV connector (see here), or web services.
Andreas 
(BOB member since 2002-06-20)
thanks…
dipti@eclerx (BOB member since 2011-09-27)
can i upload excel file from UI and generate the xml of it and put the xml on that server where dashboard is uploaded, will my dashboard get updated whenever that xml gets changes ??? I m not using any webservice and csv connector here…
dipti@eclerx (BOB member since 2011-09-27)
[quote:04e95a740c=“dipti@eclerx”]can i upload excel file from UI and generate the xml of it and put the xml on that server where dashboard is uploaded, will my dashboard get updated whenever that xml gets changes ??? I m not using any webservice and csv connector here…
[/quote]
Yes. Create an excel map over the spreadsheet. Use XML map connector in xcelsius.
Then user adds data to spreadsheet - saves once to save as excel (normal XLS save) and then saves AS XML to update XML. Dashboard will show changes.
Lots of posts on here on specifiaclly how to do it.
Debbie
Debbie 
(BOB member since 2005-03-01)
I have created one application in asp.net where I have used upload control which will upload the excel file and create an xml of it…I have publish that application so that i can access created xml file in excelsius reports…now in excelsius applicaton i have created data manager as xmldata in that i have passed xml file path and also mapped the columns of table in excel…but whenever my xml changes i need to click preview button in excelsisu UI then it will show me the updated report…is there anyway where my swf files also get updated on changes of xml file without clicking on preview button of excelsius UI…pls help me …i want to call swf from asp.net application
dipti@eclerx (BOB member since 2011-09-27)
Set your data connection to trigger on load. That way the dashboard will pick up new data/changes every time it’s opened. If you have any user interaction, you will need to also trigger on change and set a cell to use as a trigger.
debbie
Debbie (BOB member since 2005-03-01)
where is trigger on load function in xcelsius
dipti@eclerx (BOB member since 2011-09-27)
In the connection manager. When you set up your connection - there are two tabs. One where you define the connection (url , ranges etc) and one where you specity how it is triggered.
debbie
Debbie (BOB member since 2005-03-01)
thanks for ur prompt replies…
Now I m done with publishing the dashboard in asp.net web application using xmldata …but now our requirement is that whenever dashboard gets generated if i change something on dashboard itself(not in xml) can i download that dashboard excel or xml…or else is there any events of xcelsius…
dipti@eclerx (BOB member since 2011-09-27)
[quote:4bd65da933=“dipti@eclerx”]if i change something on dashboard itself(not in xml) can i download that dashboard excel or xml…or else is there any events of xcelsius…
[/quote]
Not sure what you mean? Do you mean change the dashboard design? Or the user inputs a parameter at runtime?
For the former, just republish to SWF (and HTML if you’re deploying outside of infoview). For the latter, you have to pass the user parameter out of xcelsius (send range in connection manager), process it in the aspx and pass the results of the query bacak again.
debbie
Debbie (BOB member since 2005-03-01)
I want to retrieve data from xcelsius into excel in what if scenarios…there is local scenario button but it is not giving me any xml or excel…
dipti@eclerx (BOB member since 2011-09-27)
Sorry, I’ve not done anything like that. But can’t you simply get your user to input new parameters, map them to existing ranges and the components will automatically show the new data? Or use a slider to model what-if data?
Debbie
Debbie (BOB member since 2005-03-01)
actually our requirement is to retrieve the report in excel whenever dashboard changes in what if analysis…
dipti@eclerx (BOB member since 2011-09-27)
In that case, you’d need to make your dashboard changes, send those changes out through the data connection, get the aspx to create and run the relevant queries, but instead of returning the resulting xml to xcelsius, you’d need to write the file somewhere and then open it with excel.
Like I said, not something I’ve done before (and to be honest, since xcelsius will model it for you, why go back to plain excel if you can deploy the dashboard via a url? 
). But it seems perfectly do-able.
debbie
Debbie (BOB member since 2005-03-01)