Search only in titles

---

Activity Look Ahead Dashboard

Description: This dashboard provides a list of upcoming activities for the next 3 days, 1 week, 2 weeks, and for the next 30, 60, and 90 days.

Number of Canvases: 7

Default Canvas: Next 3 Days

Canvas/Dashboard Name: Activity Look Ahead Dashboard

Data Source(s): P6 - EPPM

Subject Area: P6 – Activity

Datasets: Not applicable

Dashboard

Canvases

Figure 15: Activity Look Ahead Dashboard - Next 3 Days

Figure 16: Activity Look Ahead Dashboard - Next 7 Days

Figure 17: Activity Look Ahead Dashboard - Next 14 Days

Figure 18: Activity Look Ahead Dashboard - Next 30 Days

Figure 19: Activity Look Ahead Dashboard - Next 60 Days

Figure 20: Activity Look Ahead Dashboard - Next 90 Days

Figure 21: Activity Look Ahead Dashboard - Activity Details

Table 23: Activity Look Ahead - Dimensions

Canvas	Dimension / Attribute	Subject Area / Dataset
All Canvas	Activity Status	P6 – Activity
All Canvas	Critical	P6 – Activity
All Canvas	Primary Resource	P6 – Activity
All Canvas	Start	P6 – Activity
Activity Details	Finish	P6 – Activity
Activity Details	Activity Name	P6 – Activity

Table 24: Activity Look Ahead – Measures

Canvas	Fact / Measure	Measure Type	Subject Area / Dataset
Next N Days	# of Activities	Fact	P6 – Activity

Table 25: Activity Look Ahead – Filters

Canvas	Filter Type	Is Expression Filter	Dimension / Attribute / Measure	Subject Area / Dataset
Next N Days	Dashboard	No	Portfolio Name	P6 - Activity
All Canvas	Dashboard	No	Project Name	P6 - Activity
Next 3 Days	Dashboard	Yes	(CAST("Primavera - Activity"."Dates - (Activity)"."Start" AS DATE) BETWEEN CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE) AND TIMESTAMPADD(SQL_TSI_DAY,3,CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE)))	P6 - Activity
Next 7 Days	Dashboard	Yes	(CAST("Primavera - Activity"."Dates - (Activity)"."Start" AS DATE) BETWEEN CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE) AND TIMESTAMPADD(SQL_TSI_DAY,7,CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE)))	P6 - Activity
Next 14 Days	Dashboard	Yes	(CAST("Primavera - Activity"."Dates - (Activity)"."Start" AS DATE) BETWEEN CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE) AND TIMESTAMPADD(SQL_TSI_DAY,14,CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE)))	P6 - Activity
Next 30 Days	Dashboard	Yes	(CAST("Primavera - Activity"."Dates - (Activity)"."Start" AS DATE) BETWEEN CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE) AND TIMESTAMPADD(SQL_TSI_DAY,30,CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE)))	P6 - Activity
Next 60 Days	Dashboard	Yes	(CAST("Primavera - Activity"."Dates - (Activity)"."Start" AS DATE) BETWEEN CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE) AND TIMESTAMPADD(SQL_TSI_DAY,60,CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE)))	P6 - Activity
Next 90 Days	Dashboard	Yes	(CAST("Primavera - Activity"."Dates - (Activity)"."Start" AS DATE) BETWEEN CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE) AND TIMESTAMPADD(SQL_TSI_DAY,90,CAST("Primavera - Activity"."Dates - (Project)"."Data Date" AS DATE)))	P6 - Activity

Table 26: Activity Look Ahead – Calculated Members

Calculated Member	Expression	Source	Subject Area / Dataset
Schedule % Complete (PRCNT)	"Primavera - Activity"."Percent Complete"."Schedule % Complete" / 100	Derived From Fact	P6 - Activity

Related Topics

Data Visualizations Using P6 EPPM Data

Cost Overview Dashboard

Earned Value and Risk Analysis Dashboard

Overview - Portfolio, Risk, EV

Key Milestones Tracking Dashboard

Integrated Schedule Delivery KPI Dashboard

Shutdown / Turnaround / Outage Dashboard

Labor Units History Dashboard

CPI, SPI, and Labor Units Dashboard

Project Risk - Cost Overview Dashboard

Project Health Assessment Dashboard

---

Last Published Friday, December 8, 2023