Cube Dimension - Labor Class

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.

 

ATTRIBUTES

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"

USED BY CUBE

Cube Name
MANUFACTURING

ETL Information

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