PD 2026-01-29

Hierarchical Gantt chart capabilities

Hierarchical Gantt chart offers to display WOs and operations by Series or, to go further, by Advanced Series. This Gantt is available from Ortems R2021 Refresh 4.

By Series:

1 row per serie that is expandable. When expanding it, are displayed all the WOs of this expanded Serie. Each WO row is also expandable. When expanding it, are displayed all the operations of the expanded WO.

Organization is Serie > WO > Operation

By Advanced Series:

More powerful because it benefits of all Advanced Serie features:

There is no limit to the number of levels (Serie level 1 > Serie level 2 > … > Serie level N > WO > Operation)
Any WO can belong to several series to offer different analysis level (by geo, by flavor, etc.)

Examples of what can be obtained

Better than words, here is an example of what can be obtained using Hierarchical Gantt chart on Advanced Series.

Hereunder is displayed a Hierarchical Gantt chart, configured on View “Advanced series”. Here WOs are organized per Geo.

For example, in Geo-North-America, we have USA
in USA we have Florida
in Florida we have LongBeach
in LongBeach we have 3 WOs (WO-00017, WO_00020 and WO_00091)
and of course for each WO it is possible to show its operations.

Below is shown that any WOs can belong to more than one Serie.

For this example, are highlighted 3 WOs (WO_00012, WO_00074 and WO_00021) belonging to their Flavor categories (Grapes, Grapes and Pineapple) and to their Geo sectors (Lyon - France, Krakow – Poland and Lyon-France).

How to implement from WIP Control module

Only one menu is required: WO management > Classes

The screen is made of 3 parts:

On the top part

the classes (=main categories) have to be created.

In the left below part

create all the series (whatever their level) belonging to the selected main category (GEO on the screen-shot).

The right below part

dedicated to links between series for all series except the last level ones, and links between last level series and WOs (FLORIDA – USA is selected).

To link a serie with its lower level series, the tab to use is “Series of series” (on the screen-shot, LONGBEACH – FLORIDA – USA is the only one serie of FLORIDA-USA upper serie).
To link a last level serie to WOs, the dedicated tab is “Series of WOs”. It requires to add all the WOs belonging to the lowest level serie selected on the right part.

Data organization in order to populate db tables by interface

B_CLASS_SER contains the upper part of the WIP Control screen. It is the list of all the classes (GEO, FLAVOUR).

B_SER contains the list of all the series for all categories. CODE_CLASS field contains the class (GEO, FLAVOR) while SERIE field contains the records presented in left below part of the WIP Control module screen (FLORIDA_USA, FRANCE, GEO-EUROPE, etc.).

B_S_SER contains the “Series of series” information where SERIE field is the parent serie and B_S_SERIE field is the child serie.

B_OF_SER contains the “Series of WOs” information where SERIE field is the serie to which NOF field (=WO id) belong.

After launching the WOs, the data used to display the Hierarchical Gantt chart are copied from B_OF_SER to E_SER

E_SER contains the links between the lowest level series and their WOs.