Skip to Content
0
Former Member
Jun 02, 2009 at 07:09 PM

Refresh of Xcelsius Dashboard with data from SAP BW

90 Views

Hello fellow Xcelsius users,

I am quite new to Xcelsius and I do run the following configuration:

Xcelsius 2008 (Version 5.0.0.99) integrating a WebI-Report over LiveOffice. The WebI-Report gets the data from a BO Universe, which in turn receives the data from a SAP BW query. So far, so good.

The problem regarding the refresh of the dashboard is the following: After data has been updated in SAP BW, I would like to have the dashboard receive the newest data when being loaded, i.e. when the SWF file with the dashboard is opened by the user, it should refresh the data (through LiveOffice -> WebI -> BO Universe -> BW query). The connection is configured to "refresh on load" (translation from german version) and when opening the SWF the BO credentials are being asked for. No error message shows up so the connection seems to be working. BUT: The dashboard would not show the newest values, but instead still the "old" ones.

The strange thing is that when hitting the "refresh all objects" (translation from german version) button in the LiveOffice panel in the Xcelsius data section (the excel sheet within Xcelsius) the new values do appear in the spreadsheet and of course they will as well in the SWF that is being created out of this XLF afterwards. But this not the way it is supposed to be.

I guess I am missing some configuration or s.th. at some point. Does anybody have a clue where this point might be?

I hope I made my problem clear. If not, please let me know.

I am grateful for any hint! Many thanks in advance!

Best regards,

Kai

Edited by: questions_answered on Jun 3, 2009 7:40 AM