SAP Knowledge Base Article - Public

3295046 - Filter displays extra values for compensation domain report - Compensation

Symptom

When selecting filter option, in adhoc report for compensation domain, it brings more values than the values in the compensation worksheet.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HXM Suite
  • SAP SuccessFactors Compensation

Reproducing the Issue

  1. Create adhoc report using compensation domain
  2. Select a compensation template in the data sets
  3. Then in the filters, under Compensation Plan Entries, select a field from the worksheet
  4. You might see many values under "by my selection":



  5. While in the worksheets there are no such values:

Cause

That happens because we have a limitation with adhoc where it pulls values from the internal data base column ID, which is shared between multiple templates.

Resolution

You can reduce the extra values by purging all deleted worksheets, but even after that you might still get some extra values due to live worksheets. That is the current system expected behavior.

Keywords

adhoc, table, report, compensation, domain, worksheet, planning, form, values, filter, option, data, reporting, incorrect, extra , KBA , LOD-SF-CMP-REP , Reporting & Analytics, Data Imports & Exports , Problem

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HXM Suite all versions