-Operating System: Windows XP
-OS Patch level: Service Pack 3
-Office Version: 2007
-Flash Player version: 10
-Xcelsius Version and Patch Level: Enterprise 2008 with SP2 (version: 5.2.0.0)
-Xcelsius Build number (Help>About Xcelsius): 12,2,0,608
-Business Objects Enterprise version/patch level (if applicable): Edge 3.1
-Issue Description:

I have a dashboard which collects data via Live Office from a series of Webi documents and Crystal Reports. I have found that if I create a report that has for instance sales regions down the left and months across the top using a cross tab in either Crystal Reports or as a Webi the data will only refresh within the current month, so for instance if I create the report in October the sales figure for October will update happily until the last day of the month but on the first of November no sales figures will show in the new month and I have to manually refresh the report in Xcelsius and issue a new Dashboard to my users. This makes me wonder whether Cross Tab reports are actually supported via Live Office. If I use formulas in Crystal Reports and manually build a report that looks like this but uses formulas it works fine, but is obviously a much slower process than simply building a Webi cross tab.

Your views and help would be very much appreciated!!

Thanks
Rob

-Steps to Duplicate:
As Above

Hi Simon

Thanks for your answer, sorry for the slow response.

I can get Webi reports to refresh but just seem to have problems when they are specifically cross-tab reports. Have you got cross-tab reports working?

In the meantime I have been converting to QAAWS.

Many thanks
Rob

Hi Rob,

You can bind cross tab reports from your WebI reports into Xcelsius using an integration tool called Xcelsius Web Intelligence Intregration Suite.

This will give you the full functionality of Web Intelligence inside an Xcelsius dashboard- drill-down, cross tabs, even an ad hoc query panel, all bound into the Xcelsius interface.

This would remove the need to use QaaWs or Live Office, so you can probably realize some performance gains and handle larger data volumes.

Cheers,

Andrew