Human Resources Headcount Report

Return to

This report shows data and information for entries and leaves of employees that are stored in the Personnel Costs cube. It focuses on planning headcounts and full-time-equivalent (FTE) information for several planning versions, including budget and forecast.

Employee records that are not stored in the source system can be added with the Human Resources Add Employee report by clicking on the icon, as indicated in the screenshot below:

Data entry requires an existing employee in the Employee dimension and the selection of a single legal entity and single cost center. If a change is entered for a single month, then it will affect the rest of the months in the same year.

Report Heading

The screenshot below shows the heading area of the Human Resources Headcount report. The report heading updates dynamically as various reporting options are selected. The logo can be changed in Administration; see Configuring Design Elements for more on report design.

The heading area of the report displays the following fields:

Field	Description	Implementation
Title	Name of the report	Name of the report in Report Designer
Subtitle	Current PoV selection	Localized subtitle will update as PoV selections are made
Arrow	Show/hide PoV widget	Click on the arrow to display or hide point-of-view selections

Point of View (PoV) Options

The content of the report can be customized using the PoV options, which can be viewed by clicking the blue arrow at the top of the report.

This report uses a cascading logic: the selection made in the Legal Entity combobox influences the result of the Cost Center combobox.

The available options are described below:

PoV Option	Description	Implementation
Version (combobox)	Select a planning version.	`Version` dimension, filter for `Stylesheet` attribute equals `BU` or `FC`
Year (combobox)	Select a reporting period.	Elements matching the pattern `yyyy` or `FYyyyy` of `Month` dimension
Legal Entity (combobox)	Select one single legal entity or any consolidated element.	`Legal Entity` dimension
Cost Center (combobox)	Select one single cost center or any consolidated element.	`Cost Center` dimension. Data filter factors the following elements: element of `Version` dimension related to settings in Version combobox element of `Month` dimension related to settings in Year combobox elements of `Legal Entity` dimension related to selected value in Legal Entity combobox elements of `Personnel Costs_Measure` dimension: `FTE (Change)`, `FTE`, `Headcount (Change)`, and `Headcount` elements value for slice operator <> 0

Report Columns and Rows

The columns and rows displayed in the report depend on the selections made in the PoV area. The screenshot below shows a report displaying Forecast 3+9.

Below are descriptions of the rows and columns in the Human Resources Headcount report.

Field	Description	Implementation
Row label (employee)	Employees shown as element name and localized `ID_Name` attribute	`Employee` dimension displays all elements having any value in current selection and hides employees not having any value in the current selection. Data filter factors the following elements: Element of `Version` dimension related to settings in Version combobox Element of `Month` dimension related to settings in Year combobox as well as elements with suffix `-00` and a range of 12 months (i.e., `yyyy-00`, `yyyy-MMM`) Elements of `Legal Entity` dimension related to selected value in Legal Entity combobox Elements of `Cost Center` dimension related to selected value in Cost Center combobox Value for slice operator <> 0
ComboBox with all other employees	Add an existing employee to the current cost center	Data validation with `Employee` dimension
Add Employee	Add a new employee	See Human Resources Add Employee report
All Employees	Sum of all values for headcount and Full Time Equivalent (FTE)	`Name` attribute of `Employee` dimension
Area visualization of version	Fill and border style for version	`Stylesheet` attribute of `Version` dimension
Employee Category	Employment relationship category	`Employee Category` attribute of `Employee` dimension
Region	Working region of employee	`Region` attribute of `Employee` dimension
yyyy (OB)	Displays headcount and full time equivalent (FTE) values at opening balance (OB)	`yyyy-00` element of `Month` dimension related to settings in Year combobox with suffix `-00`
MMM	Displays changes to headcount and full time equivalent (FTE) for each month during the selected year	Element of `Month` dimension related to settings in Year combobox
yyyy	Displays headcount and full-time-equivalent (FTE) values for end of selected year.	Element of `Month` dimension related to settings in Year combobox

Human Resources Add Employee Report

With this report, new employees can be added to the Employee dimension. Values for headcount and full time equivalent (FTE) will be written to the Personnel Costs cube. Depending on the selected planning version, the value will be written in the first plannable month; for example, the Budget version starts with first month of the year, while the Forecast 3+9 version will start with the fourth month of year.

Settings are the same as for the comboboxes in Human Resources Headcount, described above under Point of View (PoV) Options. Employees can only be added if a value is written in the Employee No. input area.

The components of the Human Resources Add Employee report are described below.

Field	Description	Implementation
Employee No.	Number for new employee	Employee number will be added to `Employee` dimension as element
Name	Name of new employee	Employee name will be written into `Name` attribute of `Employee` dimension
Headcount	Value for headcount	Headcount measure will be written into `Personnel Costs` cube for `Month`, `Version`, `Legal Entity`, `Cost Center`, and `Headcount (Change)` elements of `Personnel Costs_measure` dimension
FTE	Value for FTE	FTE measure will be written into the `Personnel Costs` cube for `Month`, `Version`, `Legal Entity`, `Cost Center`, and `FTE (Change)` elements of `Personnel Costs_measure` dimension
Group into (combobox)	Select a parent under which the new employee should be integrated.	Parents of `Employee` dimension

Cell Locking

For all planning reports, data entry is only possible when a single legal entity and a single cost center are selected. Cell locking prevents the entry of data in fields that draw on multiple sources.

Updated July 8, 2024