Cube Dimension - Employment

This cube dimension represents the human resouces dimension employee duration and is based on the IFS Applications dimension DIM_EMPLOYMENT.

ATTRIBUTES

Attribute Hierarchy Description
Company NO Represents the parent key COMPANY
Company - Employee No NO Built as COMPANY || ' - ' || EMPLOYEE_NUMBER
Employee No NO Represents a persons employee number
Employee Agreement NO Represents the agreement for an employee
Employment Type NO Represents the type of employment
Reson for Leaving NO Represents the reson for leaving 

USED BY CUBE

Cube Name
HUMAN RESOURCES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_EMPLOYMENT_BI PERSDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.091 Load IFSAppl_DIM_EMPLOYMENT_BI.dtsx IFSAppl_DIM_EMPLOYMENT_BI
T - DW 2.1.091 Load Dw_DIM_EMPLOYMENT.dtsx Dw_DIM_EMPLOYMENT
L - DM 3.1.091 Load Dm_DIM_EMPLOYMENT.dtsx Dm_DIM_EMPLOYMENT