Symptom
- When refreshing a LiveOffice connection in Xcelsius you receive the error: Cannot Access External Data
- Detailed error message:
'An error has occurred.
For more information contact the file creator or your system administrator.
Error {0}
Connection Type: {1}
Reproducing the Issue
- Launch Xcelsius
- From the menu select Data > Import
- From the Common Dialog window to select the file to import, locate a MS Excel document containing Live Office data, select it and click on Open
the MS Excel document with LiveOffice Data is inserted in the grid - From the Xcelsius menu select Data > Connections
the Data Manager screen is displayed - Click on Add
- Select Live Office Connections
- Select the connection displayed on the left pane of the Data Manager window
- Leave the Session URL as it is
- Click on the Usage Tab
- Check the Refresh Before Components Are Loaded option
- Click on Close
- Insert a component i.e. Pie Chart and set the properties for the Data Values
- From the Components / Web Connectivity drag and drop a Connection Refresh Button onto the canvas
- Select the Connection Refresh Button
- goto the Properties panel
- Click on the Behavior tab
- Check the Refresh After Components Are Loaded option
- Click on the Preview button which is in the toolbar: the error is thrown
Cause
- the Session URL specified in the connection definition hasn't been changed from the default one (http://<webserver>:8080/dswsbobje/session)
Resolution
- specify the correct Session URL in the Data Manager panel:
- From the menu select Data > Connections
- Select the first available connection on the left pane of the Data Manager screen
- Specify a valid URL in the Session URL
- if there are other connections do the same for each one of them
Keywords
KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To
Product
SAP BusinessObjects Xcelsius Enterprise 2008