Innovation Critical Path Method

_{*** No WebI report using this universe has been refreshed by end users in 2016 ***}

Overview

The ICPMv2.5 BI4 application deals with R&D projects portfolio stored in eRoom databases.

TECHNO - BI TEAM > zzz ICPM - Innovation Critical Path Method > image2016-6-3 10:57:10.png

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

*** It is not planned to be migrated to SQLServer 2008 ***

Database Diagram

ICPM v2.5 Database Diagram

TECHNO - BI TEAM > zzz ICPM - Innovation Critical Path Method > image2016-5-31 15:54:46.png

Several snapshots are available in the replicated database having the Integration Date as the snapshot ID.

Data Loading

ICPM snapshots are created in SQLServer replicated database twice a week (Monday 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 Documentation

ICPMv2.5.UNV

18 classes
325 objects
17 conditions
18 tables
2 alias
18 joins
3 contexts
1 hierarchies

Link to documentation of UNV version of ICPMv2.5 universe (PDF)

Main BI4 Reports

BI4 core folder: 511 - ICPM (Private)

TECHNO - BI TEAM > zzz ICPM - Innovation Critical Path Method > image2016-6-10 9:23:43.png

Useful links

Link to UpToDate documentation of universes (from 360 eyes)

Link to Knowledge Transfer documents for ICPM

*** This application is in the list of eRoom databases to be migrated to SQLServer 2008 even though the last action was made on 12-2014 *** see details ...