Often when developing a dashboard with Xcelsius we have connections to a DataBase, either with LiveOffice or QaaWS (Query as a Web Service).

This leaves us with only two options to refresh our dashboard: either we proceed once all the Xcelsius components are loaded or, alternatively, change a radio button, combo box or any of the components related to the connection objects. In both these examples, when having to manage large amounts of data, we would normally wait until the connection returns our request. This can be frustrating, especially when we don’t have any indicator to signal that the data is being processed. In this article I will illustrate a convenient solution to this problem.

(more…)

While developing an Xcelsius dashboard for a Clariba customer, I came across two interesting challenges related to the location of a click on drillable charts.

Finding the location of a click on a drillable chart – Part 1

I was working with a drillable chart with two series and I wanted to know where the user had clicked (i.e. which series and which position).

With only one series there wouldn’t be any problem. Xcelsius can send the selected series to a cell, and the selected position to another cell. But with more than one series, each series can still send a position, but Xcelsius does not allow all the series to send the information to the same place. So the information has to be sent to different places. As a result, it’s hard for the developer to know which point was clicked last, as the information sent before is not deleted.

(more…)

One of the most challenging issues that Xcelsius developers face everyday is related to the performance of dashboards. Sometimes performance can be improved by changing the connection properties, changing the queries, reducing the Xcelsius components or reducing the formulas within the Excel sheet that populates the dashboard.

However even after making these adjustments, it’s possible that the dashboard may still take longer than expected to load. In fact, the calculation of some critical formulas such as SUMIF or VLOOKUP can take several seconds to update the values. But rather than explaining to users that the dashboard is locally calculating the values and that they simply have to wait for a short while, why not show them the loading progress in action…

(more…)