Shutdown / Turnaround / Outage Dashboard
Description: Asset intensive organizations (utilities) can leverage this dashboard to track activities scheduled, performed, resources assigned, etc. in a very granular format during shutdown, turnaround, outage periods.
Number of Canvases: 2
Default Canvas: By Resource (Dropdown)
Canvas/Dashboard Name: Shutdown/Turnaround/Outage
Data Source(s): P6 - EPPM
Subject Area: P6 – Activity
Datasets: Not applicable
Dashboards
Table 27: Shutdown / Turnaround / Outage - Dimensions
| Canvas | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|
| All Canvas | Calendar Date | P6 – Burn Down |
| All Canvas | Activity > Finish | P6 – Burn Down |
| All Canvas | Primary Resource | P6 – Burn Down |
| All Canvas | Project > Workdown Date | P6 – Burn Down |
Table 28: Shutdown / Turnaround / Outage – Measures
| Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
| All Canvas | Emergent Remaining Units Burn | Fact | P6 – Burn down |
Table 29: Shutdown / Turnaround / Outage – Filters
| Canvas | Filter Type | Is Expression Filter | Dimension / Attribute / Measure | Subject Area / Dataset |
|---|---|---|---|---|
| All Canvas | Dashboard | No | Project Name | P6 – Burn down |
| All Canvas | Dashboard | No | Primary Resource | P6 – Burn down |
| All Canvas | Dashboard | No | Week Name | P6 – Burn down |
| All Canvas | Visual | Yes | CASE WHEN "Primavera - Burn Down"."Dates - (Activity)"."Finish" > "Primavera - Burn Down"."Dates - (Project)"."Workdown Date" THEN 1 ELSE 0 END = 1 | P6 – Burn down |
Table 30: Shutdown / Turnaround / Outage – Calculated Members
| Calculated Member | Expression | Source | Subject Area / Dataset |
|---|---|---|---|
| Original Remaining (hours) |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Non-Emergent Remaining Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND "Primavera - Burn Down"."Metrics"."New Record Count" = 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE 0 END ELSE NULL END
|
Derived From Fact | P6 - Burn Down |
| Emergent Remaining (hours) |
CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Emergent Remaining Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND "Primavera - Burn Down"."Metrics"."New Record Count" > 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE 0 END ELSE NULL END
|
Derived From Fact | P6 – Burn down |
| Original and Emergent Remaining (hours) | (CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Non-Emergent Remaining Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND "Primavera - Burn Down"."Metrics"."New Record Count" = 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE 0 END ELSE NULL END)+ (CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Emergent Remaining Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND "Primavera - Burn Down"."Metrics"."New Record Count" > 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE 0 END ELSE NULL END) | Derived From Fact | P6 – Burn down |
| Baseline Work Down | "Primavera - Burn Down"."Units"."Baseline Units Burn" | P6 – Burn down | |
| Total Man Hours | CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Remaining Units Burn" + "Primavera - Burn Down"."Units"."Actual Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY,"Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND HOUR("Primavera - Burn Down"."Dates - (Project)"."Data Date") <> 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE ("Primavera - Burn Down"."Units"."Actual Period Units" - "Primavera - Burn Down"."Units"."Actual Units") END ELSE NULL END | P6 – Burn down | |
| Current Work Down | CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") <= 0 THEN "Primavera - Burn Down"."Units"."Remaining Units Burn" ELSE NULL END | Derived From Fact | P6 – Burn down |
| Original Remaining (count) | CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Metrics"."Non-Emergent Remaining Count" ELSE NULL END | Derived From Fact | P6 – Burn down |
| Emergent Remaining (count) | CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Metrics"."Emergent Remaining Count" ELSE NULL END | Derived From Fact | P6 – Burn down |
| Original and Emergent Remaining (count) | (CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Metrics"."Non-Emergent Remaining Count" ELSE NULL END)+(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Metrics"."Emergent Remaining Count" ELSE NULL END) | Derived From Fact | P6 – Burn down |
| Baseline Work Down (count) | "Primavera - Burn Down"."Metrics"."Baseline Not Started Count" + "Primavera - Burn Down"."Metrics"."Baseline In Progress Count" | Derived From Fact | P6 – Burn down |
| Current Work Down (count) | SUM(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") <= 0 THEN CASE WHEN TIMESTAMPDIFF(SQL_TSI_MINUTE,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Activity)"."Planned Finish") > 1440 AND "Primavera - Burn Down"."General - (Activity)"."Activity Status" <> 'Completed' THEN 1 ELSE 0 END ELSE NULL END) | Derived From Fact | P6 – Burn down |
| Total # of Activities | SUM(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN 1 ELSE NULL END) | Derived From Fact | P6 – Burn down |
| Original Schedule and Completed | "Primavera - Burn Down"."Metrics"."Scheduled and Completed Count" | Derived From Fact | P6 – Burn down |
| Original Schedule and Not Completed | "Primavera - Burn Down"."Metrics"."Scheduled and Not Completed Count" | Derived From Fact | P6 – Burn down |
| Emergent and Completed | "Primavera - Burn Down"."Metrics"."Not Scheduled and Completed Count" | Derived From Fact | P6 – Burn down |
| Total Scheduled | "Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"+"Primavera - Burn Down"."Metrics"."Scheduled and Not Completed Count" | Derived From Fact | P6 – Burn down |
| Original Schedule Compliance % | CASE WHEN ("Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"/("Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"+"Primavera - Burn Down"."Metrics"."Scheduled and Not Completed Count")) IS NULL THEN 0 ELSE ("Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"/("Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"+"Primavera - Burn Down"."Metrics"."Scheduled and Not Completed Count")) END | Derived From Fact | P6 – Burn down |