P6 - Spread Snapshot History / Primavera - Spread Snapshot History
Description: Use this subject area to analyze how your data will appear at different points in time by creating a snapshot at different time intervals, for comparison purposes.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Fact - Primavera - Spread Snapshot History | Costs | ||||
| Fact - Primavera - Spread Snapshot History | Costs | Actual Cost | Fact | The actual non-overtime plus overtime cost for the resource assignment on the activity. Calculated as Actual Regular Cost plus Actual Overtime Cost. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Actual Overtime Cost | Fact | The actual overtime cost for the resource assignment on the activity. Calculated as Actual Overtime Units multiplied by Cost per Time multiplied by Overtime Factor. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_OVERTIME_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Actual Regular Cost | Fact | The actual non-overtime cost for the resource assignment on the activity. Calculated as Actual Regular Units multiplied by Cost per Time. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_REGULAR_COST |
| Fact - Primavera - Spread Snapshot History | Costs | At Completion Cost | Fact | The sum of the actual costs plus remaining costs for the resource assignment on the activity. Calculated as Actual Costs plus Remaining Costs. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.AT_COMPLETION_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Planned Cost | Fact | The planned cost of work required for the assignment to be completed. Calculated as Planned Units multiplied by Price per Time. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.PLANNED_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Remaining Cost | Fact | The remaining cost for the resource assignment on the activity. Calculated as Remaining Units multiplied by Cost/Time. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.REMAINING_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Remaining Late Cost | Fact | Remaining Late Cost | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.REMAINING_LATE_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Staffed Remaining Cost | Fact | The remaining cost for resource assignments that have a filled role. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.STAFFED_REMAINING_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Staffed Remaining Late Cost | Fact | Staffed Remaining Late Cost | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.STAFFED_REMAINING_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Unstaffed Remaining Cost | Fact | The remaining cost for resource assignments that do not have a filled role. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.UNSTAFFED_REMAINING_COST |
| Fact - Primavera - Spread Snapshot History | Costs | Unstaffed Remaining Late Cost | Fact | Unstaffed Remaining Late Cost | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.UNSTAFFED_REMAINING_COST |
| Fact - Primavera - Spread Snapshot History | Metrics | Metrics | |||
| Fact - Primavera - Spread Snapshot History | Metrics | # Of Activities | Fact | # Of Activities | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTIVITY_WID |
| Fact - Primavera - Spread Snapshot History | Metrics | # Of Projects | Fact | # Of Projects | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.PROJECT_WID |
| Fact - Primavera - Spread Snapshot History | Metrics | # Of Resources | Fact | # Of Resources | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.RESOURCE_WID |
| Fact - Primavera - Spread Snapshot History | Units | Units | |||
| Fact - Primavera - Spread Snapshot History | Units | Actual Overtime Units | Fact | The actual overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_OVERTIME_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Actual Regular Units | Fact | The actual nonovertime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_REGULAR_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Actual Units | Fact | The sum of the actual non-overtime and the overtime units worked by the resource on the activity. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | At Completion Units | Fact | The sum of the actual units and remaining units for the resource assignment on the activity. Calculated as Actual Units plus Remaining Units. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.AT_COMPLETION_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Planned Units | Fact | The planned units of work for the resource assignment on the activity. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.PLANNED_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Remaining Late Units | Fact | Remaining Late Units | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.REMAINING_LATE_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Remaining Units | Fact | The remaining units of work to be performed by the resource on the activity. Calculated as Planned Units minus Actual Units. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.REMAINING_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Staffed Remaining Late Units | Fact | Staffed Remaining Late Units | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.STAFFED_REMAINING_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Staffed Remaining Units | Fact | The remaining units for resource assignments that have filled a role. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.STAFFED_REMAINING_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Unstaffed Remaining Late Units | Fact | Unstaffed Remaining Late Units | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.UNSTAFFED_REMAINING_UNITS |
| Fact - Primavera - Spread Snapshot History | Units | Unstaffed Remaining Units | Fact | The remaining units for resource assignments that have not filled a role. | Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.UNSTAFFED_REMAINING_UNITS |