Thursday, February 3, 2011

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

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://.com:/sap(namesapce)

Now the data from the XML has to be mapped to a series of range. Mark check on “Enable Load” and click on “+”. Name the series as “Q1” which we used the variable name in the XML file and select the ranges based on the data. Click on preview XML and compare the XML file generated by Xcelsius preview and the XML generated while testing XML view from BSP application. The format should be the same, so that the data can be parsed easily between the BSP and SWF file which is going to be generated.

Now export the Xcelsius file as a flash file.

Now the BSP application will be enhanced with an HTML page which will be holding SWF file and will be displayed during the run time. Place the below code shown in the screen on the layout of HTML view.

Now test the HTML view and SWF file will be generated. Based on the different selections on flight date the data will be changed as shown in the below screens.

No comments:

Tutorials on SAP-ABAP

Adobe Interactive Forms Tutorials

Business Server Pages (BSP)


Web Dynpro for ABAP (Step by step procedure for web dynpro,Tutorials on Web Dynpro,)

ALV Tutorials

Blog Archive