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