Overview

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

Database Design

Database Diagram

Tables

Tablename

Description

Tablename

Description

Relationships

Source Table

Join Type

Target Table


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

Main BI4 Reports