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 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

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)