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
Operational Excelence 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.
Universe Design
Operational Excellence (CPM).UNV
26 classes
460 objects
26 conditions
13 tables
7 alias
18 joins
8 contexts
1 hierarchies