Cube Dimension - Employee Duration

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

ATTRIBUTES

Attribute Hierarchy Description
Employment NO Description + ' - ' + DURATION_GROUP + ' - ' + GROUP_UNIT + ' - ' + cast(CODE AS varchar) AS CLASS_GROUP_TIME
Employment Duration Class NO Represents the Duration Class
Employment Duration Class Code NO Represents the Duration Class Code
Employment Duration From NO  
Employment Duration Group NO Represents the Duration Group
Employment Duration To NO  
Employment Months NO  (ID as varchar) as ID_CHAR
Employment Time Unit NO Represents the Group Unit
Hierarchy YES Employment Duration Class -> Employment Duration Group -> Employment Months

USED BY CUBE

Cube Name
HUMAN RESOURCES

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.092 Load IFSAppl_DIM_CURR_EMP_DURATION_GROUP_BI.dtsx IFSAppl_DIM_CURR_EMP_DURATION_GROUP_BI
T - DW 2.1.092 Load Dw_DIM_CURR_EMP_DURATION_GROUP.dtsx Dw_DIM_CURR_EMP_DURATION_GROUP
L - DM 3.1.092 Load Dm_DIM_CURR_EMP_DURATION_GROUP.dtsx Dm_DIM_CURR_EMP_DURATION_GROUP