Symptom
Environment
Business Objects Enterprise (BOE) XIR3.1, Service Pack 3, Fix Pack 3.3
Xcelsius 2008 Service Pack 3, Fix Pack 3.3
Adobe Flash Player 10.1
Microsoft Office 2003, 2007
Reproducing the Issue
- Create Crystal Reports based on Universe(s)
- Create a Dashboard in Xcelsius 2008 based on Live Office Connection.
- Live Office Connection settings set to latest instance of Crystal Reports
- From File->Export option export the Dashboard to Business Objects Enterprise (BOE).
- Edit the Crystal Reports
- Schedule the Crystal Reports again
- Try to preview the Dashboard in InfoView and check the results
- In Xcelsius rename the Excel tabs and export the same to BOE
- Again make some more changes in the Crystal Reports and save them back to BOE
- Schedule the Crystal Reports again and try to preview the dashboard
- It will not display the refreshed data.
Cause
Resolution
- Export the Excel outside Xcelsius from Data-Export
- Save to your hard disk E.g. D:\Test.xls
- Open the Excel sheet and rename the sheet tabs
- Save the Excel and Import it back to Xcelsius from Data->Import
- Map the components in case the mapping is lost
- Create the connections again from Data Manager->Connection
- Export the Dashboard back to Business Objects Enterprise
- This time the Live Office connection will display the refreshed data
Keywords
Live Office, Crystal Reports, Xcelsius, Refreshed Data , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem