Unifier - Business Process History / Primavera - Business Process History
Description: Use this subject area to analyze weekly historical business process facts to better understand changes over time. Note that dimensional business process history is not supported.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Project | Budget - (Project) | Project Budget | |||
| Project | Budget - (Project) | Current Budget | Dimension | Project Current Budget. Typically used by P6 but can also be used by Unifier | Value Derived From : Dim_W_PROJECT_D_Project.CURRENT_BUDGET |
| Project | Budget - (Project) | Original Budget | Dimension | Project Original Budget. Typically used by P6 but can also be used by Unifier | Value Derived From : Dim_W_PROJECT_D_Project.ORIGINAL_BUDGET |
| Project | Budget - (Project) | Proposed Budget | Dimension | Project Proposed Budget. Typically used by P6 but can also be used by Unifier | Value Derived From : Dim_W_PROJECT_D_Project.PROPOSED_BUDGET |
| Project | Dates - (Project) | Project Dates | |||
| Project | Dates - (Project) | Anticipated Finish | Dimension | Project Anticipated Finish Date | Value Derived From : Dim_W_PROJECT_D_Project.ANTICIPATED_FINISH_DATE |
| Project | Dates - (Project) | Anticipated Start | Dimension | Project Anticipated Start Date | Value Derived From : Dim_W_PROJECT_D_Project.ANTICIPATED_START_DATE |
| Project | Dates - (Project) | Date Added | Dimension | The date this project was added | Value Derived From : Dim_W_PROJECT_D_Project.ADD_DATE |
| Project | Dates - (Project) | Finish | Dimension | The current finish date of the project | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_FINISH_DATE |
| Project | Dates - (Project) | Forecast Finish Date | Dimension | Project Forecasted Finish Date. Typically used by P6 but can also be used by Unifier | Value Derived From : Dim_W_PROJECT_D_Project.FORECAST_FINISH_DATE |
| Project | Dates - (Project) | Forecast Start Date | Dimension | Project Forecasted Start Date. Typically used by P6 but can also be used by Unifier | Value Derived From : Dim_W_PROJECT_D_Project.FORECAST_START_DATE |
| Project | Dates - (Project) | Planned Finish | Dimension | Project Planned Finish Date. Typically used by P6 but can also be used by Unifier | Value Derived From : Dim_W_PROJECT_D_Project.PLANNED_FINISH_DATE |
| Project | Dates - (Project) | Planned Start | Dimension | Project Planned Start Date. Typically used by P6 but can also be used by Unifier | Value Derived From : Dim_W_PROJECT_D_Project.PLANNED_START_DATE |
| Project | Dates - (Project) | Scheduled Finish | Dimension | Project Scheduled Finish Date. Typically used by P6 but can also be used by Unifier | Value Derived From : Dim_W_PROJECT_D_Project.SCHEDULED_FINISH_DATE |
| Project | Dates - (Project) | Start | Dimension | The current start date of the project. | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_START_DATE |
| Project | General - (Project) | General Project Information | |||
| Project | General - (Project) | Base Currency | Dimension | The base currency | Value Derived From : Dim_W_PROJECT_HD_Project.BASE_CURRENCY |
| 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_Project.DATASOURCE_ID |
| Project | General - (Project) | Project Currency | Dimension | The project currency | Value Derived From : Dim_W_PROJECT_HD_Project.DEFAULT_CURRENCY |
| Project | General - (Project) | Project Id | Dimension | The Project Id of the project | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_ID |
| Project | General - (Project) | Project Name | Dimension | The project name | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_NAME |
| Project | General - (Project) | Unique Project ID | Dimension | The Unique ID of the project | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_OBJECT_ID |
| Project | General - (Project) | Project Owner | Dimension | Designated as owner of the project | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_OWNER |
| Project | General - (Project) | Project Phase | Dimension | The phase of the project | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_PHASE |
| Project | General - (Project) | Project Type | Dimension | The type of the project | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_TYPE |
| 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_Project.PROJECT_STATUS |
| 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_Project.ADDRESS_LINE1 |
| Project | Location - (Project) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_PROJECT_HD_Project.ADDRESS_LINE2 |
| Project | Location - (Project) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.CITY_NAME |
| Project | Location - (Project) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.COUNTRY_CODE |
| Project | Location - (Project) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.COUNTRY_NAME |
| Project | Location - (Project) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.LATITUDE |
| Project | Location - (Project) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.LONGITUDE |
| Project | Location - (Project) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.POSTAL_CODE |
| Project | Location - (Project) | State/Province Code | Dimension | The state code for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.STATE_CODE |
| Project | Location - (Project) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.STATE_NAME |
| Business Process Folder | |||||
| Business Process | Change Order - (BP) | Change Order BP | |||
| Business Process | Change Order - (BP) | Reason | Dimension | The reason for a change order to be raised | Value Derived From : Dim_W_BP_D_Business_Process.REASON |
| Business Process | Contract - (BP) | Contract BP | |||
| Business Process | Contract - (BP) | Contract Type | Dimension | The type of contract | Value Derived From : Dim_W_BP_D_Business_Process.CONTRACT_TYPE |
| Business Process | Dates - (BP) | Dates BP | |||
| Business Process | Dates - (BP) | Completion Date | Dimension | The date the business process record reaches that last step in the workflow | Value Derived From : Dim_W_BP_D_Business_Process.COMPLETION_DATE |
| Business Process | Dates - (BP) | Creation Date | Dimension | The date of creation of the business process record | Value Derived From : Dim_W_BP_D_Business_Process.CREATION_DATE |
| Business Process | Dates - (BP) | Due Date | Dimension | The date when the business process record is due. Calculated based on the workflow duration specified in the business process setup or could be a user specified value | Value Derived From : Dim_W_BP_D_Business_Process.DUE_DATE |
| Business Process | Dates - (BP) | Send Date | Dimension | The date when the business process record was sent to the next step in the workflow | Value Derived From : Dim_W_BP_D_Business_Process.SEND_DATE |
| Business Process | General - (BP) | General BP | |||
| Business Process | General - (BP) | Business Process Name | Dimension | The name of the business process | Value Derived From : Dim_W_BP_D_Business_Process.BP_NAME |
| Business Process | General - (BP) | Business Process Type | Dimension | The type of the business process | Value Derived From : Dim_W_BP_D_Business_Process.BP_TYPE |
| Business Process | General - (BP) | Company BP | Dimension | Identifies if this is a Company level BP | Value Derived From : Dim_W_BP_D_Business_Process.COMPANY_BP |
| Business Process | General - (BP) | 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_BP_D_Business_Process.DATASOURCE_ID |
| Business Process | General - (BP) | Record Number | Dimension | The record number of the business process record | Value Derived From : Dim_W_BP_D_Business_Process.RECORD_NO |
| Business Process | General - (BP) | Single Record | Dimension | Identifies if this is a Company level BP | Value Derived From : Dim_W_BP_D_Business_Process.SINGLE_RECORD |
| Business Process | General - (BP) | Specification Section | Dimension | The specification section related to the business process record | Value Derived From : Dim_W_BP_D_Business_Process.SPEC_SECTION |
| Business Process | General - (BP) | Status | Dimension | The status of the business process record | Value Derived From : Dim_W_BP_D_Business_Process.STATUS |
| Business Process | General - (BP) | Title | Dimension | The title of the business process record | Value Derived From : Dim_W_BP_D_Business_Process.TITLE |
| Business Process | Business Process Line Item | Dimension | General BP Line Item | ||
| Business Process | Business Process Line Item | Line Description | Dimension | The short description of a line item in the business process record | Value Derived From : Dim_W_BP_LINE_HD_Business_Process_Line.LINE_DESC |
| Business Process | Business Process Line Item | Line Number | Dimension | The line number of a line item in the business process record | Value Derived From : Dim_W_BP_LINE_HD_Business_Process_Line.LINE_NUMBER |
| Business Process | Business Process Line Item | Line Tab | Dimension | The line item tab of the business process record | Value Derived From : Dim_W_BP_LINE_HD_Business_Process_Line.LINE_TAB |
| Business Process | Business Process Line Item | Spend Category | Dimension | The category of spend (e.g. labor, material) of a line item in the business process record | Value Derived From : Dim_W_BP_LINE_HD_Business_Process_Line.SPEND_CATEGORY |
| Business Process | Business Process Line Item | Unit Cost | Dimension | The unit cost of a line item in the business process record, in conjunction with Quantity and Unit of Measure | Value Derived From : Dim_W_BP_LINE_HD_Business_Process_Line.UNIT_PRICE |
| Business Process | Business Process Line Item | Unit of Measure | Dimension | The unit of measure of a line item in the business process record | Value Derived From : Dim_W_BP_LINE_HD_Business_Process_Line.UNIT_OF_MEASURE |
| Business Process | Vendor - (BP) | Vendor BP | |||
| Business Process | Vendor - (BP) | Vendor Id | Dimension | The reference of the Vendor associated with the business process record | Value Derived From : Dim_W_VENDOR_D_Vendor.VENDOR_ID |
| Business Process | Vendor - (BP) | Vendor Name | Dimension | The name of the Vendor associated with the business process record | Value Derived From : Dim_W_VENDOR_D_Vendor.VENDOR_NAME |
| Business Process | Vendor - (BP) | Vendor Type | Dimension | The Type of the Vendor associated with the business process record | Value Derived From : Dim_W_VENDOR_D_Vendor.VENDOR_TYPE |
| Fact - Primavera - Business Process History Folder | |||||
| Fact - Primavera - Business Process History | Costs | Costs | |||
| Fact - Primavera - Business Process History | Costs | Amount | Fact | The amount for each line item. Calculated as the product of unit cost and quantity or could be a manual entry | indexcol( case VALUEOF(NQ_SESSION.CURRENCY_TYPE) when 'Base' then 0 when 'Project' then 1 end , sum(Fact_W_BP_LINE_HIST_F_Business_Process_Line_History.AMOUNT), sum(Fact_W_BP_LINE_HIST_F_Business_Process_Line_History.AMOUNT_P)) |
| Fact - Primavera - Business Process History | Metrics | Metrics | |||
| Fact - Primavera - Business Process History | Metrics | # Of BP Line Items | Fact | The total count of a specific Business Process History | count(distinct case when Fact_W_BP_LINE_HIST_F_Business_Process_Line_History.BP_LINE_WID > 0 then Fact_W_BP_LINE_HIST_F_Business_Process_Line_History.BP_LINE_WID else NULL end ) |
| Fact - Primavera - Business Process History | Metrics | # Of BP Records | Fact | The total count of a specific Business Process History | count(distinct Fact_W_BP_LINE_HIST_F_Business_Process_Line_History.BP_WID) |
| Fact - Primavera - Business Process History | Metrics | Item Quantity | Fact | The quantity of a line item in a Business Process History record | sum(Fact_W_BP_LINE_HIST_F_Business_Process_Line_History.QUANTITY) |
| Portfolio Folder | |||||
| Portfolio | Portfolios consist of projects grouped together in a meaningful way. Portfolios are used to do project analysis across the enterprise. | ||||
| Portfolio | Project Portfolio Name | Dimension | The name of the portfolio | Value Derived From : Dim_W_PROJECT_PORTFOLIO_D_Project_Portfolio_ID.PROJECT_PORTFOLIO_NAME | |
| Portfolio | Project Portfolio Status | Dimension | The status of the portfolio | Value Derived From : Dim_W_PROJECT_PORTFOLIO_D_Project_Portfolio_ID.PROJECT_PORTFOLIO_STATUS |