Human Resources Non-Wage Labour Costs Report

Return to

Human Resources Model Overview

This report shows data and information for non-wage labour costs for several planning versions, such as Budget and Forecast. The data is stored in the Personnel Costs cube.

Report Heading

The screenshot below shows the heading area of the Human Resources Non-Wage Labour Costs 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 displayed results of the Cost Center combobox which in turn influences the content of the Employee 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.

Elements of Legal Entity dimension with a value in the Currency attribute

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
  • value for slice operator <> 0

Employee (combobox)

Select one single employee or any consolidated element.

Employee 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
  • Element of Cost Center dimension related to settings in Cost Center combobox
  • elements of Legal Entity dimension related to selected value in Legal Entity combobox
  • value for slice operator <> 0

Comparison Version (combobox)

Select one forecast for comparison (or no forecast).

Version dimension, filter for Stylesheet attribute equals BU and FC

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 with Comparison Forecast 6+6 selected.

Below are descriptions of the columns and rows in the Human Resources Non-Wage Labour Costs.

Field

Description

Implementation

Row label (personnel costs measure)

Personnel costs measure shown as localized name

Some preselected elements from the Personnel Costs_measure dimension are implemented in this report; rows for wages and salaries are only readable.

Preselected elements are

  • FTE
  • Wages and Salaries
  • Personnel Costs
  • descendants of Social Insurance
  • descendants of Other Personnel Costs

Data enty is possible for Non-wage labour costs.

Area visualization of version

Fill and border style for version

Stylesheet attribute of Version dimension

BU

FC x+y

Comparison Version selection

Displays the element selected in Comparison Version combobox; if “None” is selected, this column does not appear.

Displays the element selected in Version combobox

MMM

Displays measure values during year Elements of Month dimension related to selection in Month combobox
yyyy Displays measure values for end of year Element of Month dimension related to selection in Month combobox

ΔBU%

ΔFC x+y%

Percentage change of selected Version to the selected Comparison Version

Comparison Version (combobox) - Version (combobox) / Version (combobox)

Cell Locking

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

Every account in the Personnel Costs_measure dimension contains the PCalculation attribute, which defines the rule that is implemented on the element. When this attribute is populated, cell locking is activated in the planning reports and data cannot be entered.

For example, in the first screenshot below, the Wage element contains information for PCalculation. Thus, the planning report will NOT allow values to be written to the database.

In the Human Non-wage Labour costs report, data can be entered for forecast selections that are indicated with a reversed hatched area and for budget selections with horizontal striped pattern Lines for FTE due to Social Insurance are closed; this data will be planned in detailed reports. The area where data entry is possible is indicated by a gray box as shown in the screenshot below:

Updated July 8, 2024