SAP Knowledge Base Article - Public

2306480 - Compensation spreadsheet reports fail to run.

Symptom

  • The standard spreadsheet report - 'Compensation Diversity Report' fails for one or more Pay Matrices

Environment

SuccessFactors HCM Suite
Classic Reporting
Spreadsheet reports

Reproducing the Issue

  1. Navigate to and open the 'Compensation Diversity Report' from the following location:
    Home> Analytics>Reporting > Compensation>

    Report_Location.png

  2. Choose the report's parameters and execute it.

    def.png

    The report shows a failed status in the 'Scheduled Reports' screen.

Cause

  • One of the calculations used in the report has MaxPay-MinPay in the divisor.
  • When MinPay and MaxPay have the same values for certain PayGrade, the above calculation results in a 'divide by zero' condition.

Resolution

  • As per the Compensation Hand book this is expected format:
    Ascending, positive, non-zero values for minimum, midpoint, and maximum
  • Identify the anomalous PayGrade and ensure it matches with the above guideline.

Keywords

KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-CMP , Compensation Management , Problem

Product

SAP SuccessFactors HCM Core 1511