Process Chain Run-time Analysis

[Former Member]

Hello BW experts,

I'm a BW guy and I am tasked to make a program that will compute the average run time of every active process chain. Active I mean still being used and running on a regular basis. After computing for the average run time, it will be stored into a 'Z' table together with the other details of the chain. Then another program will be scheduled to run periodically to check if the chains are not running too long compared to the computed average run time of the first program.

But first things first, I want to know the best way to compute for the average run time of every active chain on our system. I've read about the RSPCPROCESSLOG table and found out that I could get the start and end timestamp there for every chain variant. It seems simple in theory because you would just subtract those timestamps and add all the results for the variants and then you could get the runtime of that specific run. But I am looking for an API that could actually do that for me.

Could you suggest some APIs that are actually intended to do this kind of job? Or is there any other approach that you know for doing this?

Any suggestion would be much appreciated. I'm willing to study everything that I need to just to finish this because again, I'm a BW guy and have a little knowledge on ABAP.

Thanks,

Rhonald Pahayac

[former_member202257]

Go to ST13 --> Select BW-TOOLS --> Select Process Chain Analysis --> Enter the PC technical name and execute

You should be able to view the runtime of the process chain for any given range of date and time.

[former_member182516]

Hi Rhonald,

As already stated by our friends you can use SAP provided  analysis tools to get such information.

Are you looking only for the Process chain start and end time then as stated in your post, you can pick them from RSPCPROCESSLOG and store them in Z table. If you want to analyze all the process involved in a particular Process chain, best suggestion would be to use the SAP provided tools.

For code implemented in the tools of process chain analysis, you can check the Program "/SSA/BWT". In the program check " history of the Process Chain part" which gives you an idea on what tables are used for analyzing the process chain processes.

If you are not good at ABAP take help of ABAP person.

Regards

KP

[RamanKorrapati]

Hi,

Go Thru RSPCM or RSPC, go to individual chain(which was active at prod) click on start variant -->right click-->display logs/see the ran logs/messages. in that you can see start time.

Later go same chain last process type step-->right click-->display logs, see there finished time.

that will give the time taken by your chain. like that need to do for all other active chains at prod.

Thanks

[Former Member]

Hi

You can either use RSPCM or SE38 -> /SSA/BWT to get the details.

Or you can also try exploring the tables.. http://wiki.scn.sap.com/wiki/display/BI/Important+Tables+in+SAP+BW+7.x

Thanks

Dhruv

[Former Member]

Hi,

Your BW system is on which version?

7.4 has this 'Time monitoring' feature integrated in RSPCM, and it shows if chain is exceeding average run time..

I have not used 7.3. So am not sure there.

If you are on older version, and planning for upgrade soon, better off to wait!

[Former Member]

Hi Rhonald,

Get the run time of all process chains from standard report mentioned by Vivek and then see the points below.

• you can export the run time of all process chains to your local machine, save it in a CSV format
• you can create an APD and use this flat file as source then push the data to a Direct update DSO,  Psnote: direct updated DSO always does a full load, so you can push data from direct DSO to Standard DSO on daily basis to store the history.
• and from there you can do a simple bex query report, take process chain and date in rows and run time in columns.
• this will give the details in one shot to compare or analyze.

[Former Member]

Hi Rhonald,

Go to se38 Type in /SSA/BWT

Insert the process chain and then Execute. You would get the run time of the chain

[former_member183519]

HI,

as suggested by viveklal, u can make copy of /SSA/BWT program and on of of that enhance for storing timestamps in Z table as per your requirement.

You can get detailed view about PC using:

1) SE38->/SSA/BWT

2) ST13-> BW_TOOLS

Regards,

Hitesh