Skip to Content
avatar image
Former Member

Process Chain Run-time Analysis

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Oct 23, 2015 at 07:46 AM

    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


    pic.png (20.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 23, 2015 at 08:16 AM

    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.
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2015 at 02:07 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2015 at 04:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2015 at 12:45 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 03:08 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 07:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded