Wally doesn’t like to be troubled, bugged or made to do work; but every morning he has the task of reporting three different set of IT users from the sales department whether their reports are ready with the latest data.


A month back he was seriously troubled when someone from the Finance department scrutinized the date of last refresh of the data, but since then things have changed and he has undergone a training himself to address trick questions from the users when no technical support is around.


Any way that’s old story- what he wanted now is a status message which will indicate whether those sales reports coming from three different cubes for those three different guys are ready with latest data or not.


The task was simple with not much coding…


Table, RSRREPDIR has two fields INFOCUBE which provides the name of the infocube, and COMPID which provides the technical name of the query.

With the list of queries which Wally wanted to check a simple code fetches the corresponding cube from RSRREPDIR.


With this cube name, we can go to table: RSSTATMANPART and find the request status: STATUS_OUT, Aggregation status: AGGRFLAG, compression flag: COMPFLAG, reporting status: REPORT and most importantly the request date: DATUM_ANF.


If this request date is for the current date (i.e sy-datum) and the request status is OK then the program would return that the corresponding report is indeed ready with the latest data.


Since Wally needed the same info to come in the dashboard I generated a XML(as discussed in the previous blogs) and gave it to him.

[nb: a little extra coding effort would have been required had the reports came from multiproviders]

There are times when we do something for one pure and simple reason: "Because We Can”. So when Wally wanted to see all the customer stores in the country in Google maps, I said why not!


We can maintain a master data with the coordinates (latitude, longitude) in SAP BW and write a code which will read these coordinate from the master-data table and generate a geoRSS or a KML or a KMZ file.

There is a growing trend among internet users to use these file formats to exchange publish and consume geographical data, and moreover google maps consume them readily. These formats are more or less like a normal xml file with a few extra tags, that’s all…

The only question in my mind was whether I could generate the KML file or not; but there is no reason why we can’t considering that we can quite easily generate a XML.

So once we generate the KML through ABAP we can place it in share-point or some webhosting site and consume it directly though google maps.


It's cool for the customers to view their stores/plants in the map, and to know that they are indeed having a footprint in the information superhighway.


In fact we can we can write a small app that will handle this in a more sophisticated manner in an Iphone.

This time Wally wanted to see the all the process chains running in all the BW landscapes (7 differeent BW boxes) in one excel sheet. He was recently promoted as the head of the BW support team and got a swanky cabin. It is understood that one is not supposed to log in to SAP system after getting a cabin (some kind of unwritten rule)- hence he asked me to come up with a tool that will fill his excel sheet with all the process chains running in all the BW servers that he was supervising.


So how do you do it?

1.       Create a BSP that will generate an XML which in turn would list all the process chains running in the system. ( basically an abap code that will read RSPCCHAIN, RSPCCHAINT etc.)

2.       Copy the code in all seven systems and activate them to generate the corresponding XML.

3.       Open the generated XML in separate tabs in the MS Excel sheet.

4.       Done.  You can refresh the XML map in the sheet and get the latest details.


You can use the same xml in a Xcelsius dashboard. Getting a ticker for all the failed process chains would indeed look good in a big screen monitor.

Ever wanted to find the list of active cubes in the system at the touch of a button?

Ever wished that you had a comprehensive report of the data load before the users start using the system the next morning?

What about list of transformations/transfer rules that got deactivated after some maintenence/enhancement transports moved to production?

Now all that and more can be done at the touch of a button? Thanks to GUIXT and the collaborative effort of my coffee buddies.


I call it SApps (SAP Service Apps)– a suite of menus that can be plugged into standard SAP screens to aid and expedite support activities.


here is an example of the SApps button working prototype that lists the number of active cubes in the landscape






Will try come up with a separate blog on how to do this as soon as time permits.


Remember my earlier blog on why we should keep a snapshot of the BW landscape?



Filter Blog

By author:
By date:
By tag: