Skip to Content

Connecting transparent tables from ECC to Xcelsius dashboard through XML

Did you ever face a requirement to bring data from a table (standard/custom) into a dashboard? Have you ever wanted to flash an alert for a failed process, in a big screen dashboard?

The possibilities are high and lucrative and I have to figure out a way to patent my ideas before you finish reading this post. 

The scenario:

You have a table say ZSAMPLE which has all the records of the delayed
processes still active in your landscape. Now you want to reflect this detail on a dashboard (Xcelsius), so that the alerts/anomalies are prominently displayed in a giant monitor for the monitoring team to take action.

So, how do you do it?

(Connecting tables to Xcelsius dashboard through XML)

Step 1: Generate a XML URL to retrieve data from SAP tables.

Quite simple really… Just write your selection/processing logic inside a BSP (ABAP) code to generate a XML URL. Plenty of how-to-do docs on BSP are available on Google; nevertheless just let me put the code framework; your code should look something like this:

<data>

<variable name = “variable1”>

<% write your ABAP logic
inside tag %>
<row>

<column>

<%= your output field should
come inside this tag %>

</column>

</row>

</variable>

</data>

When you activate this BSP, you will get a XML URL (something like this): http://server_name:port_number/sap/bc/bsp/sap/zbsp_test/bsptest.xml

+ +

Step 2: consume XML in your dashboard.

In your dashboard design tool (Xcelsius) use this URL as your source of data. Explicitly specify all the variables that are defined in your BSP; just link your dashboard components to the data cells and you are ready to build your dashboard that talks to SAP tables.

Simple….

Be the first to leave a comment
You must be Logged on to comment or reply to a post.