Integrated Schedule Delivery KPI Dashboard
Number of Canvases: 1
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
Figure 4-7 Integrated Schedule KPI Dashboard
Table 19: Integrated Schedule Delivery KPI - 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 |