SAP Knowledge Base Article - Public

1607783 - Live Office prompt bindings to Excel spreadsheet are not preserved over Xcelsius 2008 restart

Symptom

  • After closing and re-opening Xcelsius, the Live Office prompt binding is lost
  • Xcelsius dashboard does not refresh in Preview mode. 

Environment

  • Xcelsius 2008 SP3

Reproducing the Issue

  1. Launch Xcelsius
  2. Go to Live Office > Insert a Web Intelligence document
  3. Import the Web intelligence document
  4. Refresh the Live Office object
  5. Select a prompt value - the data is refreshed fine
  6. Go to Live OfficeObject properties
  7. In the 'Prompts' tab, bind the prompt to an Excel cell.
  8. Save the Xcelsius project
  9. Exit Xcelsius
  10. Launch the Xcelsius and open the project.
  11. Go to Live Office > Object properties

==> the Prompt value binding to Excel spreadsheet has disappeared.

Before Xcelsius restart:

bound.JPG

After Xcelsius restart binding is gone:

unbound.JPG

Cause

This is by design. The Live Office connection in the Data connection needs to be configured after the Live Office prompt binding is done.

Resolution

  1. Launch Excel
  2. Create Live Office document, define all prompt bindings and save it as an Excel file.
  3. Launch Xcelsius
  4. Import the Excel file
  5. Go to Data Connection and define LO connection in "Data Manager".

Keywords

prompt, LO, bind, Excel, cell, binding, selected value, live office, maintained, refreshed, exit, relaunch , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008