Unifier - Business Process / Primavera - Business Process
Description: Use this subject area to analyze cost and non-cost line items in business processes.
| 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 | |
| Cost Breakdown Structure Folder | ||||||
| Cost Breakdown Structure | General - (CBS) | CBS General | ||||
| Cost Breakdown Structure | General - (CBS) | CBS Code | Dimension | The full cost code from the Unifier cost sheet | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE | |
| Cost Breakdown Structure | General - (CBS) | CBS Name | Dimension | The name of the CBS element | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME | |
| Cost Breakdown Structure | General - (CBS) | Cost Status | Dimension | The status of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_STATUS | |
| Cost Breakdown Structure | General - (CBS) | Cost Type | Dimension | The type associated to the cost code. This is typically capital or expense | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_TYPE | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Hierarchy | ||||
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 1 | Dimension | The cost code at the first level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV1 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 10 | Dimension | The cost code at the tenth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV10 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 2 | Dimension | The cost code at the second level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV2 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 3 | Dimension | The cost code at the third level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV3 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 4 | Dimension | The cost code at the fourth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV4 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 5 | Dimension | The cost code at the fifth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV5 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 6 | Dimension | The cost code at the sixth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV6 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 7 | Dimension | The cost code at the seventh level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV7 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 8 | Dimension | The cost code at the eighth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV8 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Code Level 9 | Dimension | The cost code at the nineth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_CODE_LV9 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 1 | Dimension | The cost code name at the first level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV1 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 10 | Dimension | The cost code name at the tenth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV10 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 2 | Dimension | The cost code name at the second level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV2 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 3 | Dimension | The cost code name at the third level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV3 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 4 | Dimension | The cost code name at the fourth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV4 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 5 | Dimension | The cost code name at the fifth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV5 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 6 | Dimension | The cost code name at the sixth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV6 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 7 | Dimension | The cost code name at the seventh level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV7 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 8 | Dimension | The cost code name at the eighth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV8 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | CBS Name Level 9 | Dimension | The cost code name at the ninth level of detail | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_NAME_LV9 | |
| Cost Breakdown Structure | Hierarchy - (CBS) | Root CBS Code | Dimension | The root cost code in the cost code hierarchy | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.ROOT_LEVEL_CODE | |
| Cost Breakdown Structure | Hierarchy - (CBS) | Root CBS Name | Dimension | The root cost code name in the cost code hierarchy | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.ROOT_LEVEL_NAME | |
| Cost Breakdown Structure | Segment - (CBS) | |||||
| Cost Breakdown Structure | Segment - (CBS) | Segment 1 | Dimension | Segment 1 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG1_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 10 | Dimension | Segment 10 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG10_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 2 | Dimension | Segment 2 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG2_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 3 | Dimension | Segment 3 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG3_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 4 | Dimension | Segment 4 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG4_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 5 | Dimension | Segment 5 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG5_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 6 | Dimension | Segment 6 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG6_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 7 | Dimension | Segment 7 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG7_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 8 | Dimension | Segment 8 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG8_CODE | |
| Cost Breakdown Structure | Segment - (CBS) | Segment 9 | Dimension | Segment 9 of the cost code | Value Derived From : Dim_W_CBS_HIERARCHY_D_CbsHier.CBS_SEG9_CODE | |
| 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 | 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 Folder | ||||||
| Fact - Primavera - Business Process | Costs | Costs | ||||
| Fact - Primavera - Business Process | 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 , Amount (Base):[DAggr(Fact - Business Process.Amount (Base))], Amount (Project):[DAggr(Fact - Business Process.Amount (Project))]) | |
| Fact - Primavera - Business Process | Metrics | Metrics | ||||
| Fact - Primavera - Business Process | Metrics | # Of BP Line Items | Fact | The total line item count of a specific business process | count(distinct case when Fact_W_BP_LINE_F_Business_Process_Line.BP_LINE_WID > 0 then Fact_W_BP_LINE_F_Business_Process_Line.BP_LINE_WID else NULL end ) | |
| Fact - Primavera - Business Process | Metrics | # Of BP Records | Fact | The total count of a specific business process | count(distinct Fact_W_BP_LINE_F_Business_Process_Line.BP_WID) | |
| Fact - Primavera - Business Process | Metrics | Item Quantity | Fact | The quantity of a line item in a business process record | sum(Fact_W_BP_LINE_F_Business_Process_Line.QUANTITY) | |
| Project Folder | ||||||
| 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 - (BP) | General BP | ||||
| Project | General - (BP) | Business Process Name | Dimension | The name of the business process | Value Derived From : Dim_W_BP_D_Business_Process.BP_NAME | |
| Project | General - (BP) | Business Process Type | Dimension | The type of the business process | Value Derived From : Dim_W_BP_D_Business_Process.BP_TYPE | |
| Project | General - (BP) | Company BP | Dimension | Identifies if this is a Company level BP | Value Derived From : Dim_W_BP_D_Business_Process.COMPANY_BP | |
| Project | 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 | |
| Project | General - (BP) | Record Number | Dimension | The record number of the business process record | Value Derived From : Dim_W_BP_D_Business_Process.RECORD_NO | |
| Project | General - (BP) | Single Record | Dimension | Identifies if this is a Company level BP | Value Derived From : Dim_W_BP_D_Business_Process.SINGLE_RECORD | |
| Project | 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 | |
| Project | General - (BP) | Status | Dimension | The status of the business process record | Value Derived From : Dim_W_BP_D_Business_Process.STATUS | |
| Project | General - (BP) | Title | Dimension | The title of the business process record | Value Derived From : Dim_W_BP_D_Business_Process.TITLE | |
| Project | General - (Project) | General Project Information | ||||
| Project | General - (Project) | Base Currency | Dimension | The base currency | Value Derived From : Dim_W_PROJECT_D_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_D_Project.DATASOURCE_ID | |
| Project | General - (Project) | Project Currency | Dimension | The project currency | Value Derived From : Dim_W_PROJECT_D_Project.DEFAULT_CURRENCY | |
| Project | General - (Project) | Project Id | Dimension | The Project Id of the project | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_ID | |
| Project | General - (Project) | Project Name | Dimension | The project name | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_NAME | |
| Project | General - (Project) | Unique Project ID | Dimension | The Unique ID of the project | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_OBJECT_ID | |
| Project | General - (Project) | Project Owner | Dimension | Designated as owner of the project | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_OWNER | |
| Project | General - (Project) | Project Phase | Dimension | The phase of the project | Value Derived From : Dim_W_PROJECT_D_Project.PROJECT_PHASE | |
| Project | General - (Project) | Project Type | Dimension | The type of the project | Value Derived From : Dim_W_PROJECT_D_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_D_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_D_Project.ADDRESS_LINE1 | |
| Project | Location - (Project) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_PROJECT_D_Project.ADDRESS_LINE2 | |
| Project | Location - (Project) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_PROJECT_D_Project.CITY_NAME | |
| Project | Location - (Project) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_PROJECT_D_Project.COUNTRY_CODE | |
| Project | Location - (Project) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_PROJECT_D_Project.COUNTRY_NAME | |
| Project | Location - (Project) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_PROJECT_D_Project.LATITUDE | |
| Project | Location - (Project) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_PROJECT_D_Project.LONGITUDE | |
| Project | Location - (Project) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_PROJECT_D_Project.POSTAL_CODE | |
| Project | Location - (Project) | State/Province Code | Dimension | The state code for this Location | Value Derived From : Dim_W_PROJECT_D_Project.STATE_CODE | |
| Project | Location - (Project) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_PROJECT_D_Project.STATE_NAME | |
| Business Process Line Item Folder | ||||||
| Business Process Line Item | General - (BP Line Item) | General BP Line Item | ||||
| Business Process Line Item | General - (BP Line Item) | Line Description | Dimension | The short description of a line item in the business process record | Value Derived From : Dim_W_BP_LINE_D_Business_Process_Line.LINE_DESC | |
| Business Process Line Item | General - (BP Line Item) | Line Number | Dimension | The line number of a line item in the business process record | Value Derived From : Dim_W_BP_LINE_D_Business_Process_Line.LINE_NUMBER | |
| Business Process Line Item | General - (BP Line Item) | Line Tab | Dimension | The line item tab of the business process record | Value Derived From : Dim_W_BP_LINE_D_Business_Process_Line.LINE_TAB | |
| Business Process Line Item | General - (BP 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_D_Business_Process_Line.SPEND_CATEGORY | |
| Business Process Line Item | General - (BP 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_D_Business_Process_Line.UNIT_PRICE | |
| Business Process Line Item | General - (BP 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_D_Business_Process_Line.UNIT_OF_MEASURE | |
| Project Hierarchy Folder | ||||||
| Project Hierarchy | The hierarchical project structure | |||||
| Project Hierarchy | Full Path Name | Dimension | Full Path Name | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_FP | ||
| Project Hierarchy | Project Hierarchy Id Level 1 | Dimension | Project Hierarchy Id Level 1 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV1 | ||
| Project Hierarchy | Project Hierarchy Id Level 10 | Dimension | Project Hierarchy Id Level 10 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV10 | ||
| Project Hierarchy | Project Hierarchy Id Level 11 | Dimension | Project Hierarchy Id Level 11 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV11 | ||
| Project Hierarchy | Project Hierarchy Id Level 12 | Dimension | Project Hierarchy Id Level 12 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV12 | ||
| Project Hierarchy | Project Hierarchy Id Level 13 | Dimension | Project Hierarchy Id Level 13 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV13 | ||
| Project Hierarchy | Project Hierarchy Id Level 14 | Dimension | Project Hierarchy Id Level 14 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV14 | ||
| Project Hierarchy | Project Hierarchy Id Level 15 | Dimension | Project Hierarchy Id Level 15 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV15 | ||
| Project Hierarchy | Project Hierarchy Id Level 16 | Dimension | Project Hierarchy Id Level 16 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV16 | ||
| Project Hierarchy | Project Hierarchy Id Level 17 | Dimension | Project Hierarchy Id Level 17 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV17 | ||
| Project Hierarchy | Project Hierarchy Id Level 2 | Dimension | Project Hierarchy Id Level 2 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV2 | ||
| Project Hierarchy | Project Hierarchy Id Level 3 | Dimension | Project Hierarchy Id Level 3 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV3 | ||
| Project Hierarchy | Project Hierarchy Id Level 4 | Dimension | Project Hierarchy Id Level 4 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV4 | ||
| Project Hierarchy | Project Hierarchy Id Level 5 | Dimension | Project Hierarchy Id Level 5 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV5 | ||
| Project Hierarchy | Project Hierarchy Id Level 6 | Dimension | Project Hierarchy Id Level 6 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV6 | ||
| Project Hierarchy | Project Hierarchy Id Level 7 | Dimension | Project Hierarchy Id Level 7 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV7 | ||
| Project Hierarchy | Project Hierarchy Id Level 8 | Dimension | Project Hierarchy Id Level 8 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV8 | ||
| Project Hierarchy | Project Hierarchy Id Level 9 | Dimension | Project Hierarchy Id Level 9 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_ID_LV9 | ||
| Project Hierarchy | Project Hierarchy Name Level 1 | Dimension | Project Hierarchy Name Level 1 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV1 | ||
| Project Hierarchy | Project Hierarchy Name Level 10 | Dimension | Project Hierarchy Name Level 10 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV10 | ||
| Project Hierarchy | Project Hierarchy Name Level 11 | Dimension | Project Hierarchy Name Level 11 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV11 | ||
| Project Hierarchy | Project Hierarchy Name Level 12 | Dimension | Project Hierarchy Name Level 12 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV12 | ||
| Project Hierarchy | Project Hierarchy Name Level 13 | Dimension | Project Hierarchy Name Level 13 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV13 | ||
| Project Hierarchy | Project Hierarchy Name Level 14 | Dimension | Project Hierarchy Name Level 14 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV14 | ||
| Project Hierarchy | Project Hierarchy Name Level 15 | Dimension | Project Hierarchy Name Level 15 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV15 | ||
| Project Hierarchy | Project Hierarchy Name Level 16 | Dimension | Project Hierarchy Name Level 16 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV16 | ||
| Project Hierarchy | Project Hierarchy Name Level 17 | Dimension | Project Hierarchy Name Level 17 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV17 | ||
| Project Hierarchy | Project Hierarchy Name Level 2 | Dimension | Project Hierarchy Name Level 2 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV2 | ||
| Project Hierarchy | Project Hierarchy Name Level 3 | Dimension | Project Hierarchy Name Level 3 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV3 | ||
| Project Hierarchy | Project Hierarchy Name Level 4 | Dimension | Project Hierarchy Name Level 4 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV4 | ||
| Project Hierarchy | Project Hierarchy Name Level 5 | Dimension | Project Hierarchy Name Level 5 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV5 | ||
| Project Hierarchy | Project Hierarchy Name Level 6 | Dimension | Project Hierarchy Name Level 6 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV6 | ||
| Project Hierarchy | Project Hierarchy Name Level 7 | Dimension | Project Hierarchy Name Level 7 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV7 | ||
| Project Hierarchy | Project Hierarchy Name Level 8 | Dimension | Project Hierarchy Name Level 8 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV8 | ||
| Project Hierarchy | Project Hierarchy Name Level 9 | Dimension | Project Hierarchy Name Level 9 | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.EPS_NAME_LV9 | ||
| Project Hierarchy | Project ID (Root Level) | Dimension | A short code which uniquely identifies the root level Project | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.ROOT_LEVEL_SHORT_NAME | ||
| Project Hierarchy | Project Name (Root Level) | Dimension | The name of the root level of the project hierarchy | Value Derived From : Dim_W_EPS_HIERARCHY_D_EpsHier.ROOT_LEVEL_NAME | ||
| 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.PROJECT_PORTFOLIO_NAME | ||
| Portfolio | Project Portfolio Status | Dimension | The status of the portfolio | Value Derived From : Dim_W_PROJECT_PORTFOLIO_D_Project_Portfolio.PROJECT_PORTFOLIO_STATUS | ||
| Unifier Links Folder | ||||||
| Unifier Links | Go to Unifier Links | |||||
| Unifier Links | Link to BP Log | Lookup | The link to the business process log in Unifier | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Business Process"."Project Object Id" AS VARCHAR ( 10 )) || '&k=' || CAST ("P6Core"."Dim - Business Process"."Unifier BP Prefix" AS VARCHAR ( 10 )) || '">' || 'Link to BP Log' || '</a>' | ||
| Unifier Links | Link to BP Record | Lookup | The link to the business process log in Unifier | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Business Process"."Project Object Id" AS VARCHAR ( 10 )) || '&k=' || CAST ("P6Core"."Dim - Business Process"."Unifier BP Prefix" AS VARCHAR ( 10 )) || CASE WHEN "P6Core"."Dim - Business Process"."Single Record" = 1 THEN '&t=single' ELSE '&id=' || CAST ("P6Core"."Dim - Business Process"."Unifier Record Id" AS VARCHAR ( 10 )) END || '">' || 'Link to BP Record' || '</a>' | ||
| Unifier Links | Link to Cash Flow Log | Lookup | The link to the cash flow log in Unifier | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) || '&k=analyticscashflow">' || 'Link to Cash Flow Log' || '</a>' | ||
| Unifier Links | Link to Cost Sheet Log | Lookup | The link to the cost sheet log in Unifier | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) || '&k=analyticscost">' || 'Link to Cost Sheet Log' || '</a>' | ||
| Unifier Links | Link to Project | Lookup | The link to the project landing page in Unifier | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) || '&k=analyticsproject">' || 'Link to Project' || '</a>' | ||