Xcelsius is well known for its Excel paradigm for binding web service data, meta data, and logic to components. As the volume of dependencies grows it can start to get pretty hairy, specifically when you are setting up web service connections with Query as a Web Service (QaaWS). Once you bind the nodes from the web service, there is no easy way to mockup the user experience against blank cells. While copying and pasting data from the QaaWS client is simple enough, it does not provide the entire data set.
A simple trick to capture data provided by QaaWS is to preview a dashboard inside of Xcelsius, take a snapshot back to Excel, then re-import the snapshot back into your dashboard. The result is a true snapshot of the actual data retrieved from your QaaWS query, so you can build your user interface with real data.
Here are more detailed steps to accomplish the task.
- In the data manager, setup your QaaWS query.
- Go to the Usage tab for your QaaWS query and select refresh on load.
- Preview the dashboard
- Go to File>Snapshot>Back to Excel
- Import re-import the snapshot you just saved back into Xcelsius




We still cannot quite believe that I possibly could come to be those checking important points available on yuor web blog. His dad i are sincerely thankful for generosity enchanting giving me possibility pursue our chosen profession path. Wrote this information I had in your web-site.
After reading both of your blogposts I staleness say i pioneer this specific one to generally be top cut. I hold a weblog also and necessity to repost a few snips of your articles on my own blog place. Should it be alright if I use this as retentive I own comment your web journal or create a incoming attach to your article I procured the dress from? If not I realise and could not do it without having your approval . I score fact noticeable this article to twitter and zynga story conscious for reference. Anyway appreciate it either way!
Some great article, it helped me very much!