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 40: 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 |
Related Topics
Last Published Friday, December 8, 2023