Human Resources Wages and Salaries Report

image_pdfimage_print

Return to Human Resources Model Overview

This report shows data and information for wages and salary 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 Wages and Salaries 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

Localized name of the report in Report Designer

Subtitle

Current PoV selection

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. If there is no value stored in the cube for the chosen combobox selection, an entry line for Salary Increase amount or Gathering Hours will be displayed. Otherwise, other salary or wage-related  positions will be displayed.

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 that have 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
  • FTE (Change), FTE, Headcount (Change)Headcount, Hours, Hourly Rate (Change), and Hourly Rate elements of Personnel Costs_Measure dimension
  • value for slice operator <> 0

Employee (combobox)

Select one single employee or 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
  • elements of Legal Entity dimension related to selected value in Legal Entity combobox
  • elements of Cost Center dimension related to selected value in Cost Center combobox
  • FTE (Change), FTE, Headcount (Change)Headcount, Hours, Hourly Rate (Change), and Hourly Rate elements of Personnel Costs_Measure dimension
  • value for slice operator <> 0

Comparison Version (combobox)

Select one planning version for comparison (or none). Version dimension, filter for Stylesheet attribute equals BU or 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 displaying Forecast 3+9.

Below are descriptions of the rows and columns in the Human Resources Wages and Salaries report.

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. Depending on which data will be planned, Other Wages and Salaries line will be displayed. Input data in Salary Increase Amount will display additional lines for salary-based measures, like input data release additional lines for Hours.

Values entered for Salary Increase Amount for a specific month will apply to the displayed results through the end of the year.

Values entered for Salary Increase % (value should be a percentage value) for a specific month will increase salary based on salary and percentage value. Results of this calculation will be displayed through the end of the year.

Values entered for Hours and Hourly Rate (Change) for a specific month will display this calculation for a specific month.

Area visualization of version

Fill and border style for version

Stylesheet attribute of Version dimension

BU

FC x+y

Displays selected comparison version. if “None” is selected, this column does not appear.

Element of Version dimension related to selection in Comparison Version combobox

yyyy (OB)

Displays measure values at beginning of year 

Element of Month dimension yyyy-00 related to selection in Year combobox with a suffix -00

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%

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

Percentage change of selected version to comparison version

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 Resources Wages and Salary report, data can be entered in forecast months that are indicated with a reversed hatched area:   The area where data entry is possible is indicated by a gray box  as shown in the screenshot below:

image_pdfimage_print