If you are working with LiveOffice objects, which corrently contain no data, the Dataset in Xcelsius will be set to just one Row. This fact causes the Dashboard to retreive no data, unless the Web Intelligence report contains data at a later time.

To know about this fact is very important, if you are wondering about your Dashboard not showing any data, although it should do.

Imagine you receive your Dashboard data from a Web Intelligence report, that contains no data at the time you are building the Dashboard and connect the Dashboard via LiveOffice with Web Intelligence.

After importing the LiveOffice enabled Excel-Model to Xcelsius, you can see the defined Dataset in Xcelsius Data Manager. (see below)

You can see, that the Dataset of this Crosstab report object is set to one row. (Row 14)
If your WebIntelligence report will provide data later on, it won't be displayed in Dashboard.

So you have got to resize the LiveOffice Datasets on your own after importing the Excel-Model. (see below)

As you can see in the screenshots i have resized the Datasets to row 240, as i though it will be enough for the data like to retrieve. As we are working with a Crosstab report object, we have to resize the Datasets for Vertical Headers and for Data Grid.

Think about the right size for you Datasets. If should be large enough to cover the largest amount of Rows, that will be provided by your WebI. But even don't set it to large, because if will affect Dashboard performance and has to to correspond you you maxrows setting in Xcelsius options.

If you encounter trouble resizing the Datasets, because Xcelsius hangs, i would recommend to install Flash Player - Debugger Version.

Expanding large Datasets in Xcelsius Data Manager might cause an ActionScript Timeout error. (see below)

You need some patience during resizing LiveOffice Datasets (lots of columns and rows), because Xcelsius does a lot of ActionScript calculations and transformation in Background. Don't wonder about the Application when it seems to freeze. Give it some time.

When the Timeout message of the Flash Debug Player appears, just click "Continue" and work is finished.

Best practice when working with LiveOffice report objects is to build a report with the largest dummy Dataset that will be retrieven on runtime. Insert the report object via LiveOffice and clear the data (just the data, not the LO-Connector cell!!!) in Xcelsius' Excel instance. If you do so, you don't have to think about Datasets because LiveOffice just gave Xcelsius the most biggest Dataset definition during Excel import.