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
Example of e-room database
PAX Chart flow from 06/2019
Contact
OPERXL application owner (Solvay) : Dominique PETIT, Françoise NEAULME
Transfer from e-room to SQL database : Cap-Gemini ( murtuza.hariyanawala-ext@solvay.com )
Overview
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
Database Diagram
Data Loading
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 )
Universe Documentation
Operational Excellence (CPM).UNV
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
Main BI4 Core Reports
BI4 core folder: 521 - Operational Excellence
Useful links
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 ...