Human Resources Headcount Report

image_pdfimage_print

Return to Human Resources Model Overview

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.

image_pdfimage_print