Personnel Costs_measure Dimension

Return to

Human Resources Model Overview

The measures in the Personnel Costs_measure dimension include all types of personnel costs and the drivers as well as parameters to compute these. The measures are connected through their calculations and are grouped in global Subsets, which are visible in the web reports. The measures can be configured to some extent. When measures are added, modified, or removed, the calculations and global Subsets that use them must be modified accordingly to preserve the functionality.

The human resources measures can be configured through their attributes:

Attribute

Description

Name

Readable name of the account. Localized translations can be provided. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string)

Description

Long text for the account. This attribute can contain a definition of the amounts booked to this account or instructions for the planners. Localized translations can be provided. (string)

Format

Number format for this account to be driven by the database. (string)

PCalculation

Calculation rule for planning versions (versions having calculation schema P). (string)

PCalculationDependencies

Dependency for the calculation for planning versions (versions having calculation schema P). (string)

ACalculation

Calculation rule for planning versions (versions having calculation schema A). (string)

ACalculationDependencies

Dependency for the calculation for planning versions (versions having calculation schema A). (string)

Conversion Type

Defines which exchange rate is used during currency conversion. Valid values are base elements of the Conversion Type dimension, e.g. Average, Month End, Month Start, and ~. Sales accounts usually use currency conversion with average rates. Use ~ to suppress the currency conversion, e.g. for statistical figures like number of heads. (string)

See Fact Cube Using Currency Conversion and Configuration of Conversion Types

AggregationType

Semi additive measure behavior. (string)

Valid values are:

  • (empty): Regular additive behavior
  • First: First child
  • Last: Last child
  • Avg: Average of children

The following sections describe the initial setup of the measures.

Headcount

The measures in this group are used for planning and reporting of headcounts and full-time equivalents (FTE). This planning is visible in the Human Resources Headcount report.

Element Definition Implementation
Headcount (Change)

In yyyy-00 of Month dimension: initial headcount at the beginning of the year.

In other base elements of Month dimension: changes to headcount e.g. +1 for an employment or -1 for a leave.

If fiscal year begins in a month other than January, the initial value is stored in FYyyyy-00 instead. (numeric)

Calculation in calculation schema A: see rule in the ACalculation attribute.
Headcount Headcount in a specific month, calculated by the initial value and all changes to Headcount (Change) up to the specified month. (calculated, numeric) Calculation in calculation schema P: see rule in the PCalculation attribute.
FTE (Change)

In yyyy-00 of Month dimension: initial full-time-equivalent at the beginning of the year

In other base elements of Month dimension: changes to FTE e.g. +0.5 for an employment of a 50 percent part-time employment or -1 for a leave of a full-time employee.

