Daily Process Chain Runtime KPI

Scope

Currently this process is only covering the WBP BW Server (Rhodia legacy production).

Commitment to our users


The commitment we have with our users is that all daily data relevant to them must be correctly loaded and ready before 9 AM PARIS TIME.
This applies only for week days.
The objective of this process is therefore to calculate and publish an indicator that shows how often we finish before 9am as agreed.

Main Indicator: Process Chain Daily Runtime


The main indicator is the Daily Runtime.
For each week day, we calculate this daily runtime and then publish the percentage of days on which the daily runtime was less than 9 hours.
The daily runtime is defined as the time between 00h (Paris – Server time) and the end time of the last chain started that day.
For a given date D:
Daily Runtime D = MAX(End Date/Time) where Start Date = D
The %

Process Chains Included in the process

Rules of inclusion

All process chains should be included in the list but only some should be considered for the KPI/process. Those are shown by the "In Scope" flag. This flag is to be set only process chains which are:

Current list

The list of kept up to date in a Gdrive spreadsheet :

https://docs.google.com/a/solvay.com/spreadsheets/d/1UrcvE_NcO8CSrqR01sjhtW5A_18O7bkZ1xfEa8pZkaw/edit#gid=1143911161

Definition of the fields:

Important: If the process chain is not scheduled directly as a main chain but via another chain, then the frequency is "Ad-Hoc" (as it could be run as main via manually executing it)

List update process

The list can be updated at any time by the monitoring team when they get notified about a new process chain to be added.
Otherwise a review meeting is set up every 3 months in order to check all the new process chains that were not included in the list.

KPI Communication


The KPI, as well as the explanations if needed, are published monthly, on the first week of the month, in the Reporting Group in Engage, by the monitoring team:
https://engage-solvay.jiveon.com/groups/the-reporting-group
The publication must contain:

Process Chain Logs – The raw data

Process Chain Logs Explanations

These are the fields that are found in the raw data :

How to collect the raw data

1 - Log into WBP

 2 - Run Transaction ST13

 3 - Select the "BW-TOOLS" toolname and execute :

4 - Select the "Process Chain Analysis" and execute :

5 - Click on "Process Chains"


6 - In the "Start Date" and "End Date", enter the interval you want to extract (keep the rest empty)

7 - Once on the result page, click on "Change Layout".

 

8 - By default the "Red Steps", "Yel Steps", "Errors" are not included in the layout. Add them :



9 - Once Errors have been added, you need to export the data. Click on Export and "Local File" :

10 - Select "Spreadsheet"

11 - Select a destination on your computer and click on "Generate" (or "Replace" if replacing a file)

12 - Save it as "ST13 raw data.txt"