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.

Project Performance Measurement Overview

Figure 57: Project Performance Measurement - Overview Dashboard

Project Performance Measurement Cost

Figure 58: Project Performance Measurement - Cost

Project Performance Measurement - Earned Quantity

Figure 59: Project Performance Measurement - Earned Quantity

Project Performance Measurement - Earned Duration

Figure 60: Project Performance Measurement - Earned Duration

Project Performance Measurement - Changed Orders

Figure 61: Project Performance Measurement - Changed Orders

Project Performance Measurement - Activity Details

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

Cost Overview Project



Last Published Friday, December 8, 2023