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>'
|