Monitoring process chains through MS Excel
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.
Hi Arka,
This sounds interesting. Could you please provide more details on this.
I am from Basis team and would like to suggest this to my BI team
Thanks,
Pradeep
Hi Pradeep,
The crux of the idea is to expose the table/fields though an XML/URL.
One may generate an XML by writing an ABAP report or by using a BSP.
What I have done is that i have written a small BSP code to generate an XML which will give me the fields such as process chain name, current status, start time, etc..
All these details are available in standard tables; just written a few select select statements and created a few joins 🙂
Once ready with the XML all i had to do is open the same in an Excel sheet.
note: i am also working on the mobile app part of it; for further details you may always contact me through email/mobile.
Thanks, Arka