Budget Insights Dashboard
Description: .
Number of Canvases: 1
Default Canvas: Budget Insights
Canvas/Dashboard Name: Budget Insights
Data Source(s): Unifier
Subject Area: Unifier - Cost Sheet
Datasets: Not applicable
Dashboard
Figure 5-7 Budget Insights Dashboard
Table 67: Budget Insights - Dimensions
| Canvas | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|
| Budget Insights | Project Name | Unifier - Cost Sheet |
Table 68: Budget Insights – Measures
| Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
| Budget Insights | Revised Budget | Fact | Unifier - Cost Sheet |
| Budget Insights | Projected Cost | Unifier - Cost Sheet | |
| Budget Insights | Estimated Cost At Completion | Unifier - Cost Sheet | |
| Budget Insights | Projected Over Under | Unifier - Cost Sheet | |
| Budget Insights | Approved Budget Revisions | Unifier - Cost Sheet | |
| Budget Insights | Project Count | Unifier - Cost Sheet | |
| Budget Insights | Original Budget | Unifier - Cost Sheet | |
| Budget Insights | Approved Commitment Changes | Unifier - Cost Sheet | |
| Budget Insights | Pending Contracts, Cos & POs | Unifier - Cost Sheet | |
| Budget Insights | Non Commitment Cost | Unifier - Cost Sheet | |
| Budget Insights | Total Costs Incurred | Unifier - Cost Sheet | |
| Budget Insights | Estimate to Complete(ETC) | Unifier - Cost Sheet | |
| Budget Insights | % Projected Costs | Unifier - Cost Sheet |
Table 69: Budget Insights - Filters
| Canvas | Filter Type | Is Expression Filter | Dimension / Attribute / Measure | Subject Area / Dataset |
|---|---|---|---|---|
| Budget Insights | Dashboard | No | CBS Name | Unifier - Cost Sheet |
| Budget Insights | Visualization | Yes | "Primavera - Cost Sheet"."Costs"."User Defined Column 7" > 0 And ("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) is not null | Unifier - Cost Sheet |
Table 70: Budget Insights - 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 |
| 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 |