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 57: Project Performance Measurement - Overview Dashboard
Figure 58: Project Performance Measurement - Cost
Figure 59: Project Performance Measurement - Earned Quantity
Figure 60: Project Performance Measurement - Earned Duration
Figure 61: Project Performance Measurement - Changed Orders
Figure 62: 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 |
Related Topics
Data Visualizations Using Blended Data
Last Published Friday, December 8, 2023