Primavera Data Warehouse is a data repository that collects and stores data from the following products:
- P6 EPPM
- Primavera Unifier
It contains a process called STARETL to extract, transform, and load (ETL) data from the above applications into Primavera Data Warehouse.
Primavera Data Warehouse separates the data into:
- Facts
Fact tables contain business facts or measures. For example: Actual Total Cost, Workflow Duration.
- Dimensions
Dimension tables contain descriptive attributes or fields. For example: Activity Name, Cost Breakdown Structure.
As Primavera Data Warehouse 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.
To analyze and render the data stored in Primavera Data Warehouse as report and dashboards, connect Primavera Data Warehouse to Oracle Business Intelligence (OBI) using Primavera Analytics. For more details on installing OBI and Primavera Analytics, refer to the respective installation guides.