Show TOC

Entries and Leavings (SAP Analytics)

Query Query: 0PA_C01_Q0201

 

This query shows the number of entries and the entry rate, and the number of leavings and the leaving rate of the last 5 years.

The query is part of the SAP_BW_0ROLE_0021 role (Human Resources Analyst).

Structure

Filters
Object TypeNameTechnical NameValue Restriction / Calculation
Characteristic CharacteristicEmployee Group 0EMPLGROUP

Only employees from employee group 1 (Active Employees) are evaluated.
Free Characteristics
Object TypeNameTechnical Name
Characteristic CharacteristicEmployee 0EMPLOYEE
Characteristic CharacteristicEmployee Subgroup 0EMPLSGROUP
Characteristic CharacteristicPersonnel Area 0PERS_AREA
Characteristic CharacteristicPersonnel Subarea 0PERS_SAREA
Characteristic CharacteristicMaster Cost Center 0MAST_CCTR
Variables
Object TypeNameTechnical Name
Variable VariableOrganizational Unit (Selection Option, Personalization) 0S_ORG_P
Rows
Object TypeNameTechnical NameValue Restriction / Calculation
Characteristic CharacteristicOrganizational Unit 0ORGUNIT

Personalization required
Columns
Object TypeNameTechnical NameValue Restriction / Calculation
Key Figure Key FigureNumber of Entries *

Number of Entries in the Last Five Years
Key Figure Key FigureNumber of Leavings *

Number of Leavings in the Last Five Years
Key Figure Key FigureNumber of Employees *

Number of Employees in the Last Five Years
Key Figure Key FigureEntry Rate *

Formula: NDIV0 (No. of Entries (Current*) %A No. of Employees (Current*) ). Number of entries expressed as a percentage of the number of employees.

Key Figure Key FigureLeaving Rate *

Formula: NDIV0 (No. of Leavings (Current*) %A No. of Employees (Current*) ). Number of leavings expressed as a percentage of the number of employees.

Views
Object TypeNameTechnical NameDescription
Query QueryEntries and Leavings (Current) 0PA_C01_Q0201_V01

Entries and Leavings in the Current Year.
Query QueryEntries and Leavings (Current -1) 0PA_C01_Q0201_V02

Entries and Leavings in the Previous Year.
Query QueryEntries and Leavings (Current -2) 0PA_C01_Q0201_V03

Entries and Leavings 2 Years Before Current Year.
Query QueryEntries and Leavings (Current -3) 0PA_C01_Q0201_V04

Entries and Leavings 3 Years Before Current Year.
Query QueryEntries and Leavings (Current -4) 0PA_C01_Q0201_V05

Entries and Leavings 4 Years Before Current Year.