SAP Knowledge Base Article - Public

1447398 - Cannot Access External Data when refreshing a LiveOffice connection

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

  1. Launch Xcelsius
  2. From the menu select Data > Import
  3. 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
  4. From the Xcelsius menu select Data > Connections
    the Data Manager screen is displayed
  5. Click on Add
  6. Select Live Office Connections
  7. Select the connection displayed on the left pane of the Data Manager window
  8. Leave the Session URL as it is
  9. Click on the Usage Tab
  10. Check the Refresh Before Components Are Loaded option
  11. Click on Close
  12. Insert a component i.e. Pie Chart and set the properties for the Data Values
  13. From the Components / Web Connectivity drag and drop a Connection Refresh Button onto the canvas
  14. Select the Connection Refresh Button
  15. goto the Properties panel
  16. Click on the Behavior tab
  17. Check the Refresh After Components Are Loaded option
  18. Click on the Preview button which is in the toolbar: the error is thrown

Cause

Resolution

  • specify the correct Session URL in the Data Manager panel:
  1. From the menu select  Data > Connections
  2. Select the first available connection on the left pane of the Data Manager screen
  3. Specify a valid URL in the Session URL
  4. 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