Personnel Costs_measure Dimension

Return to

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 August 28, 2023