Overtime and Illness Rate: Trend Analysis (SAP Analytics)

Query Query: 0PT_C01_Q0202

This Query shows the overtime and illness rate of the last 12 months, including the current month.

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

Structure

Free Characteristics
Object Type Name Technical Name
Characteristic Characteristic Employee Group 0EMPLGROUP
Characteristic Characteristic Employee Subgroup 0EMPLSGROUP
Characteristic Characteristic Personnel Area 0PERS_AREA
Characteristic Characteristic Personnel Subarea 0PERS_SAREA
Characteristic Characteristic Organizational Unit 0ORGUNIT
Characteristic Characteristic Employee 0EMPLOYEE
Variables
Object Type Name Technical Name
Variable Variable Organizational Unit (Selection Option, Personalization) 0S_ORG_P
Variable Variable Last 12 Months Including Current Month 0CML12CM
Rows
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Calendar Year/Month 0CALMONTH

The last 12 months including the current month are output.

Columns
Object Type Name Technical Name Value Restriction / Calculation
Structure Overtime and Illness Rate 0PT_C01_SIOV_RATE

Key Figure Key Figure Overtime Hours 0R_OVER_HRS
Key Figure Key Figure Illness Hours 0R_SICK_HRS
Key Figure Key Figure Planned Hours 0R_PLAN_HRS
Key Figure Key Figure Overtime Rate

Formula: Overtime hours %A planned hours. Number of overtime hours expressed as a percentage of the number of planned hours.

Key Figure Key Figure Illness Rate

Formula: Illness hours %A planned hours. Number of illness hours expressed as a percentage of the number of planned hours.