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: 2
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 4-8 Activity Look Ahead Dashboard
Figure 4-9 Activity Look Ahead Details Dashboard
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 |