This is Part II of the “Live Dashboards using BO LiveOffice” Series. In Part I, Kalyan Verma Introduces LiveOffice and its connection with Xcelsius 2008. In this post Muhammed Ismail, walks us through the steps on “How to Create a LiveOffice Document and connect it to BusinessObjects Universe data”.
To create Live Office document first open the formatted Excel template. Set the BO Enterprise credentials by selecting Live Office, Options from MS Excel.
Logon to BO Enterprise by selecting Enterprise Tab and put the BO Logon credentials
Create a New Live Office query from “Live Office”, “Insert”, “New Query”
Choose the BO universe that has the data for the Live Office document.
Select the objects you wish to show in your Live Office document. In this example we are trying to show countries of a specific region.
Save the Live Office object. Please note Live Office object is different from Live Office document.
Select the “Prompt Value” button to set the cell location
“Choose Excel data range” using the data icon button.
Verify the prompt value cell is bound to Excel by looking at “Selected Value”
This concludes Part II of the Series. In Part III, I will describe “How to bind LiveOffice data to Xcelsius Components and create a live Dashboard”. If you have any questions related to the above post, please leave a comment or eMail me.