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
Employee Category NO Employee Category built as Code + '-' + Name
Employee Category Code NO Employee Category Code
Employee Category Name NO Employee Category Name
Remark NO Remark

USED BY CUBE

Cube Name
PROJECT

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