Primavera Data Warehouse collects and stores data from P6 EPPM and Primavera Unifier. It contains a process called STARETL, which is the mechanism by which data is extracted, transformed, and loaded (ETL) from a P6 EPPM and/or Primavera Unifier database into Primavera Data Warehouse. Primavera Data Warehouse also supports Oracle Data Integrator (ODI) for P6 EPPM and Unifier sources only. ODI allows for near real-time migration of data. Primavera Data Warehouse accumulates data over time with each run of the STARETL process.
Primavera Data Warehouse separates data into facts and dimensions. Fact tables contain business facts or measures (for example: Actual Total Cost, Workflow Duration, and so on). Dimension tables contain descriptive attributes or fields (for example: Activity Name, Cost Breakdown Structure, and so on). As the Primavera Data Warehouse schema accumulates project and cash flow data, it provides baselines for tracking trends and for advanced business intelligence. It also provides key metrics on current data, which allow you to drill through root cause analysis.
You can connect Primavera Data Warehouse to Oracle Business Intelligence (OBI) using Primavera Analytics.