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 |