CUBE DIMENSION - WORK TASK

This cube dimension represents work order information and is based on the IFS Applications dimension DIM_WORK_TASK.

ATTRIBUTES

Attribute Hierarchy Description
Work Task No NO Key. Work Task Number
Order No NO Work Task Seq
Work Order No NO Work Order Number
Work Task - Order No NO Work Task Number - Sequence
Site Code NO Code of Site

USED BY CUBE

Cube Name
MAINTENANCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_WORK_TASK_BI WODI Data Mart

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.193 Load IFSAppl_DIM_WORK_TASK_BI.dtsx IFSAppl_DIM_WORK_TASK_BI
T - DW 2.1.193 Load Dw_DIM_WORK_TASK.dtsx Dw_DIM_WORK_TASK
L - DM 3.1.193 Load Dm_DIM_WORK_TASK.dtsx Dm_DIM_WORK_TASK