Skip to Content

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….

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply