About Primavera Data Warehouse
In addition to the native enterprise reporting available now with P6 EPPM, the Primavera Data Warehouse provides a powerful data warehouse solution.
The Primavera Data Warehouse can 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 Primavera Unifier database into the Primavera Data Warehouse. The Primavera Data Warehouse accumulates data over time with each run of the STARETL process.
The 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 the Primavera Data Warehouse to Oracle Business Intelligence (OBI) using Analytics.
Last Published Thursday, February 1, 2024