If fiscal year begins in a month other than January, the initial value is stored in FYyyyy-00 instead. (numeric)
Calculation in calculation schema A: see rule in the ACalculation attribute.
FTE FTE in a specific month calculated by the initial value and all changes to FTE (Change) up to the specific month. (calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

The measures in this group are not subject to be configured.

Entries and Leavers

These measures are not used in other calculations and are not exposed on reports. They may be extended, altered, or removed. The calculations assume that any entry or leave is visible in the Headcount (Change) measure. When the items in the Employee dimensions are groups of employees, and if there are entries and leaves on the same coordinate within the month, the calculated values for Entries, Leavers, and Staff Turnover will disregard immediate replacements and thus show values that are too small. To work around this, remove the calculations from the attributes ACalculation and PCalculation for the measures Entries and Leavers and provide the values from a better data source, either through import or manual input.

Element Definition Implementation
Entries Positive changes to Headcount (Change) (calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Calculation in calculation schema A: see rule in the ACalculation attribute.

Leavers Negative changes to Headcount (Change) (calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Calculation in calculation schema A: see rule in the ACalculation attribute.

Staff Turnover Ratio of leavers calculated by Leavers / Headcount. (calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Calculation in calculation schema A: see rule in the ACalculation attribute.

Wages and Salaries

The measures in this group are used for planning and reporting of salaries and wages. Salaries are calculated by FTE and the full-time base salary. Salaries can be increased for any month as an absolute or percentage change. Wages are calculated by number of hours and an hourly rate. The rate can be increased for any month.
This planning is visible in the Human Resources Wages and Salaries report.

Element Definition Implementation
Full Time Base Salary (Change)

In yyyy-00 of Month dimension: initial full-time base salary at the beginning of the year. This value is physically stored.

In other base elements of Month dimension: changes to full-time base salary as amounts e.g. +200 for a raise of 200 units in the local currency. In versions with calculation schema P, this value is calculated from Salary Increase Amount or Salary Increase %.

If fiscal year begins in a month other than January, the initial value is stored in FYyyyy-00 instead. (partly calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Salary Increase Amount Absolute increase in the monthly salary (numeric)
Salary Increase % Percentage increase in the monthly salary (numeric)
Full Time Base Salary Monthly salary for a 100% FTE for a specific month calculated by the initial value and all changes to Full Time Base Salary (Change) up to the specific month (partly calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

FTE Full-time equivalents; see Headcount section (numeric)
Base Salary Effective base salary, taking into account the FTE (partly calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Bonus Additional bonus on top of the base salary (numeric)
Commission

Additional commission on top of the base salary (numeric)

On Target Earnings Total of base salary, bonus, and commission (aggregated, numeric)
Hours Number of working hours
Hourly Rate (Change)

In yyyy-00 of Month dimension: initial hourly rate at the beginning of the year.

In other base elements of Month dimension: changes to hourly rate as amounts e.g. +1.5 for a raise of 1.5 units in the local currency.

If fiscal year begins in a month other than January, the initial value is stored in FYyyyy-00 instead. (numeric)

Calculation in calculation schema A: see rule in the ACalculation attribute.
Hourly Rate Hourly rate during a specific month calculated by the initial value and all changes to Hourly Rate (Change) up to the specific month (partly calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Calculation in calculation schema A: see rule in the ACalculation attribute.

Wage Wage calculated by Hours x Hourly Rate (calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Calculation in calculation schema A: see rule in the ACalculation attribute.

Wages and Salaries Total of on-target earnings and wage (aggregated, numeric)

The measures in this group are not subject to be configured.

Non-Wage Labour Costs

The measures in this group cover all personnel costs beyond wages and salaries. Some lines are calculated from Wages and Salaries or Headcount, while others can be imported or provided by manual input. The number, naming, ordering, and aggregation of these measures can be configured. The documentation of the measures below may serve as a starting point for other configured measures.

This planning is visible in the Human Resources Non-Wage Labour Costs report. The measures shown there are defined with the global Subsets HumanResourcesNonWageLabourCosts and HumanResourcesOtherPersonalCosts.

Element Definition Implementation
Health Insurance

Health insurance is calculated in versions with calculation schema P by Wages and Salaries × Health Insurance%.

If Wages and Salaries are below the exemption Health Insurance_LowerLimit, the result is 0.

If Wages and Salaries are above the threshold Health Insurance_UpperLimit, the result is cut off as the threshold. (partly calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Health Insurance%

In versions with calculation schema P, this value is the rate to calculate Health Insurance. It is transferred from the identical measure in the Personnel Cost Parameters cube. In that cube, it can be stored in any of three levels of the Month dimensions:

  • Time, independent of element ~
  • With yearly granularity in elements such as yyyy-~ (e.g. 2016-~)
  • With monthly granularity in elements yyyy-MM (e.g. 2016-06)

In versions with calculation schema A, this value is calculated from the actual amounts for Health Insurance and Wages and Salaries.
(calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Calculation in calculation schema A: see rule in the ACalculation attribute.

Health Insurance_LowerLimit

In versions with calculation schema P, this value is the exemption to calculate Health Insurance. It is transferred from the identical measure in the Personnel Cost Parameters cube. In that cube, it can be stored in any of three levels in the Month dimension:

  • Time, independent of element ~
  • With yearly granularity in elements such as yyyy-~ (e.g. 2016-~)
  • With monthly granularity in elements yyyy-MM (e.g. in element 2016-06)

In versions with calculation schema A, this value is not calculated

Calculation in calculation schema P: see rule in the PCalculation attribute.

Health Insurance_UpperLimit

In versions with calculation schema P, this value is the threshold to calculate Health Insurance. It is transferred from the identical measure in the Personnel Cost Parameters cube. In that cube, it can be stored in any of three levels in the Month dimension:

  • Time, independent of element ~
  • With yearly granularity in elements such as yyyy-~ (e.g. 2016-~)
  • With monthly granularity in elements yyyy-MM (e.g. in element 2016-06)

In versions with calculation schema A, this value is not calculated. (partly calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.
Long-Term Care Insurance, Unemployment Insurance, Retirement Plan, Long-Term Care Insurance%, Unemployment Insurance%, Retirement Plan%, Long-Term Care Insurance_LowerLimit, Unemployment Insurance_LowerLimit, Retirement Plan_LowerLimit, Long-Term Care Insurance_UpperLimit, Unemployment Insurance_UpperLimit, Retirement Plan_UpperLimit, Professional Association Fee_per_Head See definition for Health Insurance, Health Insurance%, Health Insurance_LowerLimit, and Health Insurance_UpperLimit See implementation for Health Insurance, Health Insurance%, Health Insurance_LowerLimit, and Health Insurance_UpperLimit
Professional Association Fee In versions with calculation schema P, this value is calculated by Headcount × Professional Association Fee_per_Head. (partly calculated, numeric)

Calculation in calculation schema P: see rule in the PCalculation attribute.

Measures on other reports

The measures shown on the following reports are defined with the global Subsets for HumanResourcesActualPersonnelCosts_measure:

Updated November 4, 2024