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