About Primavera Data Warehouse
Primavera Data Warehouse is a data repository that collects and stores data from the following products:
- P6 EPPM
- Primavera Unifier
- Oracle Primavera Cloud
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 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.
Last Published Thursday, December 14, 2023