Project Performance Measurement
Number of Canvases: 6
Default Canvas: Overview
Canvas/Dashboard Name: Project Performance Measurement
Data Sources: P6 EPPM, Unifier
Subject Areas: P6-Activity, Unifier- Cost Sheet, Unifier – Cash Flow, P6 – Project History, Unifier – Business Process
Datasets: Not applicable.
Figure 6-2 Project Performance Measurement - Overview Dashboard
Figure 6-3 Project Performance Measurement - Cost
Figure 6-4 Project Performance Measurement - Earned Quantity
Figure 6-5 Project Performance Measurement - Earned Duration
Figure 6-6 Project Performance Measurement - Changed Orders
Figure 6-7 Project Performance Measurement - Activity Details
The following components have been used to create this data visualization.
Table 87: Project Performance Measurement - Dimensions Table
| Canvas | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|
| Overview | Status | Unifier - Business Process |
| Overview | Business Process Name | Unifier - Business Process |
| Overview | Project Name | P6 - Activity |
| Overview | Link to Project | P6 - Activity |
Table 88: Project Performance Measurement - Measures Table
| Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
| Cost | Initial Baseline | Fact | Unifier - Cash Flow |
| Cost | Current Baseline | Fact | Unifier - Cash Flow |
| Cost | Actuals | Fact | Unifier - Cash Flow |
| Cost | Forecast | Fact | Unifier - Cash Flow |
| Cost | Period Cost - Original Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Revised Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Actual Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Forecast | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - EAC | Calculated From Fact | Unifier - Cash Flow / P6 - Activity |
| Cost | Cumulative Cost - Original Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Revised Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Actual Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Forecast Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - EAC | Calculated From Fact | Unifier - Cash Flow / P6 - Activity |
| Cost | Period Cost - Actual Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Original Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Revised Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Forecast Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - EAC | Calculated From Fact | Unifier - Cash Flow / P6 - Activity |
| Cost | Cumulative Cost - Original Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Revised Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Actual Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Forecast Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - EAC | Calculated From Fact | Unifier - Cash Flow / P6 - Activity |
| Cost | Period Cost - Original Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Revised Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Actual Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Forecast | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Original Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Revised Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Actual | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Forecast | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cost - Estimate at Completion (EAC) | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cost - Estimate to Completion (ETC) | Calculated From Fact | Unifier - Cash Flow / P6 - Activity |
| Cost | Cost - EAC % Revised Budget | Calculated From Fact | Unifier - Cash Flow / P6 - Activity |
| Cost | Cost - Variance at Completion (VAC) | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Actual Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Original Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Revised Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Period Cost - Forecast | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Original Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Revised Budget | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Actual | Calculated From Fact | Unifier - Cash Flow |
| Cost | Cumulative Cost - Forecast | Calculated From Fact | Unifier - Cash Flow |
| Change Orders | Change Order count | Calculated From Fact | Unifier - Business Process |
| Change Orders | Forecast | Fact | Unifier - Cash Flow |
| Change Orders | Revised Budget | Fact | Unifier - Cash Flow |
| Change Orders | Original Budget | Fact | Unifier - Cash Flow |
| Change Orders | Revised Budget | Fact | Unifier - Cash Flow |
| Change Orders | Forecast | Fact | Unifier - Cash Flow |
| Change Orders | Amount | Fact | Unifier - Business Process |
| Change Orders | Pending change order | Calculated From Fact | Unifier - Business Process |
| Change Orders | Amount | Fact | Unifier - Business Process |
| Activity Details | Earned Duration | Calculated From Fact | P6 - Activity |
| Activity Details | Estimated Duration at Completion | Calculated From Fact | P6 - Activity |
| Activity Details | Estimated Days Late / (Early) | Calculated From Fact | P6 - Activity |
| Activity Details | SPI (Qty) | Calculated From Fact | P6 - Activity |
| Activity Details | CPI (Qty) | Calculated From Fact | P6 - Activity |
| Activity Details | Planned Quantity | Calculated From Fact | P6 - Activity |
| Activity Details | Earned Quantity | Calculated From Fact | P6 - Activity |
| Activity Details | Schedule Variance (Qty) | Calculated From Fact | P6 - Activity |
| Activity Details | Actual Quantity | Calculated From Fact | P6 - Activity |
| Activity Details | Cost Variance (Qty) | Calculated From Fact | P6 - Activity |
| Activity Details | ETC (Qty) | Calculated From Fact | P6 - Activity |
| Activity Details | BAC (Qty) | Calculated From Fact | P6 - Activity |
| Activity Details | EAC (Qty) | Calculated From Fact | P6 - Activity |
| Activity Details | Variance At Completion (Qty) | Calculated From Fact | P6 - Activity |
| Earned Duration | Planned Earned Quantity | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned quantity | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned Duration. | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned Duration - Earned duration | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned Duration - Actual Duration | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned Duration - Budget at Completion (BAC) | Calculated From Fact | P6 - Activity |
| Earned Duration | Day Count | Calculated From Fact | P6 - Activity |
| Earned Duration | Planned Earned Quantity | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned quantity | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned duration | Calculated From Fact | P6 - Activity |
| Earned Duration | Duration Performance Index (DPI) | Calculated From Fact | P6 - Activity |
| Earned Duration | Duration Variance (DV) | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned Duration - Estimate at Completion (EAC) | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned Duration - Variance at Completion (VAC) | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned Duration - Estimate to Complete (ETC) | Calculated From Fact | P6 - Activity |
| Earned Duration | Earned Duration - EAC % BAC | Calculated From Fact | P6 - Activity |
| Overview | Revised Budget | Fact | Unifier - Cost Sheet |
| Overview | Actual Cost | Calculated From Fact | Unifier - Cost Sheet |
| Overview | Forecast | Fact | Unifier - Cost Sheet |
| Overview | Original Budget | Fact | Unifier - Cost Sheet |
| Overview | Revised Budget | Fact | Unifier - Cost Sheet |
| Overview | Actual Cost | Calculated From Fact | Unifier - Cost Sheet |
| Overview | Forecast | Fact | Unifier - Cost Sheet |
| Overview | Cost EAC | Calculated From Fact | Unifier - Cost Sheet |
| Overview | Cost EAC | Calculated From Fact | Unifier - Cost Sheet |
| Overview | EAC % Revised Budget | Calculated From Fact | P6 - Activity / P6 - Activity |
| Overview | Forecast % Revised Budget | Calculated From Fact | Unifier - Cost Sheet |
| Overview | Planned Quantity | Calculated From Fact | P6 - Activity |
| Overview | Actual Quantity | Calculated From Fact | P6 - Activity |
| Overview | Earned Quantity | Calculated From Fact | P6 - Activity |
| Overview | Earned Quantity - Estimate at completion (EAC) | Calculated From Fact | P6 - Activity |
| Overview | Cost Performance Index (Units) | Fact | P6 - Activity |
| Overview | Earned Quantity - EAC % BAC | Calculated From Fact | P6 - Activity |
| Overview | Earned Duration - Budget at Completion (BAC) | Calculated From Fact | P6 - Activity |
| Overview | Earned Duration - Actual Duration | Calculated From Fact | P6 - Activity |
| Overview | Earned Duration - Earned duration | Calculated From Fact | P6 - Activity |
| Overview | Duration Performance Index (DPI) | Calculated From Fact | P6 - Activity |
| Overview | Earned Duration - EAC % BAC | Calculated From Fact | P6 - Activity |
| Overview | Earned Duration - Estimate at Completion (EAC) | Calculated From Fact | P6 - Activity |
| Overview | Original Budget | Fact | Unifier - Cost Sheet |
| Overview | Amount | Fact | Unifier - Business Process |
| Overview | Pending change order | Calculated From Fact | Unifier - Business Process |
| Overview | Change Order count | Calculated From Fact | Unifier - Business Process |
| Overview | Planned Quantity | Calculated From Fact | P6 - Activity |
| Overview | Actual Quantity | Calculated From Fact | P6 - Activity |
| Overview | Earned Quantity | Calculated From Fact | P6 - Activity |
| Overview | Earned Quantity - Estimate at completion (EAC) | Calculated From Fact | P6 - Activity |
| Overview | CPI (Qty) | Calculated From Fact | P6 - Activity |
| Overview | SPI (Qty) | Calculated From Fact | P6 - Activity |
| Earned Quantity | Budget At Completion (Units) | Fact | P6 - Activity |
| Earned Quantity | Cost Variance (Units) | Fact | P6 - Activity |
| Earned Quantity | Schedule Variance (Units) | Fact | P6 - Activity |
| Earned Quantity | Cumulative Planned Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Actual Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Earned Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Quantity - CPI | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Quantity - SPI | Calculated From Fact | P6 - Activity |
| Earned Quantity | Period Planned Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Period Actual Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Period Earned Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Schedule Variance (Units) | Fact | P6 - Activity |
| Earned Quantity | Cost Variance (Units) | Fact | P6 - Activity |
| Earned Quantity | Schedule Performance Index (Units) | Fact | P6 - Activity |
| Earned Quantity | Cost Performance Index (Units) | Fact | P6 - Activity |
| Earned Quantity | Cumulative Planned Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Actual Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Earned Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Quantity - SV | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Quantity - CV | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Quantity - SPI | Calculated From Fact | P6 - Activity |
| Earned Quantity | Cumulative Quantity - CPI | Calculated From Fact | P6 - Activity |
| Earned Quantity | Schedule Variance (Units) | Fact | P6 - Activity |
| Earned Quantity | Cost Variance (Units) | Fact | P6 - Activity |
| Earned Quantity | Schedule Performance Index (Units) | Fact | P6 - Activity |
| Earned Quantity | Cost Performance Index (Units) | Fact | P6 - Activity |
| Earned Quantity | Earned Quantity - Estimate at completion (EAC) | Calculated From Fact | P6 - Activity |
| Earned Quantity | Earned Quantity - Variance at Completion (VAC) | Calculated From Fact | P6 - Activity |
| Earned Quantity | Earned Quantity - Estimate to Complete (ETC) | Calculated From Fact | P6 - Activity |
| Earned Quantity | Earned Quantity - EAC % BAC | Calculated From Fact | P6 - Activity |
| Earned Quantity | Planned Earned Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Actual Quantity | Calculated From Fact | P6 - Activity |
| Earned Quantity | Earned Quantity | Calculated From Fact | P6 - Activity |
Table 89: Project Performance Measurement - Filters Table
| Canvas | Filter Type | Is Expression Filter | Filter | Subject Area / Dataset |
|---|---|---|---|---|
| Overview | Visualization | No | Business Process Name | Unifier - Business Process |
| Overview | Visualization | Yes | Cost Performance Index (Units) is not null and Schedule Performance | P6 - Activity |
| All Canvas | Dashboard | No | Project Name | P6 - Activity |
| Overview | Visualization | No | Calendar Day Date | P6 - Activity |
| Change Order | Visualization | No | Business Process Name | Unifier - Business Process |
| Change Order | Visualization | No | Business Process Name | Unifier - Business Process |
| Change Order | Visualization | No | Business Process Name | Unifier - Business Process |
Table 90: Project Performance Measurement - Data Actions Table
| Data Action Name | Action Type | Anchor To | Target | Canvas Link | Pass Values | Multiselection |
|---|---|---|---|---|---|---|
| Navigate to Change Orders | Analytics Link | Status | This Project | Change Orders | All | On |
| Navigate to Activity Details | Analytics link | Project Name | This Project | Activity Details | All | On |
Table 91: Project Performance Measurement - Calculated Members Table
| Calculated Measure | Expression | Source |
|---|---|---|
| Estimate at Completion (EAC) |
Primavera - Cost Sheet."Costs"."Revised Budget"/ "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)"
|
Derived From Fact |
| Actual Cost |
Primavera - Cost Sheet."Costs"."User Defined Column 1"
|
Derived From Fact |
| Forecast % Revised Budget |
Primavera - Cost Sheet."Costs"."Forecast"/"Primavera - Cost Sheet"."Costs"."Revised Budget"
|
Derived From Fact |
| EAC % Revised Budget |
("Primavera - Cost Sheet"."Costs"."Revised Budget"/ "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)")/"Primavera - Cost Sheet"."Costs"."Revised Budget"
|
Derived From Fact |
| SPI (Qty) |
Primavera - Activity."Earned Value - (Units)"."Schedule Performance Index (Units)"
|
Derived From Fact |
| CPI (Qty) |
Primavera - Activity."Earned Value - (Units)"."Cost Performance Index (Units)"
|
Derived From Fact |
| Planned Quantity |
Primavera - Activity."Earned Value - (Units)"."Planned Value (Units)"
|
Derived From Fact |
| Earned Quantity |
Primavera - Activity."Earned Value - (Units)"."Earned Value (Units)"
|
Derived From Fact |
| Actual Quantity |
Primavera - Activity."Units"."Actual Labor Units"
|
Derived From Fact |
| ETC (Qty) |
Primavera - Activity."Earned Value - (Units)"."Estimate To Complete (Units)"
|
Derived From Fact |
| Cost Variance (Qty) |
Primavera - Activity."Earned Value - (Units)"."Cost Variance (Units)"
|
Derived From Fact |
| Schedule Variance (Qty) |
Primavera - Activity."Earned Value - (Units)"."Schedule Variance (Units)"
|
Derived From Fact |
| BAC (Qty) |
Primavera - Activity."Units"."Planned Labor Units"
|
Derived From Fact |
| EAC (Qty) |
Primavera - Activity."Earned Value - (Units)"."Estimate At Completion (Units)"
|
Derived From Fact |
| Variance At Completion (Qty) |
Primavera - Activity."Earned Value - (Units)"."Variance at Completion (Units)"
|
Derived From Fact |
| Earned Duration |
Primavera - Activity."Earned Value - (Units)"."Schedule Performance Index (Units)" * "Primavera - Activity"."Durations - (Activity)"."Actual Duration"
|
Derived From Fact |
| Estimated Duration at Completion |
Case when "Primavera - Activity"."Durations - (Activity)"."Actual Duration" > "Primavera - Activity"."Durations - (Activity)"."Baseline Duration" then "Primavera - Activity"."Durations - (Activity)"."Actual Duration" + ("Primavera - Activity"."Durations - (Activity)"."Actual Duration" - "Primavera - Activity"."Earned Value - (Units)"."Schedule Performance Index (Units)" * "Primavera - Activity"."Durations - (Activity)"."Actual Duration")/"Primavera - Activity"."Earned Value - (Units)"."Schedule Performance Index (Units)"ELSE "Primavera - Activity"."Durations - (Activity)"."Actual Duration" + ("Primavera - Activity"."Durations - (Activity)"."Baseline Duration" - "Primavera - Activity"."Earned Value - (Units)"."Schedule Performance Index (Units)"*"Primavera - Activity"."Durations - (Activity)"."Actual Duration")/"Primavera - Activity"."Earned Value - (Units)"."Schedule Performance Index (Units)"END
|
Derived From Fact |
| Estimated Days Late / (Early) |
Case when "Primavera - Activity"."Durations - (Activity)"."Actual Duration" > "Primavera - Activity"."Durations - (Activity)"."Baseline Duration" then "Primavera - Activity"."Durations - (Activity)"."Actual Duration" + ("Primavera - Activity"."Durations - (Activity)"."Actual Duration" - "Primavera - Activity"."Earned Value - (Units)"."Schedule Performance Index (Units)" * "Primavera - Activity"."Durations - (Activity)"."Actual Duration")/"Primavera - Activity"."Earned Value - (Units)"."Schedule Performance Index (Units)"ELSE "Primavera - Activity"."Durations - (Activity)"."Actual Duration" + ("Primavera - Activity"."Durations - (Activity)"."Baseline Duration" - "Primavera - Activity"."Earned Value - (Units)"."Schedule Performance Index (Units)"*"Primavera - Activity"."Durations - (Activity)"."Actual Duration")/"Primavera - Activity"."Earned Value - (Units)"."Schedule Performance Index (Units)"END - "Primavera - Activity"."Durations - (Activity)"."Baseline Duration"
|
Derived From Fact |
| Cost Variance (Qty) - Conditional |
case when "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)"< 1 then "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)"when "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)"<0.95 then "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)"else null end
|
Derived From Fact |
| Pending change order |
CASE WHEN "Primavera - Business Process"."General - (BP)"."Status" = 'In_Process' THEN "Primavera - Business Process"."Costs"."Amount" ELSE 0 END
|
Derived From Fact |
| Change Order count |
Primavera - Business Process."Metrics"."# of BP Records"
|
Derived From Fact |
| Revised Budget % Original |
Primavera - Cost Sheet."Costs"."Revised Budget"/"Primavera - Cost Sheet"."Costs"."Original Budget"
|
Derived From Fact |
| Day Count |
RCOUNT("Primavera - Activity"."Units"."Planned Labor Units")
|
Derived From Fact |
| Duration Performance Index (DPI) |
CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST( RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 AS FLOAT ) ELSE NULL END ) ELSE MIN( CASE WHEN RSUM("Primavera - Activity"."Units"."Planned Labor Units") > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST( RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) - 1 AS FLOAT ) ELSE NULL END ) END / MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE NULL END )
|
Derived From Fact |
| Duration Variance (DV) |
- CAST(MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT(IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0)) ELSE NULL END ) + CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM("Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)") THEN RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" , 0)) - 1 ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units") > SUM("Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)") THEN RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) -1 ELSE NULL END ) END as INT)
|
Derived From Fact |
| Earned Duration - Estimate at Completion (EAC) |
MAX( RCOUNT("Primavera - Activity"."Units"."Planned Labor Units" ) ) / ( CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 AS FLOAT) ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) - 1 AS FLOAT) ELSE NULL END ) END / MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE NULL END ) )
|
Derived From Fact |
| Earned Duration - EAC % BAC |
MAX( RCOUNT("Primavera - Activity"."Units"."Planned Labor Units" ) ) / ( CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 AS FLOAT) ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) - 1 AS FLOAT) ELSE NULL END ) END / MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE NULL END ) ) / MAX( RCOUNT("Primavera - Activity"."Units"."Planned Labor Units" ) )
|
Derived From Fact |
| Planned Earned Quantity |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE RSUM("Primavera - Activity"."Units"."Planned Labor Units") END
|
Derived From Fact |
| Earned quantity |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM("Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)") ELSE NULL END
|
Derived From Fact |
| Earned Duration - Earned duration |
CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) - 1 ELSE NULL END ) END
|
Derived From Fact |
| Earned Duration - Budget at Completion (BAC) |
MAX((RCOUNT("Primavera - Activity"."Units"."Planned Labor Units")) )
|
Derived From Fact |
| Earned Duration - Actual Duration |
MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE NULL END )
|
Derived From Fact |
| Earned Duration. |
CASE WHEN CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) -1 ELSE NULL END ) END >= RCOUNT("Primavera - Activity"."Units"."Planned Labor Units") THEN SUM("Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)") ELSE NULL END
|
Derived From Fact |
| Earned duration |
CASE WHEN CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) -1 ELSE NULL END ) END = RCOUNT("Primavera - Activity"."Units"."Planned Labor Units") THEN RCOUNT("Primavera - Activity"."Units"."Planned Labor Units") ELSE NULL END
|
Derived From Fact |
| Earned Duration - Variance at Completion (VAC) |
MAX( RCOUNT("Primavera - Activity"."Units"."Planned Labor Units" ) ) - MAX( RCOUNT("Primavera - Activity"."Units"."Planned Labor Units" ) ) / ( CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 AS FLOAT) ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) - 1 AS FLOAT) ELSE NULL END ) END / MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE NULL END )
|
Derived From Fact |
| Earned Duration - Estimate to Complete (ETC) |
MAX( RCOUNT("Primavera - Activity"."Units"."Planned Labor Units" ) ) / ( CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 AS FLOAT) ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) - 1 AS FLOAT) ELSE NULL END ) END / MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE NULL END ) ) - MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE NULL END )
|
Derived From Fact |
| Cumulative Quantity - SPI |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) ELSE NULL END / CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE RSUM("Primavera - Activity"."Units"."Planned Labor Units") END
|
Derived From Fact |
| Cumulative Quantity - CPI |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) ELSE NULL END / CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM("Primavera - Activity"."Units"."Actual Labor Units") ELSE NULL END
|
Derived From Fact |
| Period Planned Quantity |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ELSE "Primavera - Activity"."Units"."Planned Labor Units" END
|
Derived From Fact |
| Period Actual Quantity |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN "Primavera - Activity"."Units"."Actual Labor Units" ELSE NULL END
|
Derived From Fact |
| Period Earned Quantity |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ELSE NULL END
|
Derived From Fact |
| Cumulative Planned Quantity |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE RSUM("Primavera - Activity"."Units"."Planned Labor Units") END
|
Derived From Fact |
| Cumulative Actual Quantity |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM("Primavera - Activity"."Units"."Actual Labor Units") ELSE NULL END
|
Derived From Fact |
| Cumulative Earned Quantity |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) ELSE NULL END
|
Derived From Fact |
| Cumulative Quantity - SV |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM("Primavera - Activity"."Earned Value - (Units)"."Schedule Variance (Units)") ELSE NULL END
|
Derived From Fact |
| Cumulative Quantity - CV |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RSUM("Primavera - Activity"."Earned Value - (Units)"."Cost Variance (Units)") ELSE NULL END
|
Derived From Fact |
| Earned Quantity - Estimate at completion (EAC) |
Primavera - Activity."Units"."Planned Labor Units" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)"
|
Derived From Fact |
| Earned Quantity - Variance at Completion (VAC) |
Primavera - Activity."Units"."Planned Labor Units" - ("Primavera - Activity"."Units"."Planned Labor Units" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)")
|
Derived From Fact |
| Earned Quantity - Estimate to Complete (ETC) |
("Primavera - Activity"."Units"."Planned Labor Units" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)") - "Primavera - Activity"."Units"."Actual Labor Units"
|
Derived From Fact |
| Earned Quantity - EAC % BAC |
("Primavera - Activity"."Units"."Planned Labor Units" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)")/"Primavera - Activity"."Earned Value - (Units)"."Budget At Completion (Units)"
|
Derived From Fact |
| Period Cost - Original Budget |
Primavera - Cash Flow."Costs"."Initial Baseline"
|
Derived From Fact |
| Period Cost - Revised Budget |
Primavera - Cash Flow."Costs"."Current Baseline"
|
Derived From Fact |
| Period Cost - Forecast |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH, "Primavera - Cash Flow"."Calendar"."Calendar Date", CURRENT_DATE) < 1 THEN "Primavera - Cash Flow"."Costs"."Forecast" ELSE NULL END
|
Derived From Fact |
| Period Cost - EAC |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH, "Primavera - Cash Flow"."Calendar"."Calendar Date", CURRENT_DATE) < 1 THEN "Primavera - Cash Flow"."Costs"."Current Baseline" ELSE NULL END / ( SUM(CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH, "Primavera - Cash Flow"."Calendar"."Calendar Date", CURRENT_DATE) < 1 THEN "Primavera - Cash Flow"."Costs"."Current Baseline" ELSE NULL END ) / ( ( SUM("Primavera - Cash Flow"."Costs"."Current Baseline") / (SUM("Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)") / SUM("Primavera - Activity"."Units"."Actual Labor Units")) ) - SUM("Primavera - Cash Flow"."Costs"."Actuals") ) )
|
Derived From Fact |
| Period Cost - Actual Budget |
Primavera - Cash Flow."Costs"."Actuals"
|
Derived From Fact |
| Cumulative Cost - Original Budget |
RSUM("Primavera - Cash Flow"."Costs"."Initial Baseline")
|
Derived From Fact |
| Cumulative Cost - Revised Budget |
RSUM("Primavera - Cash Flow"."Costs"."Current Baseline")
|
Derived From Fact |
| Cumulative Cost - Actual |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH, "Primavera - Cash Flow"."Calendar"."Calendar Date", CURRENT_DATE) > 0 THEN RSUM("Primavera - Cash Flow"."Costs"."Actuals") ELSE NULL END
|
Derived From Fact |
| Cumulative Cost - Forecast |
RSUM("Primavera - Cash Flow"."Costs"."Forecast")
|
Derived From Fact |
| Cumulative Cost - EAC |
RSUM( CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH, "Primavera - Cash Flow"."Calendar"."Calendar Date", CURRENT_DATE) < 1 THEN "Primavera - Cash Flow"."Costs"."Current Baseline" / ( SUM(CASE WHEN TIMESTAMPDIFF(SQL_TSI_MONTH, "Primavera - Cash Flow"."Calendar"."Calendar Date", CURRENT_DATE) < 1 THEN "Primavera - Cash Flow"."Costs"."Current Baseline" ELSE NULL END ) / ( ( SUM("Primavera - Cash Flow"."Costs"."Current Baseline") / (SUM("Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)") / SUM("Primavera - Activity"."Units"."Actual Labor Units")) ) - SUM("Primavera - Cash Flow"."Costs"."Actuals") ) ) ELSE "Primavera - Cash Flow"."Costs"."Actuals" END )
|
Derived From Fact |
| Cost - Estimate at Completion (EAC) |
Primavera - Cash Flow."Costs"."Current Baseline" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)"
|
Derived From Fact |
| Cost - Estimate to Completion (ETC) |
("Primavera - Cash Flow"."Costs"."Current Baseline" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)") - "Primavera - Cash Flow"."Costs"."Actuals"
|
Derived From Fact |
| Cost - EAC % Revised Budget |
("Primavera - Cash Flow"."Costs"."Current Baseline" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)") / "Primavera - Cash Flow"."Costs"."Current Baseline"
|
Derived From Fact |
| Cost - Variance at Completion (VAC) |
Primavera - Cash Flow."Costs"."Current Baseline" - ("Primavera - Cash Flow"."Costs"."Current Baseline" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)")
|
Derived From Fact |
| Approved Change Orders |
CASE WHEN "Primavera - Business Process"."General - (BP)"."Status" = 'Approved' THEN "Primavera - Business Process"."Costs"."Amount" WHEN "Primavera - Business Process"."General - (BP)"."Status" = 'Approved_Scheduled' THEN "Primavera - Business Process"."Costs"."Amount" ELSE 0 END
|
Derived From Fact |
| Cost EAC |
Primavera - Cost Sheet."Costs"."Revised Budget" / "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)"
|
Derived From Fact |
| Forecast % Revised Budget Copy |
Primavera - Cost Sheet."Costs"."Forecast"/"Primavera - Cost Sheet"."Costs"."Revised Budget"*100
|
Derived From Fact |
| EAC % Revised Budget Copy |
("Primavera - Cost Sheet"."Costs"."Revised Budget"/ "Primavera - Activity"."Earned Value - (Units)"."Cost Performance Index (Units)")/"Primavera - Cost Sheet"."Costs"."Revised Budget"*100
|
Derived From Fact |
| Earned Duration - EAC % BAC Copy |
MAX( RCOUNT("Primavera - Activity"."Units"."Planned Labor Units" ) ) / ( CASE WHEN SUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) >= SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN MIN( CASE WHEN RSUM( "Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT( IFNULL("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)", 0) ) - 1 AS FLOAT) ELSE NULL END ) ELSE MIN( CASE WHEN RSUM( "Primavera - Activity"."Units"."Planned Labor Units" ) > SUM( "Primavera - Activity"."Earned Value - (Units)"."Earned Value (Units)" ) THEN CAST(RCOUNT(IFNULL("Primavera - Activity"."Units"."Planned Labor Units", 0) ) - 1 AS FLOAT) ELSE NULL END ) END / MAX(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Activity"."Calendar"."Calendar Date", "Primavera - Activity"."Dates - (Project)"."Data Date") >= 0 THEN RCOUNT("Primavera - Activity"."Earned Value - (Units)"."Planned Value (Units)") ELSE NULL END ) ) / MAX( RCOUNT("Primavera - Activity"."Units"."Planned Labor Units" ) )
|
Derived From Fact |