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

Related Topics