Cube Dimension - Employee Category

This cube dimension represents employee categories (in HR) based on the IFS Applications dimension DIM_EMPLOYEE_CATEGORY. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Contractor NO Contractor  Y/N, represented by 1/0
Company ID NO Company Code
Employee Category NO Employee Category built as Company + '-' + Code + '-' + Name
Employee Category Code NO Employee Category Code
Employee Category Code Name NO Built as Company + '-' + Code + '-' + Name
Employee Category Name NO Employee Category Name
Remark NO Remark
EmployeeCategoryHy YES Hierarchy consisting of levels
-Company ID
-Employee Category Code Name

USED BY CUBE

Cube Name
PROJECT
HUMAN RESOURCES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_EMPLOYEE_CATEGORY_BI BISEDI On Line
ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.123 Load IFSAppl_DIM_EMPLOYEE_CATEGORY_BI IFSAppl_DIM_EMPLOYEE_CATEGORY_BI
T - DW 2.1.123 Load Dw_DIM_EMPLOYEE_CATEGORY Dw_DIM_EMPLOYEE_CATEGORY
L - DM 3.1.123 Load Dm_DIM_EMPLOYEE_CATEGORY Dm_DIM_EMPLOYEE_CATEGORY