This folder is no more used. It has been flagged as OBSOLETE in 05/2019.
But loading Jobs and universes are kepts until end of BI4 decommissionning
See in this link list of users whose rights have been removed
============================================================
| Table of Contents |
|---|
============================================================
*** 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.
Database Design
Database Diagram
Tables
Tablename | Description |
|---|---|
Relationships
The universal export tool makes snapshot copies from eRoom databases with the same template to a sqlserver database
DATABASE
ICPM v2.5 Database Diagram
...
Source Table
...
Join Type
...
Target Table
...
Several snapshots are available in the replicated database having the Integration Date as the snapshot ID.
Data Loading
DATA LOADING
ICPM snapshots Snapshots are created in SQLServer replicated database twice a week (Monday and Thursday) from eRoom databases of several GBUs 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
ICPMv2.5
UNIVERSE
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)
BI4 connexion to E-room database
MAIN BI4 REPORTS
BI4 core folder: 511 - ICPM (Private)
USEFUL LINKS
Link to UpToDate documentation of universes (from 360 eyes)
Link to Knowledge Transfer documents for ICPM
*** This application is not in the list of planned eRoom applications to be migrated to SQLServer 2008 *** see details ...
...