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.