P6 - Burn Down / Primavera - Burn Down
Description: Use this subject area to analyze daily project performance through burn down charts and schedule adherence metrics. Metrics include planned, actual, remaining, and emergent counts and units. Emergent data is from activities which were added after burn down began. This subject area requires project specific UDF configuration in P6.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Project | Budget - (Project) | Project Budget | |||
| Project | Budget - (Project) | Current Budget | Dimension | The Current Budget is the sum of the Original Budget and all approved budget changes in the Budget Change Log. | Value Derived From : Dim_W_PROJECT_HD_ID.CURRENT_BUDGET |
| Project | Budget - (Project) | Current Variance | Dimension | Computed as the Current Budget minus the Total Spending Plan. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_ID.CURRENT_VARIANCE |
| Project | Budget - (Project) | Distributed Current Budget | Dimension | Computed as sum of the Current Budget values from one level lower. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_ID.DISTRIBUTED_CURRENT_BUDGET |
| Project | Budget - (Project) | Original Budget | Dimension | Original budget for the project. | Value Derived From : Dim_W_PROJECT_HD_ID.ORIGINAL_BUDGET |
| Project | Budget - (Project) | Proposed Budget | Dimension | The Proposed Budget is the sum of the Original Budget plus the Approved and Pending budgets from the budget change log. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_ID.PROPOSED_BUDGET |
| Project | Budget - (Project) | Total Benefit Plan | Dimension | Sum of the Monthly Benefit Plan. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_ID.TOTAL_BENEFIT_PLAN |
| Project | Budget - (Project) | Total Benefit Plan Tally | Dimension | Sum of the Monthly Benefit Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_ID.TOTAL_BENEFIT_PLAN_TALLY |
| Project | Budget - (Project) | Total Funding | Dimension | The total amount of funding contributed to the project by your funding sources. | Value Derived From : Dim_W_PROJECT_HD_ID.TOTAL_FUNDING |
| Project | Budget - (Project) | Total Spending Plan | Dimension | Sum of the Monthly Spending Plan. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_ID.TOTAL_SPENDING_PLAN |
| Project | Budget - (Project) | Total Spending Plan Tally | Dimension | Sum of the Monthly Spending Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_ID.TOTAL_SPENDING_PLAN_TALLY |
| Project | Budget - (Project) | Unallocated Budget | Dimension | Calculated as Total Current Budget - Distributed Current Budget. | Value Derived From : Dim_W_PROJECT_HD_ID.UNALLOCATED_BUDGET |
| Project | Budget - (Project) | Undistributed Current Variance | Dimension | Computed as the Total Spending Plan minus the Total Spending Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_ID.UNDISTRIBUTED_CURRENT_VARIANCE |
| Project | Dates - (Project) | Project Dates | |||
| Project | Dates - (Project) | Anticipated Finish | Dimension | Anticipated finish date of WBS, Project and EPS elements. User-entered - not dependent upon any other fields. If there are no children, the anticipated finish date will be the Finish date displayed in the columns. | Value Derived From : Dim_W_PROJECT_D_Project.ANTICIPATED_FINISH_DATE |
| Project | Dates - (Project) | Anticipated Start | Dimension | Anticipated start date of WBS, Project and EPS elements. User-entered - not dependent upon any other fields. If there are no children, the anticipated start date will be the Start date displayed in the columns. | Value Derived From : Dim_W_PROJECT_D_Project.ANTICIPATED_START_DATE |
| Project | Dates - (Project) | Data Date | Dimension | The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied. | Value Derived From : Dim_W_PROJECT_D_Project.DATA_DATE |
| Project | Dates - (Project) | Date Added | Dimension | The date this activity was inserted. | Value Derived From : Dim_W_PROJECT_D_Project.ADD_DATE |
| Project | Dates - (Project) | Finish | Dimension | The current finish date of the activity. Set to the activity remaining early finish date while the activity is not started or in progress, and the actual finish date once the activity is completed. | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_FINISH_DATE |
| Project | Dates - (Project) | Forecast Finish Date | Dimension | An alternate end date to be optionally used by the scheduler (see Schedule dialog), which is set by the user by dragging the project bar in the Gantt Chart around while manually leveling the resource profile (in a resource analysis layout, tracking or PA). In User Preferences dialog, the user can choose to view remaining units for a resource based on the forecast dates or the remaining dates. | Value Derived From : Dim_W_PROJECT_D_Project.FORECAST_FINISH_DATE |
| Project | Dates - (Project) | Forecast Start Date | Dimension | An alternate start date to be optionally used by the scheduler (see Schedule dialog), which is set by the user by dragging the project bar in the Gantt Chart around while manually leveling the resource profile (in a resource analysis layout, tracking or PA). In the User Preferences dialog, the user can choose to view remaining units for a resource based on the forecast dates or the remaining dates. | Value Derived From : Dim_W_PROJECT_D_Project.FORECAST_START_DATE |
| Project | Dates - (Project) | Must Finish By | Dimension | The date by which all project activities must finish. If entered, it is used as the project late finish date by the project scheduler. | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_PLANNED_FINISH_DATE |
| Project | Dates - (Project) | Planned Start | Dimension | The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started. | Value Derived From : Dim_W_PROJECT_D_Project.PLANNED_START_DATE |
| Project | Dates - (Project) | Scheduled Finish | Dimension | The early finish date of the latest activity in the project, as computed by the project scheduler. | Value Derived From : Dim_W_PROJECT_D_Project.SCHEDULED_FINISH_DATE |
| Project | Dates - (Project) | Start | Dimension | The current start date of the activity. Set to the activity remaining early start date while the activity is not started, and the actual start date once the activity is started. | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_START_DATE |
| Project | Dates - (Project) | Workdown Date | Dimension | The date as specified in the Project level UDF sys_workdown_date | Value Derived From : Dim_W_PROJECT_HD_ID.WORKDOWN_DATE |
| Project | Durations - (Project) | Project Durations | |||
| Project | Durations - (Project) | Actual Duration | Dimension | Actual duration is the total time from the project actual start date to the actual finish date (for completed projects), or to the current data date (for in-progress projects). | Value Derived From : Dim_W_PROJECT_D_Project.ACTUAL_DURATION |
| Project | Durations - (Project) | At Completion Duration | Dimension | The duration at completion is the total time from the project current start date to the current finish date. | Value Derived From : Dim_W_PROJECT_D_Project.AT_COMPLETION_DURATION |
| Project | Durations - (Project) | Baseline Project Duration | Dimension | The duration of the baseline project. | Value Derived From : Dim_W_PROJECT_D_Project.BASELINE_DURATION |
| Project | Durations - (Project) | Planned Duration | Dimension | Planned duration is the total time from the project planned start date to the planned finish date. | Value Derived From : Dim_W_PROJECT_D_Project.PLANNED_DURATION |
| Project | Durations - (Project) | Remaining Duration | Dimension | Remaining duration is the total time from the current data date date to the current finish date. | Value Derived From : Dim_W_PROJECT_D_Project.REMAINING_DURATION |
| Project | Durations - (Project) | Variance - Baseline Project Duration | Dimension | The duration between the baseline project duration and the current project duration. Calculated as Planned Duration minus At Completion Duration. | Value Derived From : Dim_W_PROJECT_D_Project.DURATION_VARIANCE |
| Project | General - (Project) | General Project Information | |||
| Project | General - (Project) | Added By | Dimension | The name of the user who added the project | Value Derived From : Dim_W_PROJECT_HD_ID.ADDED_BY_NAME |
| Project | General - (Project) | Datasource Id | Dimension | A unique source Id created for the Primavera data source being used. Used to identify data sources when using multiple Primavera data sources. | Value Derived From : Dim_W_PROJECT_HD_ID.DATASOURCE_ID |
| Project | General - (Project) | Project Leveling Priority | Dimension | Priority for leveling | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_PRIORITY |
| Project | General - (Project) | Project Score | Dimension | The Project score | Value Derived From : Dim_W_PROJECT_HD_ID.OVERALL_PROJECT_SCORE |
| Project | General - (Project) | Project Description | Dimension | The project description | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_DESCRIPTION |
| Project | General - (Project) | Project Id | Dimension | The Project Id of the project | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_ID |
| Project | General - (Project) | Project Name | Dimension | The project name | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_NAME |
| Project | General - (Project) | Unique Project ID | Dimension | The Unique ID of the project | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_ID |
| Project | General - (Project) | Strategic Priority | Dimension | Resource designated as owner of the project | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_STRATEGIC_PRIORITY |
| Project | General - (Project) | Project Risk Exposure | Dimension | The calculated exposure value for the risk | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_RISK_EXPOSURE |
| Project | General - (Project) | Project Risk Level | Dimension | Project risk level (1 - Very Low, 2 - Low, 3 - Medium, 4 - High, 5 - Very High) | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_RISK_LEVEL |
| Project | General - (Project) | Project Risk Score | Dimension | The calculated score value of the impact values assigned to the risk | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_RISK_SCORE |
| Project | General - (Project) | WBS | Dimension | The Unique ID of the project's root level WBS | Value Derived From : Dim_W_PROJECT_HD_ID.WBS_OBJECT_ID |
| Project | General - (Project) | Project Status | Dimension | The status of the project as active, inactive, planned or what-if | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_STATUS |
| Project | General - (Project) | Strategic Priority | Dimension | Range 1 to 10,000 | Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_STRATEGIC_PRIORITY |
| Project | Location - (Project) | Location - (Project) | Project Location | ||
| Project | Location - (Project) | Address Line 1 | Dimension | The first line of the address | Value Derived From : Dim_W_PROJECT_HD_ID.ADDRESS_LINE1 |
| Project | Location - (Project) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_PROJECT_HD_ID.ADDRESS_LINE2 |
| Project | Location - (Project) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.CITY_NAME |
| Project | Location - (Project) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.COUNTRY_CODE |
| Project | Location - (Project) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.COUNTRY_NAME |
| Project | Location - (Project) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.LATITUDE |
| Project | Location - (Project) | Location Name | Dimension | The name of the location | Value Derived From : Dim_W_PROJECT_HD_ID.LOCATION_NAME |
| Project | Location - (Project) | Location Type | Dimension | Location Type | Value Derived From : Dim_W_PROJECT_HD_ID.LOCATION_TYPE |
| Project | Location - (Project) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.LONGITUDE |
| Project | Location - (Project) | Municipality Name | Dimension | The municipality name for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.MUNICIPALITY_NAME |
| Project | Location - (Project) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.POSTAL_CODE |
| Project | Location - (Project) | State/Province Code | Dimension | The state abbreviation for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.STATE_CODE |
| Project | Location - (Project) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_PROJECT_HD_ID.STATE_NAME |
| Project | P6 Links | Go to P6 Links | |||
| Project | P6 Links | Link to Activities | Dimension | Go to Project Activities | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_P6_LINK_BASE_URL") || VALUEOF("DW_P6_LINK_PROJECT_LIST_BASE_URL") || CAST (P6Core."Dim - Project HD ID"."Project WBS Object Id" AS VARCHAR ( 10 )) || '%26key%3Dactivities">' || 'Project Activities' || '</a>' |
| Project | P6 Links | Link to Documents | Dimension | Go to Project Documents | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_P6_LINK_BASE_URL") || VALUEOF("DW_P6_LINK_PROJECT_LIST_BASE_URL") || CAST (P6Core."Dim - Project HD ID"."Project WBS Object Id" AS VARCHAR ( 10 )) || '%26key%3Ddocuments">' || 'Project Documents' || '</a>' |
| Project | P6 Links | Link to Issues | Dimension | Go to Project Issues | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_P6_LINK_BASE_URL") || '/action/pm/lwfissuemanagement?projectId=' || CAST (P6Core."Dim - Project HD ID"."Project Object Id" AS VARCHAR ( 10 )) || '&wbsId=' || CAST (P6Core."Dim - Project HD ID"."Project WBS Object Id" AS VARCHAR ( 10 )) || '&checkTabs=true">' || 'Project Issues' || '</a>' |
| Project | P6 Links | Link to Risks | Dimension | Go to Project Risks | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_P6_LINK_BASE_URL") || VALUEOF("DW_P6_LINK_PROJECT_LIST_BASE_URL") || CAST (P6Core."Dim - Project HD ID"."Project WBS Object Id" AS VARCHAR ( 10 )) || '%26key%3Drisks">' || 'Project Risks' || '</a>' |
| Project | P6 Links | Link to Team Usage | Dimension | Go to Project Team Usage | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_P6_LINK_BASE_URL") || VALUEOF("DW_P6_LINK_PROJECT_LIST_BASE_URL") || CAST (P6Core."Dim - Project HD ID"."Project WBS Object Id" AS VARCHAR ( 10 )) || '%26key%3Dteamusage">' || 'Project Team Usage' || '</a>' |
| Project | Notebooks - (Project) | Project level notebook topics. | |||
| Project | Notebooks - (Project) | Create Date | Dimension | The date the notebook topic was created | Value Derived From : Dim_W_PROJECT_NOTE_D_ID.W_CREATE_DT |
| Project | Notebooks - (Project) | Create User | Dimension | The user that created the notebook topic | Value Derived From : Dim_W_PROJECT_NOTE_D_ID.W_CREATE_USER |
| Project | Notebooks - (Project) | Notebook Text | Lookup | The text of the notebook topic | Lookup(DENSE "P6Core"."Lookup - Project Note D ID"."Raw Text", "P6Core"."Dim - Project Note D ID"."Note Key", "P6Core"."Dim - Project Note D ID"."Project Key") |
| Project | Notebooks - (Project) | Notebook Topic Name | Dimension | The name of the notebook topic | Value Derived From : Dim_W_PROJECT_NOTE_D_ID.NOTEBOOK_TOPIC_NAME |
| Project | Notebooks - (Project) | Update Date | Dimension | The date the notebook topic was updated | Value Derived From : Dim_W_PROJECT_NOTE_D_ID.W_UPDATE_DT |
| Project | Notebooks - (Project) | Update User | Dimension | The last user to update notebook topic | Value Derived From : Dim_W_PROJECT_NOTE_D_ID.W_UPDATE_USER |
| Fact - Primavera - Burn Down Folder | |||||
| Fact - Primavera - Burn Down | 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_ACTIVITY_WORK_DOWN_HF_WDAct.ACTUAL_COST |
| Fact - Primavera - Burn Down | Costs | Actual Cost Burn | Fact | The actual cost distributed over the activity duration | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.ACTUAL_COST_BURN |
| Fact - Primavera - Burn Down | Costs | Baseline Cost | Fact | Planned Cost from the Burn Down snapshot | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.BASELINE_COST |
| Fact - Primavera - Burn Down | Costs | Baseline Cost Burn | Fact | The expected remaining cost distributed over the activity duration based on Burn Down snapshot | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.BASELINE_COST_BURN |
| Fact - Primavera - Burn Down | Costs | At Completion Cost | Fact | The sum of the Actual Costs plus Remaining Costs | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.COMPLETE_COST |
| Fact - Primavera - Burn Down | 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_ACTIVITY_WORK_DOWN_HF_WDAct.REMAINING_COST |
| Fact - Primavera - Burn Down | Costs | Remaining Cost Burn | Fact | The remaining cost distributed over the activity duration | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.REMAINING_COST_BURN |
| Activity Folder | |||||
| Activity | Dates - (Activity) | Activity Dates | |||
| Activity | Dates - (Activity) | Actual Finish | Dimension | The date on which the activity actually finished | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTUAL_FINISH_DATE |
| Activity | Dates - (Activity) | Actual Start | Dimension | The date on which the activity actually started | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTUAL_START_DATE |
| Activity | Dates - (Activity) | Baseline Project Finish | Dimension | The Project Baseline Planned Finish Date. | Value Derived From : Dim_W_ACTIVITY_D_Activity.BASELINE_FINISH_DATE |
| Activity | Dates - (Activity) | Baseline Project Start | Dimension | The Project Baseline Planned Start Date. | Value Derived From : Dim_W_ACTIVITY_D_Activity.BASELINE_START_DATE |
| Activity | Dates - (Activity) | Data Date | Dimension | The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied. | Value Derived From : Dim_W_ACTIVITY_D_Activity.DATA_DATE |
| Activity | Dates - (Activity) | Early Finish | Dimension | The earliest possible date the activity can finish. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability. | Value Derived From : Dim_W_ACTIVITY_D_Activity.EARLY_FINISH_DATE |
| Activity | Dates - (Activity) | Early Start | Dimension | The earliest possible date the remaining work for the activity can begin. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability. | Value Derived From : Dim_W_ACTIVITY_D_Activity.EARLY_START_DATE |
| Activity | Dates - (Activity) | Expected Finish | Dimension | The date the activity is expected to finish. Typically, this date is entered in the Timesheets module by the primary resource. | Value Derived From : Dim_W_ACTIVITY_D_Activity.EXPECT_FINISH_DATE |
| Activity | Dates - (Activity) | External Early Start | Dimension | The External Early Start date is the earliest finish date of all lost external relationships. This field is populated only during import when a relationship is lost because it does not exist in the current database. This date may be used to calculate the start date of the current activity in place of the true relationship when scheduling. | Value Derived From : Dim_W_ACTIVITY_D_Activity.EXTERNAL_EARLY_START_DATE |
| Activity | Dates - (Activity) | External Late Finish | Dimension | The External Late Finish date is the latest start date of all lost external relationships. This field is populated only during import when a relationship is lost because it does not exist in the current database. This date may be used to calculate the finish date of the current activity in place of the true relationship when scheduling. | Value Derived From : Dim_W_ACTIVITY_D_Activity.EXTERNAL_LATE_FINISH_DATE |
| Activity | Dates - (Activity) | Finish | Dimension | The current finish date of the activity. Set to the activity remaining early finish date while the activity is not started or in progress, and the actual finish date once the activity is completed. | Value Derived From : Dim_W_ACTIVITY_D_Activity.FINISH_DATE |
| Activity | Dates - (Activity) | Late Finish | Dimension | The latest possible date the activity must finish without delaying the project finish date. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability. | Value Derived From : Dim_W_ACTIVITY_D_Activity.LATE_FINISH_DATE |
| Activity | Dates - (Activity) | Late Start | Dimension | The latest possible date the remaining work for the activity must begin without delaying the project finish date. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability. | Value Derived From : Dim_W_ACTIVITY_D_Activity.LATE_START_DATE |
| Activity | Dates - (Activity) | Planned Finish | Dimension | The date the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PLANNED_FINISH_DATE |
| Activity | Dates - (Activity) | Planned Start | Dimension | The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PLANNED_START_DATE |
| Activity | Dates - (Activity) | Primary Constraint Date | Dimension | The constraint date for the activity, if the activity has a constraint. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PRIMARY_CONSTRAINT_DATE |
| Activity | Dates - (Activity) | Remaining Early Finish | Dimension | The date the remaining work for the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date. This is the finish date that Progress Reporter users follow. | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_FINISH_DATE |
| Activity | Dates - (Activity) | Remaining Early Start | Dimension | The date the remaining work for the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining start date is the same as the planned start date. This is the start date that Progress Reporter users follow. | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_START_DATE |
| Activity | Dates - (Activity) | Remaining Late Finish | Dimension | Remaining late end date is calculated by the scheduler. | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_LATE_FINISH_DATE |
| Activity | Dates - (Activity) | Remaining Late Start | Dimension | Remaining late start date is calculated by the scheduler. | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_LATE_START_DATE |
| Activity | Dates - (Activity) | Resume Date | Dimension | The date progress is resumed on an activity. | Value Derived From : Dim_W_ACTIVITY_D_Activity.RESUME_DATE |
| Activity | Dates - (Activity) | Secondary Constraint Date | Dimension | The second constraint date for the activity, if the activity has a constraint. | Value Derived From : Dim_W_ACTIVITY_D_Activity.SECONDARY_CONSTRAINT_DATE |
| Activity | Dates - (Activity) | Start | Dimension | The current start date of the activity. Set to the activity remaining early start date while the activity is not started, and the actual start date once the activity is started. | Value Derived From : Dim_W_ACTIVITY_D_Activity.START_DATE |
| Activity | Dates - (Activity) | Suspend Date | Dimension | The date progress is suspended on an activity. | Value Derived From : Dim_W_ACTIVITY_D_Activity.SUSPEND_DATE |
| Activity | Durations - (Activity) | Activity Durations | |||
| Activity | Durations - (Activity) | Actual Duration | Dimension | Actual duration is the total working time from the activity actual start date to the actual finish date (for completed activities), or to the current data date (for in-progress activities). The actual working time is computed using the activity's calendar. | Value Derived From : Dim_W_ACTIVITY_D_Activity.ACTUAL_DURATION |
| Activity | Durations - (Activity) | At Completion Duration | Dimension | The duration at completion is the total working time from the activity's current start date to the current finish date. The current start date is the planned start date until the activity is started, then it is the actual start date. The current finish date is the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed. The total working time is computed using the activity's calendar. | Value Derived From : Dim_W_ACTIVITY_D_Activity.AT_COMPLETION_DURATION |
| Activity | Durations - (Activity) | Baseline Project Duration | Dimension | The duration for the activity in the primary baseline. | Value Derived From : Dim_W_ACTIVITY_D_Activity.BASELINE_DURATION |
| Activity | Durations - (Activity) | Baseline Planned Duration | Dimension | Baseline Planned Duration is the total working time from the baseline activity planned start date to the baseline planned finish date. The baseline planned working time is computed using the activity's calendar. | Value Derived From : Dim_W_ACTIVITY_D_Activity.BASELINE_PLANNED_DURATION |
| Activity | Durations - (Activity) | Free Float | Dimension | The amount of time the activity can be delayed before delaying the start date of any successor activity. | Value Derived From : Dim_W_ACTIVITY_D_Activity.FREE_FLOAT |
| Activity | Durations - (Activity) | Original Duration | Dimension | Original Duration is the total working time from the activity planned start date to the planned finish date. The planned working time is computed using the activity's calendar. | Value Derived From : Dim_W_ACTIVITY_D_Activity.PLANNED_DURATION |
| Activity | Durations - (Activity) | Remaining Duration | Dimension | Remaining duration is the total working time from the activity remaining start date to the remaining finish date. The remaining working time is computed using the activity's calendar. Before the activity is started, the remaining duration is the same as the Original Duration. After the activity is completed the remaining duration is zero. | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_DURATION |
| Activity | Durations - (Activity) | Remaining Float | Dimension | The amount of time remaining by which the activity can be delayed before delaying the project finish date. Computed as Late Finish - Remaining Finish. If the remaining finish is the same as the early finish ( in general, when the activity is not started), then the remaining float is the same as the total float. | Value Derived From : Dim_W_ACTIVITY_D_Activity.REMAINING_FLOAT |
| Activity | Durations - (Activity) | Total Float | Dimension | The amount of time the activity can be delayed before delaying the project finish date. Total float can be computed as Late Start - Early Start or as Late Finish - Early Finish; this option can be set when running the project scheduler. | Value Derived From : Dim_W_ACTIVITY_D_Activity.TOTAL_FLOAT |
| Activity | Durations - (Activity) | Variance - Baseline Project Duration | Dimension | Variance duration is the duration between the activity' Baseline project duration and the At Completion duration. | Value Derived From : Dim_W_ACTIVITY_D_Activity.DURATION_VARIANCE |
| Activity | Durations - (Activity) | Variance - Baseline Project Finish Date | Dimension | Variance Finish Date is the duration between the Baseline project finish date and the finish date in the current project. | Value Derived From : Dim_W_ACTIVITY_D_Activity.FINISH_DATE_VARIANCE |
| Activity | Durations - (Activity) | Variance - Baseline Project Start Date | Dimension | Variance Start Date is the duration between the Baseline project start date and the start date in the current project. | Value Derived From : Dim_W_ACTIVITY_D_Activity.START_DATE_VARIANCE |
| Activity | General - (Activity) | General Activity Information | |||
| Activity | General - (Activity) | Activity ID | Dimension | A short ID which uniquely identifies the activity within the project. | Value Derived From : Dim_W_ACTIVITY_HD_ID.ACTIVITY_ID |
| Activity | General - (Activity) | Activity Name | Dimension | The name of the activity. The activity name does not have to be unique. | Value Derived From : Dim_W_ACTIVITY_HD_ID.ACTIVITY_NAME |
| Activity | General - (Activity) | Owner | Dimension | User who owns the activity. | Value Derived From : Dim_W_ACTIVITY_HD_ID.ACTIVITY_OWNER |
| Activity | General - (Activity) | Activity Status | Dimension | The current status of the activity, either Not Started, In Progress, or Completed. | Value Derived From : Dim_W_ACTIVITY_HD_ID.ACTIVITY_STATUS |
| Activity | General - (Activity) | Activity Type | Dimension | The type of activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone' or 'Finish Milestone'. A Task Dependent activity is scheduled using the activity's calendar rather than the calendars of the assigned resources. A Resource Dependent activity is scheduled using the calendars of the assigned resources. This type is used when several resources are assigned to the activity, but they may work separately. A Start/Finish Milestone is a zero-duration activity, marking a significant start/end of project event. A Level of Effort activity has a duration which is determined by its dependent activities. Administration-type activities are typically level of effort. | Value Derived From : Dim_W_ACTIVITY_HD_ID.ACTIVITY_TYPE |
| Activity | General - (Activity) | Auto Compute Actuals | Dimension | Identifies whether the actual and remaining units, start date, finish date, and percent complete for the activity are computed automatically using the planned dates, budgeted units and the activity's schedule percent complete. If this option is selected, the actual/remaining units and actual dates are automatically updated when project actuals are applied. This assumes that all work for the activity proceeds according to plan. | Value Derived From : Dim_W_ACTIVITY_HD_ID.AUTO_COMPUTE_ACTUALS_FLAG |
| Activity | General - (Activity) | Calendar Name | Dimension | The calendar assigned to the activity. Activity calendars can be assigned from the global calendar pool or the project calendar pool. | Value Derived From : Dim_W_ACTIVITY_HD_ID.CALENDAR_NAME |
| Activity | General - (Activity) | Criticality Index | Dimension | Criticality Index | Value Derived From : Dim_W_ACTIVITY_HD_ID.CRITICALITY_INDEX |
| Activity | General - (Activity) | Duration Type | Dimension | The duration type of the activity. One of Fixed Units per Time, Fixed Duration, or Fixed Units. For Fixed Units per Time activities, the resource units per time are constant when the activity duration or units are changed. This type is used when an activity has fixed resources with fixed productivity output per time period. For Fixed Duration activities, the activity duration is constant as the units or resource units per time are changed. This type is used when the activity is to be completed within a fixed time period regardless of the resources assigned. For Fixed Units activities, the activity units are constant when the duration or resource units per time are changed. This type is used when the total amount of work is fixed, and increasing the resources can decrease the activity duration. | Value Derived From : Dim_W_ACTIVITY_HD_ID.DURATION_TYPE |
| Activity | General - (Activity) | Critical | Dimension | Indicates whether the activity is critical. An activity is critical when its Total Float is below the critical duration specified for the project. Delaying critical activities will delay the finish date of the project. | Value Derived From : Dim_W_ACTIVITY_HD_ID.IS_CRITICAL |
| Activity | General - (Activity) | Longest Path | Dimension | Indicates whether an activity is on the longest path. The longest path is defined as activities that are on the critical path and determine the end date of the project. Defining critical activities based on the longest path in the project provides an alternative to viewing critical activities based on float. | Value Derived From : Dim_W_ACTIVITY_HD_ID.IS_LONGEST_PATH |
| Activity | General - (Activity) | Activity Leveling Priority | Dimension | The activity priority can be used to prioritize activities in a project when performing resource leveling. | Value Derived From : Dim_W_ACTIVITY_HD_ID.LEVELING_PRIORITY |
| Activity | General - (Activity) | Percent Complete Type | Dimension | The activity percent complete type is one of Duration, Units, or Physical. The percent complete type controls whether the Activity % Complete is tied to the Duration % Complete, the Units % Complete, or the Physical % Complete for the activity. Set the percent complete type to Duration for activities which are duration driven, for example, administration tasks and training classes. Set the percent complete type to Physical for activities which are work-product driven, for example, creating a document or a product. Set the percent complete type to Units for activities which are work effort driven, for example, providing a consulting service. | Value Derived From : Dim_W_ACTIVITY_HD_ID.COMPLETE_PCT_TYPE |
| Activity | General - (Activity) | Primary Constraint | Dimension | The type of constraint applied to the activity start or finish date. Activity constraints are used by the project scheduler. Start date constraints are 'Start On', 'Start On or Before', 'Start On or After' and 'Mandatory Start'. Finish date constraints are 'Finish On', 'Finish On or Before', 'Finish On or After' and 'Mandatory Finish'. Another type of constraint, 'As Late as Possible', schedules the activity as late as possible based on the available free float. | Value Derived From : Dim_W_ACTIVITY_HD_ID.PRIMARY_CONSTRAINT_TYPE |
| Activity | General - (Activity) | Primary Resource | Dimension | The primary resource for the activity. The primary resource is responsible for the overall work on the activity and updates the activity status using Progress Reporter. | Value Derived From : Dim_W_ACTIVITY_HD_ID.PRIMARY_RESOURCE_NAME |
| Activity | General - (Activity) | Secondary Constraint | Dimension | The second type of constraint applied to the activity start or finish date. | Value Derived From : Dim_W_ACTIVITY_HD_ID.SECONDARY_CONSTRAINT_TYPE |
| Activity | General - (Activity) | WBS Code | Dimension | The WBS for the activity. | Value Derived From : Dim_W_ACTIVITY_HD_ID.WBS_CODE |
| Activity | General - (Activity) | WBS Name | Dimension | The Work Breakdown Structure Name. | Value Derived From : Dim_W_ACTIVITY_HD_ID.WBS_NAME |
| Activity | Location - (Activity) | Activity Location | |||
| Activity | Location - (Activity) | Address Line 1 | Dimension | The first line of the address | Value Derived From : Dim_W_ACTIVITY_HD_ID.ADDRESS_LINE1 |
| Activity | Location - (Activity) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_ACTIVITY_HD_ID.ADDRESS_LINE2 |
| Activity | Location - (Activity) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.CITY_NAME |
| Activity | Location - (Activity) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.COUNTRY_CODE |
| Activity | Location - (Activity) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.COUNTRY_NAME |
| Activity | Location - (Activity) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.LATITUDE |
| Activity | Location - (Activity) | Location Name | Dimension | The name of the location | Value Derived From : Dim_W_ACTIVITY_HD_ID.LOCATION_NAME |
| Activity | Location - (Activity) | Location Type | Dimension | Location Type | Value Derived From : Dim_W_ACTIVITY_HD_ID.LOCATION_TYPE |
| Activity | Location - (Activity) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.LONGITUDE |
| Activity | Location - (Activity) | Municipality Name | Dimension | The municipality name for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.MUNICIPALITY_NAME |
| Activity | Location - (Activity) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.POSTAL_CODE |
| Activity | Location - (Activity) | State/Province Code | Dimension | The state abbreviation for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.STATE_CODE |
| Activity | Location - (Activity) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_ACTIVITY_HD_ID.STATE_NAME |
| Activity | Multiple Float Paths - (Activity) | Activity Multiple Float Paths | |||
| Activity | Multiple Float Paths - (Activity) | Float Path | Dimension | The project scheduler determines the most critical and sub-critical paths. The float path field identifies the critical path that each activity is on. The number starts from 1 (where 1 is most critical) to the max number of float paths identified by the scheduler. This field is used when determining multiple float paths using the Free Float and Total Float method. | Value Derived From : Dim_W_ACTIVITY_HD_ID.FLOAT_PATH |
| Activity | Multiple Float Paths - (Activity) | Float Path Order | Dimension | This field is computed by the project scheduler and identifies the order in which the activities were processed within the float path. | Value Derived From : Dim_W_ACTIVITY_HD_ID.FLOAT_PATH_ORDER |
| Activity | Percent Completes - (Activity) | Activity Percent Completes | |||
| Activity | Percent Completes - (Activity) | Duration % Of Planned | Dimension | The percent complete of the activity duration. Computed as (Planned Duration - Remaining Duration)/Original Duration * 100. Always in the range 0 to 100. The Planned Duration is taken from the current plan, not from the baseline. | Value Derived From : Dim_W_ACTIVITY_HD_ID.DURATION_PCT_OF_PLANNED |
| Activity | Percent Completes - (Activity) | Duration % Complete | Dimension | The percent complete of the activity duration. Computed as (Original Duration - Remaining Duration)/Original Duration * 100. Always in the range 0 to 100. The Original Duration is taken from the current plan, not from the baseline. | Value Derived From : Dim_W_ACTIVITY_HD_ID.DURATION_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Expense Cost % Complete | Dimension | Percent complete of cost for all expenses associated with an activity. Computed as Actual Expense Cost / At Completion Expense Cost* 100. Always in the range 0 to 100. | Value Derived From : Dim_W_ACTIVITY_HD_ID.EXPENSE_COST_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Labor Units % Complete | Dimension | The percent complete of units for all labor resources for the activity. Computed as Actual Labor Units / At Completion Labor Units * 100. Always in the range 0 to 100. | Value Derived From : Dim_W_ACTIVITY_HD_ID.LABOR_UNITS_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Nonlabor Cost % Complete | Dimension | The percent complete of cost for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100. | Value Derived From : Dim_W_ACTIVITY_HD_ID.NONLABOR_COST_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Nonlabor Units % Complete | Dimension | The percent complete of units for all nonlabor resources for the activity. Computed as Actual Nonlabor Units / At Completion Nonlabor Units * 100. Always in the range 0 to 100. | Value Derived From : Dim_W_ACTIVITY_HD_ID.NONLABOR_UNITS_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Percent Complete | Dimension | The activity percent complete. This value is tied to the activity Duration % Complete, Units % Complete, or Physical % Complete, depending on the setting for the activity's Percent Complete Type, which is one of Duration, Units, or Physical. Always in the range 0 to 100. | Value Derived From : Dim_W_ACTIVITY_HD_ID.PERCENT_COMPLETE |
| Activity | Percent Completes - (Activity) | Performance % Complete | Dimension | The activity performance percent complete. The performance percent complete is used to compute earned value and may be based on the Activity % Complete, on the 0/100 rule, on the 50/50 rule, etc., depending on the technique for computing earned-value percent complete for the activity's WBS. The Performance % Complete specifies what percentage of the activity's planned worth has been earned so far. | Value Derived From : Dim_W_ACTIVITY_HD_ID.PERFORMANCE_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Physical % Complete | Dimension | The physical percent complete can either be user entered or calculated from the activity's weighted steps. There is a project setting specifying this. | Value Derived From : Dim_W_ACTIVITY_HD_ID.PHYSICAL_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Schedule % Complete | Dimension | The activity schedule percent complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the baseline Start, the Schedule % Complete is 0. If the data date is later than the baseline Finish, the Schedule % Complete is 100. The Schedule % Complete indicates how much of the activity duration should be currently completed, relative to the selected baseline. | Value Derived From : Dim_W_ACTIVITY_HD_ID.SCHEDULE_PCT_COMPLETE |
| Activity | Percent Completes - (Activity) | Units % Complete | Dimension | The percent complete of units for all labor and nonlabor resources assigned to the activity. Computed as Actual Units / At Completion Units * 100. Always in the range 0 to 100. | Value Derived From : Dim_W_ACTIVITY_HD_ID.UNITS_PCT_COMPLETE |
| Activity | Notebooks - (Activity) | Activity level notebook topics. | |||
| Activity | Notebooks - (Activity) | Create Date | Dimension | The date the notebook topic was created | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.W_CREATE_DT |
| Activity | Notebooks - (Activity) | Create User | Dimension | The user that created the notebook topic | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.W_CREATE_USER |
| Activity | Notebooks - (Activity) | Notebook Text | The text of the notebook topic | Value Derived From : LOOKUP(DENSE "P6Core"."Lookup - Activity Note"."Raw Text", "P6Core"."Dim - Activity Note"."Note Key", "P6Core"."Dim - Activity Note"."Activity Key") | |
| Activity | Notebooks - (Activity) | Notebook Topic Name | Dimension | The name of the notebook topic | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.NOTEBOOK_TOPIC_NAME |
| Activity | Notebooks - (Activity) | Update Date | Dimension | The date the notebook topic was updated | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.W_UPDATE_DT |
| Activity | Notebooks - (Activity) | Update User | Dimension | The last user to update notebook topic | Value Derived From : Dim_W_ACTIVITY_NOTE_D_Activity_Note.W_UPDATE_USER |
| Resource Assignment Folder | |||||
| Resource Assignment | Dates - (Resource Assignment) | ||||
| Resource Assignment | Dates - (Resource Assignment) | Actual Finish | Dimension | The date on which the assignment is complete. | Value Derived From : Dim_W_ASSIGNMENT_HD_ID.ACTUAL_FINISH_DATE |
| Resource Assignment | Dates - (Resource Assignment) | Actual Start | Dimension | The date on which the assignment actually started. | Value Derived From : Dim_W_ASSIGNMENT_HD_ID.ACTUAL_START_DATE |
| Resource Assignment | Dates - (Resource Assignment) | Planned Finish | Dimension | The date the assignment is scheduled to be finished. | Value Derived From : Dim_W_ASSIGNMENT_HD_ID.PLANNED_FINISH_DATE |
| Resource Assignment | Dates - (Resource Assignment) | Planned Start | Dimension | The date work on the assignment is scheduled to begin. | Value Derived From : Dim_W_ASSIGNMENT_HD_ID.PLANNED_START_DATE |
| Resource Assignment | Dates - (Resource Assignment) | Remaining Finish | Dimension | The date the assignment is scheduled to be finished. This date can be updated manually by the user. Before the activity is started, this date is the same as the Planned Finish date. | Value Derived From : Dim_W_ASSIGNMENT_HD_ID.REMAINING_FINISH_DATE |
| Resource Assignment | Dates - (Resource Assignment) | Remaining Start | Dimension | The date the assignment is scheduled to begin. This date can be updated manually by the user. Before the activity is started, this date is the same as the Planned Start date. | Value Derived From : Dim_W_ASSIGNMENT_HD_ID.REMAINING_START_DATE |
| Resource Assignment | General - (Resource Assignment) | Resource Name | Dimension | The name of the resource for this assignment | Value Derived From : Dim_W_ASSIGNMENT_HD_ID.RESOURCE_NAME |
| Resource Assignment | General - (Resource Assignment) | Role Name | Dimension | The name of the role for this assignment | Value Derived From : Dim_W_ASSIGNMENT_HD_ID.ROLE_NAME |
| Resource Folder | |||||
| Resource | General - (Resource) | General Resource Information | |||
| Resource | General - (Resource) | Active | Dimension | Indicates whether the resource is currently active. Nonactive resources may have left the organization but are not deleted from the system since they may have actual hours. | Value Derived From : Dim_W_RESOURCE_HD_ID.ACTIVE_FLAG |
| Resource | General - (Resource) | Datasource Id | Dimension | A unique source Id created for the Primavera data source being used. Used to identify data sources when using multiple Primavera data sources. | Value Derived From : Dim_W_RESOURCE_HD_ID.DATASOURCE_ID |
| Resource | General - (Resource) | Primary Role Name | Dimension | The name of the role that is assigned as the resource's primary role. | Value Derived From : Dim_W_RESOURCE_HD_ID.PRIMARY_ROLE_NAME |
| Resource | General - (Resource) | Unique Primary Role Id | Dimension | The unique Id of the role that is assigned as the resource's primary role. | Value Derived From : Dim_W_RESOURCE_HD_ID.PRIMARY_ROLE_OBJECT_ID |
| Resource | General - (Resource) | Resource ID | Dimension | A short code which uniquely identifies the resource. | Value Derived From : Dim_W_RESOURCE_HD_ID.RESOURCE_ID |
| Resource | General - (Resource) | Resource Name | Dimension | The name of the resource | Value Derived From : Dim_W_RESOURCE_HD_ID.RESOURCE_NAME |
| Resource | General - (Resource) | Title | Dimension | The title of the resource | Value Derived From : Dim_W_RESOURCE_HD_ID.RESOURCE_TITLE |
| Resource | General - (Resource) | Resource Type | Dimension | Indicates whether the resource is labor, nonlabor, or material. | Value Derived From : Dim_W_RESOURCE_HD_ID.RESOURCE_TYPE |
| Resource | Codes - (Resource) | Resource Codes | |||
| Resource | Location - (Resource) | Resource Location | |||
| Resource | Location - (Resource) | Address Line 1 | Dimension | The first line of the address | Value Derived From : Dim_W_RESOURCE_HD_ID.ADDRESS_LINE1 |
| Resource | Location - (Resource) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_RESOURCE_HD_ID.ADDRESS_LINE2 |
| Resource | Location - (Resource) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.CITY_NAME |
| Resource | Location - (Resource) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.COUNTRY_CODE |
| Resource | Location - (Resource) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.COUNTRY_NAME |
| Resource | Location - (Resource) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.LATITUDE |
| Resource | Location - (Resource) | Location Name | Dimension | The name of the location | Value Derived From : Dim_W_RESOURCE_HD_ID.LOCATION_NAME |
| Resource | Location - (Resource) | Location Type | Dimension | Location Type | Value Derived From : Dim_W_RESOURCE_HD_ID.LOCATION_TYPE |
| Resource | Location - (Resource) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.LONGITUDE |
| Resource | Location - (Resource) | Municipality Name | Dimension | The municipality name for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.MUNICIPALITY_NAME |
| Resource | Location - (Resource) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.POSTAL_CODE |
| Resource | Location - (Resource) | State/Province Code | Dimension | The state abbreviation for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.STATE_CODE |
| Resource | Location - (Resource) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_RESOURCE_HD_ID.STATE_NAME |
| Time Folder | |||||
| Time | Interval | Interval | |||
| Time | Interval | Interval End Date | Dimension | The end date of the Interval (1/8/2013 12:00am) | Value Derived From : Dim_W_INTERVAL_D_Interval.END_DATE |
| Time | Interval | Interval Name | Dimension | Interval Name (2013-W01) | Value Derived From : Dim_W_INTERVAL_D_Interval.INTERVAL_NAME |
| Time | Interval | Interval Start Date | Dimension | The start date of the Interval (1/1/2013 12:00am) | Value Derived From : Dim_W_INTERVAL_D_Interval.START_DATE |
| Fact - Primavera - Burn Down Folder | |||||
| Fact - Primavera - Burn Down | Metrics | Metrics | |||
| Fact - Primavera - Burn Down | Metrics | Actual Reported Finish (Yesterday) | Fact | The number of activities whose Actual Finish date was one day ago | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.YDA_REPORTED_COMPLETE_CNT |
| Fact - Primavera - Burn Down | Metrics | Actual Reported Starts (Yesterday) | Fact | The number of activities whose Actual Start date was one day ago | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.YDA_REPORTED_START_CNT |
| Fact - Primavera - Burn Down | Metrics | Baseline Completed Count | Fact | The number of activities in Burn Down snapshot that are completed during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.BASE_COMPLETE_CNT |
| Fact - Primavera - Burn Down | Metrics | Baseline In Progress Count | Fact | The number of activities in Burn Down snapshot that are in progress during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.BASE_IN_PROGRESS_CNT |
| Fact - Primavera - Burn Down | Metrics | Baseline Not Started Count | Fact | The number of activities in Burn Down snapshot that are not started during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.BASE_NOT_START_CNT |
| Fact - Primavera - Burn Down | Metrics | Baseline Planned Finish Date | Fact | Activity Planned Finish Date as of baseline(T-0) date | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.BL_PLANNED_FINISH_DATE |
| Fact - Primavera - Burn Down | Metrics | Completed Count | Fact | The number of activities that are completed during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.COMPLETE_CNT |
| Fact - Primavera - Burn Down | Metrics | Emergent Remaining Count | Fact | The number of remaining In Progress and Not Started activities that did not exist in the Burn Down snapshot | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.EMERGENT_REMAINING_CNT |
| Fact - Primavera - Burn Down | Metrics | In Progress Count | Fact | The number of activities that are in progress during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.IN_PROGRESS_CNT |
| Fact - Primavera - Burn Down | Metrics | Emergent Count | Fact | The number of activities added that are not in Burn Down snapshot | sum(Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.EMERGENT_REMAINING_CNT) |
| Fact - Primavera - Burn Down | Metrics | Non-Emergent Remaining Count | Fact | The number of remaining In Progress and Not Started activities that existed in the Burn Down snapshot | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.NON_EMERGENT_REMAINING_CNT |
| Fact - Primavera - Burn Down | Metrics | Not Scheduled and Completed Count | Fact | The number of activities that were not scheduled to be completed based on the Burn Down snapshot and were actually completed during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.NOT_SCHEDULED_COMPLETED_CNT |
| Fact - Primavera - Burn Down | Metrics | Not Started Count | Fact | The number of activities that are not started during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.NOT_START_CNT |
| Fact - Primavera - Burn Down | Metrics | Schedule Freeze Planned Finish Date | Fact | Activity Planned Finish Date as of Schedule Freeze date | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.TF_PLANNED_FINISH_DATE |
| Fact - Primavera - Burn Down | Metrics | Scheduled and Completed Count | Fact | The number of activities that were scheduled to be completed based on the Burn Down snapshot and were actually completed during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.SCHEDULED_COMPLETED_CNT |
| Fact - Primavera - Burn Down | Metrics | Scheduled Finishes (Yesterday) | Fact | The number of activities whose Planned Finish date was one day ago | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.YDA_SCHEDULED_COMPLETE_CNT |
| Fact - Primavera - Burn Down | Metrics | Scheduled Finishes Today | Fact | The number of activities whose Finish date is today | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.TODAY_SCHEDULED_COMPLETE_CNT |
| Fact - Primavera - Burn Down | Metrics | Scheduled Finishes to Date | Fact | The number of activities whose Finish date is on or before the project Data Date | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.TO_DATE_SCHEDULED_COMPLETE_CNT |
| Fact - Primavera - Burn Down | Metrics | Scheduled Starts (Yesterday) | Fact | The number of activities whose Planned Start date was one day ago | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.YDA_SCHEDULED_START_CNT |
| Fact - Primavera - Burn Down | Metrics | Scheduled and Not Completed Count | Fact | The number of activities that were scheduled to be completed based on the Burn Down snapshot and were not completed during this time interval | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.SCHEDULED_NOT_COMPLETED_CNT |
| Fact - Primavera - Burn Down | Metrics | Update Time | Fact | The database time this ETL run started | Value Derived From : Fact_W_ACTIVITY_WORK_DOWN_HF_WDAct.UPDATE_TS |
| Fact - Primavera - Burn Down | Units | Units | |||
| Fact - Primavera - Burn Down | Units | Actual Period Units | Fact | The actual number of units incurred of current period | Value Derived From : Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.ACTUAL_PERIOD_UNITS |
| Fact - Primavera - Burn Down | Units | Actual Units | Fact | The actual number of units incurred | Value Derived From : Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.ACTUAL_UNITS |
| Fact - Primavera - Burn Down | Units | Actual Units Burn | Fact | The actual units distributed over the activity duration | Value Derived From : Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.ACTUAL_UNITS_BURN |
| Fact - Primavera - Burn Down | Units | Baseline Units | Fact | Planned Units from the Burn Down snapshot | Value Derived From : Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.BASELINE_UNITS |
| Fact - Primavera - Burn Down | Units | Baseline Remaining Units Burn | Fact | The expected remaining units distributed over the activity duration based on Burn Down snapshot | sum(Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.REMAINING_UNITS_BURN) |
| Fact - Primavera - Burn Down | Units | At Completion Units | Fact | The sum of the Actual Units plus Remaining Units | sum(Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.COMPLETE_UNITS) |
| Fact - Primavera - Burn Down | Units | Emergent Remaining Units Burn | Fact | Emergent activity remaining units distributed over the activity duration | Value Derived From : Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.EMERGENT_UNITS_BURN |
| Fact - Primavera - Burn Down | Units | Non-Emergent Remaining Units Burn | Fact | Non-Emergent activity remaining units distributed over the activity duration | Value Derived From : Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.NON_EMERGENT_UNITS_BURN |
| Fact - Primavera - Burn Down | 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_ASSIGNMENT_WORK_DOWN_HF_WDA.REMAINING_UNITS |
| Fact - Primavera - Burn Down | Units | Remaining Units Burn | Fact | The remaining units distributed over the activity duration | Value Derived From : Fact_W_ASSIGNMENT_WORK_DOWN_HF_WDA.REMAINING_UNITS_BURN |