Integrating SAP data (R/3 or BW Data) with the BO-Xcelsius (Business Objects) using BSP 

Part 3: SAP BSP + BO-Xcelsius (XML Data Connection)

By Gokul Natarajan, Kaar Technologies

In this presentation the third connection of Xcelsius – XML data is used to integrate with SAP BSP, so that the data will be presented in the dashboard.  

Create a sample BSP application “ZDEMO_XMLDATA”  

Create a XML view in the BSP application based on the PWFL model. Embed the below code shown in the following screens. The code is mainly projected to generate the XML file which is going to act as a source for the SWF file in a particular format. The CALL TRANSFORMATION ('ID') will generate the XML file using the data in a format based on the system / server settings. The pre defined format has to be achieved based on replacing some tags with other values as shown in the below screens.  

The below screen is the predefined format with data, variable, row and column tags generated while testing the XML view. The generated XML has to be parsed to the Xcelsius file. Sometimes the target might not be achieved if the format of the XML file is not proper.  

Open the Xcelsius 2008 and design the canvas using a list box and a column chart. The list box will be holding the date of the flight and the column chart will represent the maximum and occupied seats of the particular class on the selected date.

Now the data connectivity has to be assigned to the Xcelsius file. The XML path will be taken from the properties of the XML view as shown below.  

The XML data URL will be the copied URL from the above screen. The URL can also be dynamically changed by keeping tags on the server name. eq. http://<webserver>.com:<port>/sap(namesapce)  

Click here to continue...