This cube dimension represents work centers and is based on the IFS Applications view WORK_CENTER. There is no core dimension that supports this information. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is contract, i.e. a contract has work centers.
Attribute | Hierarchy | Description |
Calendar | NO | Work time calendar identity (CALENDAR_ID) |
Department | NO | Department description based on CONTRACT and DEPARTMENT_NO |
Work Center | NO | Key. Built as WORK_CENTER_NO + ' - ' + DESCRIPTION |
Work Center Description | NO | Description of the work center (DESCRIPTION) |
Work Center No | NO | Work center number (WORK_CENTER_NO) |
Cube Name |
MANUFACTURING |
BI Access View | BI Component | Recommended Source Type |
WORK_CENTER_BIV | MFGSDI | VIEW |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.104 Load IFSAppl_DIM_WORK_CENTER_BI.dtsx | IFSAppl_DIM_WORK_CENTER_BI |
T - DW | 2.1.104 Load Dw_DIM_WORK_CENTER.dtsx | Dw_DIM_WORK_CENTER |
L - DM | 3.1.104 Load Dm_DIM_WORK_CENTER.dtsx | Dm_DIM_WORK_CENTER |