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.

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.

Workaround:

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