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 5-6 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 |