Cube Dimension - Employee

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.

 

ATTRIBUTES

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"

USED BY CUBE

Cube Name
MANUFACTURING

ETL Information

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