Employee Dimension

All Employees

Root element summarizing all base elements, showing 100% of the staff.

~

The NA (not applicable) element of the dimension, which holds data that is not broken down by employee. Must be child of All Employees. This is also the default write element of this dimension

Unassigned

Grouping of unexpected elements found during data load. Must be child of All Employees. This is the default parent element of this dimension.

…

This dimension must have additional base elements to hold data that is broken down by employee.

Name

Readable name of the employee. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string)

ID_Name

Combination of element name, a dash (“ - "), and the localized name attribute. (calculated, string)

Description

Long text for the employee. This attribute can contain additional information on the employee or group of employees, or instructions for the planners. Localized translations can be provided. (string)

Last Name

Last name of the employee. Empty for groups of employees. (string)

Surname

Surname of the employee. Empty for groups of employees. (string)

EmploymentFrom

First day of employment in the Excel date encoding. Empty for groups of employees. (string)

EmploymentTo

Last day of employment in the Excel date encoding. Empty if the employment is unlimited and for groups of employees. (string)

Region

Base element in the Region dimension (string)

Employee Category

Base element in the Employee Category dimension (string)

E-Mail

E-mail address of the employee (string)

Manager

Current manager of the employee. Should be the element name of another element in this dimension. (string)