This cube dimension represents work order information and is based on the IFS Applications dimension DIM_WORK_TASK.
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 |
Cube Name |
MAINTENANCE |
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 |