Personnel Costs_measure Dimension

image_pdfimage_print

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 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)

 
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:
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)

 
FTE FTE in a specific month calculated by the initial value and all changes to FTE (Change) up to the specific month. (calculated, numeric)

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)
Leavers Negative changes to Headcount (Change) (calculated, numeric)
Staff Turnover Ratio of leavers calculated by Leavers / Headcount. (calculated, numeric)

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:

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:

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:

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)

 
 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:

Calculation in calculation schema A:

Wage   Wage calculated by Hours x Hourly Rate (calculated, numeric)
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:

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:

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 implementation for Health Insurance%
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 implementation for Health Insurance%
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_LowerLimit, and Health Insurance_UpperLimit See implementation for 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:

Measures on other reports

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

 

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...