SAP Knowledge Base Article - Public

1351418 - How to connect data source in Xcelsius?

Symptom

How to connect data source in Xcelsius?

Environment

  • SAP BusinessObjects Xcelsius Enterprise 2008
  • SAP Live Office
  • Microsoft Office Excel

Resolution

  • Use LiveOffice which is able to import Universe query, WebI or CR to Excel.
  1. Create a universe for the data source
  2. Create a Web Intelligence report, or Crystal Report with this universe.
  3. Open Excel, click LiveOffice, insert the report into Excel, select the fields from the report which should be inserted in Excel and click Next, then finish and refresh the data into the Excel file.
  4. Open Xcelsius 2008, click import spreedsheet
  5. Import the Excel file in Xcelsius 2008, and use it as the Xcelsius speedsheet.
  • Or, you can use a QaaWS as data connection to connect a universe query, hence you can connect Oracle or other dynamic data.
  1. Create a universe with the data source to access.
  2. Click Start -> All Programs -> BusinessObjects XI3.1 -> BusinessObjects Enterprise -> Query as a Web Service.
  3. Create a new QaaWS connection with the universe created, and copy the link of the new created QaaWS.
  4. Open Xcelsius 2008.
  5. Click Manage Connections, add a new QaaWS connection  in Data Manager dialog, paste the link into the QaaWS connction, fill the logon information for access BusinessObjects Enterprise, and choose the Excel cells to place the data.

Keywords

Excel Query as a Web Service How-to , KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008