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.
Select a prompt value that will be passed in the Live Office document.
For e.g.: passing Asia will give all the countries in the Asia Region.
Save the Live Office object. Please note Live Office object is different from Live Office document.
A list of countries and region from the BO universe will be inserted to the Excel file.
Bind a cell to change the Input parameter by selecting the Prompts tab from “Properties For All Objects”.
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.
Hi can you please let me know how to enable the live office button in excel? i am using Ms office 2007 version.
Locate the enable_addin.exe utility
It is usually usually located at C:\Program Files\Business Objects\BusinessObjects Enterprise*\Live Office*\enable_addin.exe
Double-click enable_addin.exe select the Microsoft Office 2007 application for which you want to enable the Live Office Add-In and click OK.
[...] gives a brief introduction to LiveOffice and the connection between LiveOffice and Xcelsius. In Part II, Muhammed focuses on “How to Create a LiveOffice Document and connect it to BusinessObjects [...]
[...] Series. In Part I, Kalyan Verma Introduces LiveOffice and its connection with Xcelsius 2008. In Part II Muhammed Ismail, walks us through the steps on “How to Create a LiveOffice Document and connect [...]
Hi, I just want to know how to get the prompt if the report is saved in a schedule mode and we need to filter the data based on the last report saved (it means we have the report schedule and the data is cached. We dont want to hit the database based on the filtered criteria set at XCelsius). Why i am asking this question, because if you have a large DB then its difficult to get the data at the earliest, as the response time will be slow through the DB. Please help me out from this, if you need any clarification, please dont hesitiate to ask me.
I am unable to add LIVE OFFICE connection in XCELSIUS dashboard. Opened Data Manager in Xcelcius -> clicked on add -> Live Office Connections. Nothing happens!
Shouldnt I see my existing live office connection here? pls help.
Hi,
A predefined filter “Region’ has been used instead of using the “Region” object and then selecting prompt. If predefined filter is used then the next screen shown does not appear for filters, so a new screen should be added without predefined filter .
Baazi
bonjour mohamed et merci beaucoup pour cet documentation:
en effet, je vouderais te demander si t’a une documentation sur BO live office ,
par ce que la je vais travailler sur un projet de ce genre ,
merci
Excuse me. Does somebody know how to define an actual Expert Avisor from bad and a clear signal from fraudulent? thank you
I can´t connect Xcelsius to Live Office probably because I have not taken the right softwares.
Could you please send me the links to download the Live Office and BO ?
Thank you Very much!
Thanks alot for the very elaborative tutorial.
But I was wondering what are the right liscenses that an organization has to acquire to in order to incorporate LiveOffice in the environment.
Right now the organization has BO Enterprise R2
Also I want to ask if LiveOffice is to be purchased alone or as a add-in for BO.
Thanks Alot.
Dear All,
I am trying to connect xcelsius to a webi report… once I have that connection I would like to be able to refresh the data in xcelsius…
how can this be achieved?
Regards,
Paul