Integrated Schedule Delivery KPI Dashboard

Number of Canvases: 7

Default Canvas: IB_ActivityHistoryData

Canvas/Dashboard Name: Integrated Schedule Delivery KPI

Data Source(s): P6 - EPPM

Subject Area: P6 – Activity History

Datasets: Not applicable

Dashboard

Canvases

Integrated Schedule- Activity History Data

Figure 10: IB_ActivityHistoryData

Activities Details of the Integrated Schedule Delivery KPI Dashboard

Figure 11: Activity Details

Integrated Schedule Delivery KPI Dashboard Activities Executed Per Baseline Plan Details

Figure 12: Activities Executed As Per Baseline Plan Details

Integrated Schedule Delivery KPI Dashboard - Activities Brought Forward Details

Figure 13: Activities Brought Forward Details

Integrated Schedule Delivery KPI Dashboard-Delayed Activities Details

Figure 14: Delayed Activities Details

Table 19: Key Milestones Tracking- Dimensions

Canvas

Dimension Name

Dimension / Attribute

Subject Area / Dataset

IB_ActivityHistoryData

Project

Project Id

P6 – Activity History

IB_ActivityHistoryData

Project

Project Name

P6 – Activity History

ALL Canvas

Project

WBS

P6 – Activity History

Details Canvases

Activity

Activity ID

P6 – Activity History

Details Canvases

Activity

Activity Name

P6 – Activity History

Details Canvases

Activity

Primary Resource

P6 – Activity History

Details Canvases

Activity

Planned Start

P6 – Activity History

Details Canvases

Activity

Planned Finish

P6 – Activity History

Table 20: Integrated Schedule Delivery KPI – Measures

Canvas

Fact / Measure

Measure Type

Subject Area / Dataset

IB_ActivityHistoryData

# of Activities

Calculated from Fact

P6 – Activity History

IB_ActivityHistoryData

Activities Executed as per Plan

Calculated from Fact

P6 – Activity History

IB_ActivityHistoryData

Activities brought forward

Calculated from Fact

P6 – Activity History

IB_ActivityHistoryData

Activities Delayed

Calculated from Fact

P6 – Activity History

IB_ActivityHistoryData

New Activities

Calculated from Fact

P6 – Activity History

IB_ActivityHistoryData

Activities Canceled

Calculated from Fact

P6 – Activity History

IB_ActivityHistoryData

Formula %

Calculated from Fact

P6 – Activity History

Table 21: Integrated Schedule Delivery KPI – Filters

Canvas

Filter Type

Is Expression Filter

Dimension / Attribute / Measure

Subject Area / Dataset

IB_ActivityHistoryData

Dashboard

No

Project Name

 

P6 - Activity History

Activities Details

Visual

Yes

"Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}')

 

P6 - Activity History

Activities Executed As Per Baseline Plan Details

Visual

Yes

"Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') AND CAST("Primavera - Activity History"."Dates - (Activity)"."Actual Finish" AS DATE) = CAST("Primavera - Activity History"."Dates - (Activity)"."Baseline Project Finish" AS DATE)

 

P6 - Activity History

Activities Brought Forward Details

Visual

Yes

MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") < MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id")

 

P6 - Activity History

Activities Brought Forward Details

Visual

Yes

"Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_previousweek}{2015-08-30}') OR "Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_currentweek}{2015-09-06}')

 

P6 - Activity History

Activities Brought Forward Details

Visual

Yes

RANK(MAX(CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_previousweek}{2015-08-30}') OR "Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") = 1

 

P6 - Activity History

Delayed Activities Details

Visual

Yes

MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") > MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id")

 

P6 - Activity History

Delayed Activities Details

Visual

Yes

"Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_previousweek}{2015-08-30}') OR "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}')

 

P6 - Activity History

Delayed Activities Details

Visual

Yes

