Operational Excellence (Critical Path Method)
===============================================================
===============================================================
Application fully decomissionned on 02/2021
Decomm BI4 folder "521 - Operational Excellence" - https://sbs-support.solvay.com/a/tickets/5250116


OPERXL application owner (Solvay) : Dominique PETIT, Françoise NEAULME
Transfer from e-room to SQL database : Cap-Gemini ( murtuza.hariyanawala-ext@solvay.com )
The Operational Excellence application deals with Sixsigma projects portfolio stored in eRoom databases.

The universal export tool makes the snapshot copies from eRoom databases with the same template to a sqlserver database

OPERXL snapshots are created in SQLServer replicated database three times a week (Monday, Tuesday and Thursday) from eRoom databases of several Business Units but having the same eRoom database template. Anyway only the latest snapshot copy for each month is kept in the replicated sqlserver database.
Transfer from e-room to SQL database : Cap-Gemini ( murtuza.hariyanawala-ext@solvay.com )
26 classes
460 objects
26 conditions
13 tables
7 alias
18 joins
8 contexts
1 hierarchies
Link to documentation of UNV version of Operational Excellence (CPM) universe

Link to UpToDate documentation of universes (from 360 eyes)
Link to Knowledge Transfer documents for Operational Excellence (CPM)
*** This application is in the list of eRoom databases to be migrated to SQLServer 2008 *** see details ...