Cost Overview Dashboard
Description: The Cost Overview dashboard enables executives to derive insights about which countries have the highest At Completion Total Cost, and track cost variance over time.
Number of Canvases: 1
Default Canvas: Canvas 1
Canvas/Dashboard Name: Cost Overview
Data Source(s): P6 EPPM
Subject Area: P6 - Activity
Datasets: Not applicable
Canvas
Figure 4-1 Cost Overview Default Canvas
Table 1: Cost Overview - Dimensions
| Canvas | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|
| Canvas 1 | Country Name | P6 - Activity |
| Canvas 1 | EPS ID Level 1 | P6 - Activity |
| Canvas 1 | Month Name | P6 - Activity |
| Canvas 1 | Calendar Year | P6 - Activity |
Table 2: Cost Overview - Measures
| Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
| Canvas 1 | At Completion Total Cost | Fact | P6 - Activity |
| Canvas 1 | Planned Total Cost | Fact | P6 - Activity |
| Canvas 1 | Actual Cost | Calculated from Fact | P6 - Activity |
| Canvas 1 | Planned Cost | Calculated from Fact | P6 - Activity |
Table 3: Cost Overview - Filters
| Canvas | Filter Type | Is Expression Filter | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|---|---|
| Canvas 1 | Dashboard | No | Calendar Year | P6 - Activity |
Table 4: Cost Overview - Calculated Members
| Calculated Member | Expression | Source | Subject Area / Dataset |
|---|---|---|---|
| Actual Cost |
CASE WHEN Month Name < '2015-11' THEN RSUM(Actual Total Cost) ELSE NULL END
|
Derived From Fact | P6 - Activity |
| Planned Cost |
RSUM(Planned Total Cost)
|
Derived From Fact | P6 - Activity |