Project Status Dashboard
Description: .
Number of Canvases: 1
Default Canvas: Project Status
Canvas/Dashboard Name: Project Status
Data Source(s): Unifier
Subject Area: Unifier - Cost Sheet
Datasets: Not applicable
Dashboard
Figure 5-5 Project Status Dashboard
Table 59: Project Status - Dimensions
| Canvas | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|
| Project Status | Project Status | Unifier - Cost Sheet |
| Project Status | Project Hierarchy | Unifier - Cost Sheet |
| Project Status | Project Name | Unifier - Cost Sheet |
Table 60: Project Status – Measures
| Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
| Project Status | Revised Budget | Fact | Unifier - Cost Sheet |
| Project Status | Projected Cost | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | Estimated Cost At Completion | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | Projected Over Under | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | % Projected / Forecast | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | % Projected / Budget | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | Approved Budget Revisions | Fact | Unifier - Cost Sheet |
| Project Status | % Forecast | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | Project Count | Fact | Unifier - Cost Sheet |
| Project Status | Original Budget | Fact | Unifier - Cost Sheet |
| Project Status | Approved Commitment Changes | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | Pending Contracts, cos & POs | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | Non Commitment Cost | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | Total Costs Incurred | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | Estimate to Complete (ETC) | Calculated from Fact | Unifier - Cost Sheet |
| Project Status | % Projected Costs | Calculated from Fact | Unifier - Cost Sheet |
Table 61: Project Status - Filters
| Canvas | Filter Type | Is Expression Filter | Dimension / Attribute / Measure | Subject Area / Dataset |
|---|---|---|---|---|
| Project Status | Dashboard | No | Datasource ID | Unifier - Cost Sheet |
| Project Status | Dashboard | No | Project Name | Unifier - Cost Sheet |
| Project Status | Visualization | Yes | "Primavera - Cost Sheet"."General - (Project)"."Project Status" is not null | Unifier - Cost Sheet |
Table 62: Project Status - 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 |