Root Cause Analysis Dashboard
Description: .
Number of Canvases: 1
Default Canvas: Root Cause Analysis
Canvas/Dashboard Name: Root Cause Analysis
Data Source(s): Unifier
Subject Area: Unifier - Cost Sheet
Datasets: Not applicable
Dashboard
Figure 41: Root Cause Analysis Dashboard
Table 63: Root Cause Analysis - Dimensions
Canvas | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|
Root Cause Analysis | CBS Name | Unifier - Cost Sheet |
Root Cause Analysis | Project Phase | Unifier - Cost Sheet |
Root Cause Analysis | Project Name | Unifier - Cost Sheet |
Root Cause Analysis | Project Type | Unifier - Cost Sheet |
Root Cause Analysis | Project Hierarchy | Unifier - Cost Sheet |
Table 64: Root Cause Analysis – Measures
Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
Root Cause Analysis | Revised Budget | Fact | Unifier - Cost Sheet |
Root Cause Analysis | Projected Cost | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | Estimated Cost At Completion | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | Projected Over Under | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | % Projected / Forecast | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | % Projected / Budget | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | Approved Budget Revisions | Fact | Unifier - Cost Sheet |
Root Cause Analysis | % Forecast | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | Project Count | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | Original Budget | Fact | Unifier - Cost Sheet |
Root Cause Analysis | Approved Commitment Changes | Fact | Unifier - Cost Sheet |
Root Cause Analysis | Pending Contracts, COs & POs | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | Non Commitment Cost | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | Total Costs incurred | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | Estimate to Complete (ETC) | Calculated from Fact | Unifier - Cost Sheet |
Root Cause Analysis | % Projected Costs | Calculated from Fact | Unifier - Cost Sheet |
Table 65: Root Cause Analysis - Filters
Canvas | Filter Type | Is Expression Filter | Dimension / Attribute / Measure | Subject Area / Dataset |
|---|---|---|---|---|
Root Cause Analysis | Dashboard | No | Datasource ID | Unifier - Cost Sheet |
Root Cause Analysis | Dashboard | No | CBS Name | Unifier - Cost Sheet |
Root Cause Analysis | Dashboard | No | Project Status | Unifier - Cost Sheet |
Root Cause Analysis | Visualization | Yes | ("Primavera - Cost Sheet"."Costs"."Revised Budget" - ("Primavera - Cost Sheet"."Costs"."User Defined Column 7" + "Primavera - Cost Sheet"."Costs"."Revised Commitments")) is not null and ("Primavera - Cost Sheet"."Costs"."Revised Budget" - ("Primavera - Cost Sheet"."Costs"."User Defined Column 7" + "Primavera - Cost Sheet"."Costs"."Revised Commitments")) <> 0 | Unifier - Cost Sheet |
Table 66: Root Cause Analysis - Calculated Members
Calculated Member | Expression | Source | Subject Area / Dataset |
|---|---|---|---|
Projected Cost | "Primavera - Cost Sheet"."Costs"."User Defined Column 14"+"Primavera - Cost Sheet"."Costs"."Revised Commitments"+"Primavera - Cost Sheet"."Costs"."User Defined Column 6"
| Derived From Fact | Unifier - Cost Sheet |
Estimated Cost At Completion | "Primavera - Cost Sheet"."Costs"."User Defined Column 7" + "Primavera - Cost Sheet"."Costs"."User Defined Column 13"
| Derived From Fact | Unifier - Cost Sheet |
Projected Over Under | "Primavera - Cost Sheet"."Costs"."Revised Budget" - ("Primavera - Cost Sheet"."Costs"."User Defined Column 7" + "Primavera - Cost Sheet"."Costs"."User Defined Column 13")
| Derived From Fact | Unifier - Cost Sheet |
% Projected / Forecast | (("Primavera - Cost Sheet"."Costs"."User Defined Column 14"+"Primavera - Cost Sheet"."Costs"."Revised Commitments"+"Primavera - Cost Sheet"."Costs"."User Defined Column 6") / ("Primavera - Cost Sheet"."Costs"."User Defined Column 7" + "Primavera - Cost Sheet"."Costs"."User Defined Column 13"))
| Derived From Fact | Unifier - Cost Sheet |
% Forecast / Budget | ("Primavera - Cost Sheet"."Costs"."User Defined Column 7" + "Primavera - Cost Sheet"."Costs"."User Defined Column 13") / "Primavera - Cost Sheet"."Costs"."Revised Budget"
| Derived From Fact | Unifier - Cost Sheet |
% Forecast | 1-(("Primavera - Cost Sheet"."Costs"."User Defined Column 14"+"Primavera - Cost Sheet"."Costs"."Revised Commitments"+"Primavera - Cost Sheet"."Costs"."User Defined Column 6") / ("Primavera - Cost Sheet"."Costs"."User Defined Column 7" + "Primavera - Cost Sheet"."Costs"."User Defined Column 13"))
| Derived From Fact | Unifier - Cost Sheet |
Project Count | COUNT(DISTINCT "Primavera - Cost Sheet"."General - (Project)"."Project Object Id")
| Derived From Fact | Unifier - Cost Sheet |
Pending Contracts, Cos & POs | "Primavera - Cost Sheet"."Costs"."Pending PO Amendments"+"Primavera - Cost Sheet"."Costs"."Pending Change Orders"
| Derived From Fact | Unifier - Cost Sheet |
Non Commitment Cost | "Primavera - Cost Sheet"."Costs"."User Defined Column 6"
| Derived From Fact | Unifier - Cost Sheet |
Total Costs Incurred | "Primavera - Cost Sheet"."Costs"."User Defined Column 7"
| Derived From Fact | Unifier - Cost Sheet |
% Projected Costs | "Primavera - Cost Sheet"."Costs"."User Defined Column 7"/("Primavera - Cost Sheet"."Costs"."User Defined Column 14"+"Primavera - Cost Sheet"."Costs"."Revised Commitments"+"Primavera - Cost Sheet"."Costs"."User Defined Column 6")* 100
| Derived From Fact | Unifier - Cost Sheet |
Estimate to Complete (ETC) | "Primavera - Cost Sheet"."Costs"."User Defined Column 13"
| Derived From Fact | Unifier - Cost Sheet |
Related Topics
Last Published Friday, December 8, 2023