RANK(MAX(CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_previousweek}{2015-08-30}') OR "Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") = 1

 

P6 - Activity History

New Activities Details

Visual

Yes

CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END NOT IN ((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END))

 

P6 - Activity History

New Activities Details

Visual

Yes

"Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_previousweek}{2015-08-30}') OR "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}')

 

P6 - Activity History

Cancelled Activities Details

Visual

Yes

CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END NOT IN (( CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) )

 

P6 - Activity History

Cancelled Activities Details

Visual

Yes

"Primavera - Activity History"."Calendar"."Week Name" = ('@{pv_previousweek}{2015-08-30}') OR "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}')

 

P6 - Activity History

Table 22: Integrated Schedule Delivery KPI – Calculated Members

Calculated Member

Expression

Source

Subject Area / Dataset

# of Activities

FILTER("Primavera - Activity History"."Metrics"."# of Activities" using "Primavera - Activity History"."Calendar"."Week Name" = '@{pv_currentweek}{2015-09-06}')

 

Derived From Fact

P6 - Activity History

Activities Executed as per Plan

SUM(CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN (CASE WHEN CAST("Primavera - Activity History"."Dates - (Activity)"."Actual Finish" AS DATE) = CAST("Primavera - Activity History"."Dates - (Activity)"."Baseline Project Finish" AS DATE) THEN 1 ELSE 0 END) END)

 

Derived From Fact

P6 - Activity History

Activities brought forward

SUM( CASE WHEN MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") < MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") THEN 1 ELSE 0 END )

 

Derived From Fact

P6 - Activity History

Activities Delayed

SUM( CASE WHEN MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") > MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") THEN 1 ELSE 0 END )

 

Derived From Fact

P6 - Activity History

New Activities

COUNT (CASE WHEN ( CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) NOT IN ((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) ) THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END)

 

Derived From Fact

P6 - Activity History

Activities Canceled

COUNT(CASE WHEN(CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) NOT IN (( CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) ) THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END)

 

Derived From Fact

P6 - Activity History

Formula %

( ( SUM( CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN ( CASE WHEN CAST("Primavera - Activity History"."Dates - (Activity)"."Actual Finish" AS DATE)=CAST("Primavera - Activity History"."Dates - (Activity)"."Baseline Project Finish" AS DATE) THEN 1 ELSE 0 END ) END ) + ( SUM( CASE WHEN MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") < MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") THEN 1 ELSE 0 END ) ) ) / ( ( SUM(CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN ( CASE WHEN CAST("Primavera - Activity History"."Dates - (Activity)"."Actual Finish" AS DATE)=CAST( "Primavera - Activity History"."Dates - (Activity)"."Baseline Project Finish" AS DATE) THEN 1 ELSE 0 END ) END) ) + ( SUM( CASE WHEN MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") < MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") THEN 1 ELSE 0 END ) ) + COUNT( CASE WHEN (CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) NOT IN ((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) ) THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END ) + SUM( CASE WHEN MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") > MAX((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."Dates - (Activity)"."Finish" END) BY "Primavera - Activity History"."General - (Activity)"."Activity Id") THEN 1 ELSE 0 END ) + COUNT( CASE WHEN(CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_previousweek}{2015-08-30}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) NOT IN ((CASE WHEN "Primavera - Activity History"."Calendar"."Week Name" IN ('@{pv_currentweek}{2015-09-06}') THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END) ) THEN "Primavera - Activity History"."General - (Activity)"."Activity Id" END ) ) )

 

Derived From Fact

P6 - Activity History

Related Topics

Data Visualizations Using P6 EPPM Data

Cost Overview Dashboard

Earned Value and Risk Analysis Dashboard

Overview - Portfolio, Risk, EV

Key Milestones Tracking Dashboard

Activity Look Ahead Dashboard

Shutdown / Turnaround / Outage Dashboard

Labor Units History Dashboard

CPI, SPI, and Labor Units Dashboard

Project Risk - Cost Overview Dashboard

Project Health Assessment Dashboard


Last Published Friday, December 8, 2023