View Source

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-5-31 15:28:46.png

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

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

Snapshots are created in SQLServer replicated database from eRoom databases of several GBUs having the same eRoom database template.

Universe Design

ICPMv2.5.UNV

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

Main BI4 Reports