Unifier - Workflow / Primavera - Workflow

Description: Use this subject area to analyze the costs, budget, and duration to assess the efficiency of workflows associated with business processes of projects.

Folder	SubFolder	Field Name	Dimension/ Fact / Lookup	Description (From Table)	Values Derived From / Calculated By
Workflow	Dates - (Workflow)			Workflow Dates
Workflow	Dates - (Workflow)	Step End Date	Dimension	The end date of the workflow step	Value Derived From : Dim_W_WORKFLOW_STEP_D_Workflow_Step.STEP_END_DATE
Workflow	Dates - (Workflow)	Step Start Date	Dimension	The start date of the workflow step	Value Derived From : Dim_W_WORKFLOW_STEP_D_Workflow_Step.STEP_START_DATE
Workflow	Dates - (Workflow)	Task Due Date	Dimension	The due date of the workflow task	Value Derived From : Dim_W_WORKFLOW_TASK_D_Workflow_Task.TASK_DUE_DATE
Workflow	Dates - (Workflow)	Task End Date	Dimension	The end date of the workflow task	Value Derived From : Dim_W_WORKFLOW_TASK_D_Workflow_Task.TASK_END_DATE
Workflow	Dates - (Workflow)	Task Start Date	Dimension	The start date of the workflow task	Value Derived From : Dim_W_WORKFLOW_TASK_D_Workflow_Task.TASK_START_DATE
Workflow	Dates - (Workflow)	Workflow Due Date	Dimension	The due date of the workflow	Value Derived From : Dim_W_WORKFLOW_PROCESS_D_Workflow_Process.PROCESS_DUE_DATE
Workflow	Dates - (Workflow)	Workflow End Date	Dimension	The end date of the workflow	Value Derived From : Dim_W_WORKFLOW_PROCESS_D_Workflow_Process.PROCESS_END_DATE
Workflow	Dates - (Workflow)	Workflow Start Date	Dimension	The start date of the workflow	Value Derived From : Dim_W_WORKFLOW_PROCESS_D_Workflow_Process.PROCESS_START_DATE
Workflow	General - (Workflow)			General Workflow
Workflow	General - (Workflow)	Current Step Name	Dimension	The status of the workflow process	Value Derived From : Dim_W_WORKFLOW_PROCESS_D_Workflow_Process.CURRENT_STEP_NAME
Workflow	General - (Workflow)	Setup Name	Dimension	The setup name of the workflow	Value Derived From : Dim_W_WORKFLOW_PROCESS_D_Workflow_Process.PROCESS_NAME
Workflow	General - (Workflow)	Workflow Name	Dimension	The name of the business process	Value Derived From : Dim_W_WORKFLOW_D_Workflow.WORKFLOW_NAME
Workflow	General - (Workflow)	Unique Workflow Object Id	Dimension	The unique ID of the workflow	Value Derived From : Dim_W_WORKFLOW_D_Workflow.WORKFLOW_OBJECT_ID
Workflow	General - (Workflow)	Workflow Process Status	Dimension	The status of the workflow process	Value Derived From : Dim_W_WORKFLOW_PROCESS_D_Workflow_Process.PROCESS_STATUS
Workflow	Step - (Workflow)			Workflow Steps
Workflow	Step - (Workflow)	Step Completion Policy	Dimension	The completion policy of the workflow step	Value Derived From : Dim_W_WORKFLOW_STEP_D_Workflow_Step.STEP_COMPLETION_POLICY
Workflow	Step - (Workflow)	Step Id	Dimension	The ID of the workflow step	Value Derived From : Dim_W_WORKFLOW_STEP_D_Workflow_Step.STEP_ID
Workflow	Step - (Workflow)	Step Name	Dimension	The name of the workflow step	Value Derived From : Dim_W_WORKFLOW_STEP_D_Workflow_Step.STEP_NAME
Workflow	Step - (Workflow)	Step Sequence	Dimension	The sequence of the workflow step	Value Derived From : Dim_W_WORKFLOW_STEP_D_Workflow_Step.STEP_SEQUENCE
Workflow	Step - (Workflow)	Step Status	Dimension	The status of the workflow step	Value Derived From : Dim_W_WORKFLOW_STEP_D_Workflow_Step.STEP_STATUS
Workflow	Step - (Workflow)	Step Type	Dimension	The type of the workflow step	Value Derived From : Dim_W_WORKFLOW_STEP_D_Workflow_Step.STEP_TYPE
Workflow	Task - (Workflow)			Workflow Tasks
Workflow	Task - (Workflow)	Assignee	Dimension	The full name of the workflow task assignee	Value Derived From : Dim_W_WORKFLOW_TASK_D_Workflow_Task.ASSIGNEE_FULLNAME
Workflow	Task - (Workflow)	Assignee Company	Dimension	The full name of the workflow task assignee's company	Value Derived From : Dim_W_WORKFLOW_TASK_D_Workflow_Task.ASSIGNEE_COMPANY_FULLNAME
Workflow	Task - (Workflow)	Task Action Name	Dimension	The name of the workflow task action	Value Derived From : Dim_W_WORKFLOW_TASK_D_Workflow_Task.TASK_ACTION_NAME
Workflow	Task - (Workflow)	Task Status	Dimension	The status of the workflow task	Value Derived From : Dim_W_WORKFLOW_TASK_D_Workflow_Task.TASK_STATUS

Fact - Primavera - Workflow Folder
Fact - Primavera - Workflow	Durations - (Workflow)			Workflow Durations
Fact - Primavera - Workflow	Durations - (Workflow)	Workflow Actual Duration	Fact	The actual duration of the workflow	Calculated by: sum(Fact_W_WORKFLOW_F_Workflow.WF_ACTUAL_DURATION_S)
Fact - Primavera - Workflow	Durations - (Workflow)	Workflow Planned Duration	Fact	The planned duration of the workflow	Calculated by: sum(Fact_W_WORKFLOW_F_Workflow.WF_PLANNED_DURATION_S)
Fact - Primavera - Workflow	Metrics			Metrics
Fact - Primavera - Workflow	Metrics	# Of Steps	Fact	# Of Steps	Calculated by: count(distinct Fact_W_WORKFLOW_F_Workflow.STEP_WID)
Fact - Primavera - Workflow	Metrics	# Of Tasks	Fact	# Of Tasks	Calculated by: count(distinct Fact_W_WORKFLOW_F_Workflow.TASK_WID)
Fact - Primavera - Workflow	Metrics	# Of Workflows	Fact	# Of Workflows	Calculated by: count(distinct Fact_W_WORKFLOW_F_Workflow.WORKFLOW_WID)

Unifier Links Folder
Unifier Links				Go to Unifier Links
Unifier Links		Link to BP Log	Dimension	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	Dimension	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 Project	Dimension	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>'

Related Topics