This cube dimension represents a labor class dimension describing different types of emploees and is based on the IFS Applications dimension DIM_LABOR_CLASS. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Labor Class | NO | Key. The attribute is built up as Site No - Labor Class No - Description. |
Labor Class - Last Loaded | NO | ETL process date. |
Labor Class Description | NO | Description of the labor class. Eg Operator, Supervisor etc. |
Labor Class No | NO | Labor class number |
Labor Class Site | NO | Site code of the labor class. |
LaborClassHy | YES | Hierarchy defined as "Labor Class Site" -> "Labor Class" |
Cube Name |
MANUFACTURING |
BI Access View | BI Component | Recommended Source Type |
DIM_BI_TIME_BI | APPSDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.112 Load IFSAppl_DIM_LABOR_CLASS_BI.dtsx | IFSAppl_DIM_LABOR_CLASS_BI |
T - DW | 2.1.112 Load Dw_DIM_LABOR_CLASS.dtsx | Dw_DIM_LABOR_CLASS |
L - DM | 3.1.112 Load Dm_DIM_LABOR_CLASS.dtsx | Dm_DIM_LABOR_CLASS |