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

Related Topics