This cube dimension represents an employee dimension Mainly describing employee basic data and is based on the IFS Applications dimension DIM_EMPLOYEE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Hierarchy | Description |
| Company Code | NO | Company code of employee. |
| Country Code | NO | Country code of employee. Typically 2 char ISO abbr. |
| Employee | NO | Key. Built up as Compnay Code - Employee Code - Employee Name |
| Employee - Last Loaded | NO | ETL Processing Date |
| Employee Code | NO | Employee code value |
| Employee Name | NO | Full name of employee. |
| Employee Person Id | NO | Id of Employee. |
| EmployeeHy | YES | Hierarchy defined as "Company Code" -> "Employee" |
| Cube Name |
| MANUFACTURING |
| BI Access View | BI Component | Recommended Source Type |
| DIM_EMPLOYEE_BI | PERSDI | On Line |
| ETL Step | File Name of SSIS Package | Table Name |
| E - Stage | 1.1.113 Load IFSAppl_DIM_EMPLOYEE_BI.dtsx | IFSAppl_DIM_EMPLOYEE_BI |
| T - DW | 2.1.113 Load Dw_DIM_EMPLOYEE.dtsx | Dw_DIM_EMPLOYEE |
| L - DM | 3.1.113 Load Dm_DIM_EMPLOYEE.dtsx | Dm_DIM_EMPLOYEE |