Model: Production Performance - Specifications for Dimension Table: EMPLOYEE

On this page you will find the specifications regarding the Model: Production Performance and Dimension Table: EMPLOYEE.

This model dimension represents an employee dimension mainly describing employee basic data and is based on the IFS Cloud dimension DIM_EMPLOYEE. All models that refers to this dimension will have the attributes and hierarchies as described below.

 

Attributes

Attribute Description (where applicable)
Company CodeCompany code of employee.
Employee CodeEmployee code value
Employee NameFull name of employee.
Employee Person IdId of Employee.
Country CodeCountry code of employee. Typically 2 char ISO abbr.
EmployeeBuilt up as Compnay Code - Employee Code - Employee Name

Hierarchies

Hierarchy Level
EmployeeHy
Company Code
Employee

USED BY MODEL(S)

Model Name
Production Performance

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
EMPLOYEEDIM_EMPLOYEE_BIDIM_EMPLOYEEOn Line