Feed data using XML

[Former Member]

hi Xcelsius gurus,

I need some advice on my scenario, we are building a dashboard off the data thats in the excel embedded on the xcelsius. The data is about 2700 rows, and we have 6 tabs.

Since the client has got some database issue we are asked to pull the data manually and use that for building the dashboard. So now with so much of data and lots of formulas and components is making things difficult.

I would like to request any of you who know about XML option i.e, to convert the excel data into XML format and call this data at the runtime in order to improve the performance.

So i know how to convert the data into XML format but i need some advice how do i go about using data connection.

Any help will be much appreciated.

[Former Member]

You can import your data into MS Access, create a query with all the calculations and denormalization if needed. Then, from MS Access export the query results to an XML data file. In addition, check "Schema of the data" when exporting. Then, map the exported XSD file as an Excel XML source and import with the XML mapping back to Xcelsius. In Xcelsius, create an Excel XML Map connection and point the XML data URL to where the exported XML data file is. From this point, in order to refresh the data, all you need to do is to replace the exported XML file with a new one.