• Overview of Planning Your Implementation
    • About Oracle Primavera Data Warehouse
    • About Oracle Primavera Analytics
    • About Oracle Primavera P6 Enterprise Project Portfolio Management
    • About Oracle Data Integrator (ODI)
    • About Oracle Primavera Unifier
  • Working with Oracle Primavera Analytics
  • Critical Performance Factors
    • Pulling Data between Servers
    • Merging Updates into Target Database
    • PL/SQL-based Transformations
  • Planning Process
    • Requirements Phase
      • About Partitioning
      • Significance of Operational Reporting
    • Planning Phase
      • Full ETL Process Only
      • Monitoring Usage
      • Basic Monitoring
  • Physical Sizing
    • Table Partition for Multiple Data Source and History Data
      • Archiving and Restoring History
        • Archiving History
        • Restoring Archived History
    • Physical Components
      • ETL Process Server
      • Calculating Spread Sizes
        • Queries for Spread Sizing
        • Estimating the Size of the Primavera Data Warehouse Database
      • Primavera Data Warehouse Database
      • Oracle Data Integrator (ODI) Sizing
        • ODI Sizing for P6 EPPM Projects
        • Primavera Data Warehouse Database for ODI
        • ODI Master and Work Repository
        • ODI Java EE Agent
    • Physical Hardware
      • Monitoring Dimension and History Level Impacts on the Database
      • Consideration for ETL Performance
        • Network
        • Memory
        • Extract and Load
        • Oracle Data Integrator (ODI)
      • Summary of Physical Hardware Sizing
        • Size of Database
        • Amount of Change
        • Complexity of Project Data
        • Expectations and Operations
        • Database Servers
    • Planning Revisited
      • Timing Estimation
      • Factors Affecting ETL Runtime
  • Planning for the Impact of P6 EPPM on Primavera Data Warehouse
    • Choosing Whether to Use Partitioning
    • Effect of the P6 Extended Schema on Primavera Data Warehouse
      • Date Range
      • Enable Publication
      • History Settings on Project Level
      • Slowly Changing Dimensions
    • Multiple Primavera Data Warehouse Environments
    • Creating Multiple Data Sources for a Single Primavera Data Warehouse Database
      • Setting up Multiple Data Sources
      • Filtering by Data Source in Analytics
    • Single Primavera Data Warehouse, Single Data Source, Multiple ETLs
  • Appendix A: Checklists for Primavera Analytics and Primavera Data Warehouse
    • Pre-installation for an Oracle Platform
    • Pre-installation for a Microsoft SQL Server Platform
    • Pre-installation for Configuring the ETL Server
    • Pre-installation for Oracle Data Integrator (ODI)
    • Pre-installation for the Primavera Data Warehouse Database
    • Installation: Installer And Configuration
    • Installation: Running The Processes
    • Post-installation: After The Processes Complete
  • Appendix B: Database Scripts For Validations
  • Copyright