SAP Knowledge Base Article - Public

1352545 - Better integration of Live Office (LO) documents with Xcelsius


Changes to the Webintelligence part integrated in an Excel file via Live Office (LO) have to be manually propagated to an Xcelsius dashboard by re-importing the Excel file in the Xcelsius model and re-applying mappings and formulas.

Reproducing the Issue

  1. Open a new Excel file
  2. Go to LiveOffice/Insert/New Query
  3. Logon to BusinessObjects Enterprise
  4. Create a query based on the demo universe ‘Island Resorts Marketing’ with the objects: Country, Resort and Service Line
  5. Insert the query results in the Excel file
  6. Save the Excel file as ‘demo.xls’
  7. Open an Xcelsius dashboard
  8. Import the Excel file ‘demo.xls’ in the Xcelsius dashboard
  9. Add a Live Office connection by going to Data/Connections/Add/Live Office connections to refresh the data of the Xcelsius dashboard
  10. Save the Xcelsius dashboard
  11. Open again the file ‘demo.xls’ in order to add another object to the previous query
  12. Go to LiveOffice/Modify Object/Edit Universe Query
  13. Add the object ‘Service’
  14. Save the demo.xls file with the new object 'Service'
  15. Open the Xcelsius model -> the new object ‘Service’ is not shown in the Excel file demo.xls when you refresh the data using the Live Office connection
  • Xcelsius 2008
  • Live Office XI R2 and R3.1


The integration between Live Office and Xcelsius application is limited to the 'Refresh' functionality


Enhancement Request ADAPT01161470 has been created.


The new Excel file containing the added column needs to be re-imported in the Xcelsius model in order to include the modifications and any mappings and formulas between the Excel file and the Xcelsius model re-applied.


Spreadsheet, webi , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Product Enhancement


SAP BusinessObjects Xcelsius Enterprise 2008