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 |
PCalculationDependencies |
Dependency for the calculation for planning versions (versions having calculation schema |
ACalculation |
Calculation rule for planning versions (versions having calculation schema |
ACalculationDependencies |
Dependency for the calculation for planning versions (versions having calculation schema |
Conversion Type |
Defines which exchange rate is used during currency conversion. Valid values are base elements of the See Fact Cube Using Currency Conversion and Configuration of Conversion Types |
AggregationType |
Semi additive measure behavior. (string) Valid values are:
|
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 In other base elements of If fiscal year begins in a month other than January, the initial value is stored in |
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 In other base elements of 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 |
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 Calculation in calculation schema |
Leavers | Negative changes to Headcount (Change) (calculated, numeric) |
Calculation in calculation schema Calculation in calculation schema |
Staff Turnover | Ratio of leavers calculated by Leavers / Headcount . (calculated, numeric) |
Calculation in calculation schema Calculation in calculation schema |
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 In other base elements of If fiscal year begins in a month other than January, the initial value is stored in |
Calculation in calculation schema
|
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 |
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 |
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 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 |
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 Calculation in calculation schema |
Wage | Wage calculated by Hours x Hourly Rate (calculated, numeric) |
Calculation in calculation schema Calculation in calculation schema |
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 If If |
Calculation in calculation schema |
Health Insurance% |
In versions with calculation schema
In versions with calculation schema |
Calculation in calculation schema Calculation in calculation schema |
Health Insurance_LowerLimit |
In versions with calculation schema
In versions with calculation schema |
Calculation in calculation schema |
Health Insurance_UpperLimit |
In versions with calculation schema
In versions with calculation schema |
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
|
Measures on other reports
The measures shown on the following reports are defined with the global Subsets for HumanResourcesActualPersonnelCosts_measure
:
- Human Resources Actual report
- Human Resources Mid-Term Planning report
- Human Resources Legal Entity Breakdown report
- Human Resources Time Series report
Updated November 4, 2024