Jun
16

Guru Tip #4 – Take 4 Simple Steps to Preview your Web Service Output Data using an Xcelsius Snapshot!

Problem: “Is there a way to see the output data of my web service (such as Query as a Web Service or other custom web services) from Xcelsius?”

Solution: Take an Excel snapshot in Xcelsius.
Note: Snapshots can be taken in many formats (Excel, Flash, HTML, Power Point, Outlook, Adobe PDF)

Great method for debugging, validating and gaining initial data output from web service to build model.

* Using Xcelsius 2008

1. Click on Preview (Ctrl +Enter)


2. Go to File > Snapshot > Current Excel Data


3. In pop up ‘Save As’ dialog box choose filename (e.g.’Excelsnapshot.xls’)


4. Open Excel file on hard drive to view snapshot of data!

* Using Xcelsius 4.5

1. Click on Preview


2.
In Preview mode go to File > Snapshot > Back to Excel


3. In pop up ‘Save As’ dialog box choose file name (e.g. ‘Excelsnapshot.xls’)


4. Open Excel file on hard drive to view snapshot of data!

Voila! Now find your file and open it to gain a preview of the data in the dashboard at the moment that you took your snapshot! Validate output formats, checks formulas. Easy way to gain dummy data for building models!

If this Guru tip was helpful please rate it and leave feedback! We would love to hear from you! Why not share (click on button below)?

Leave a Reply