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


  2. 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.

  3. Data Loading

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

  4. Universe Design

  5. Main BI4 Reports