SAP Knowledge Base Article - Public

2775718 - Duplicate records in adhoc report filters due to space

Symptom

Filters are duplicated in AdHoc reporting when selecting the custom field name column.

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 Performance Managenment

Reproducing the Issue

1. Go to Reporting and select AdHoc Report

2. Select Performance Management Domain

3. Under the Filter tab select the Custom field name

4. Click "By my Selection" and note that the custom field name is duplicated in the results.

Custom Field Name filter duplicate.png

Cause

There is a space following one of the <ename> fields in one of the sections of the form. This makes the system identify the <ename> fields as two seperate fields and duplicate results will be returned.

Resolution

If you are using the same custom field name in different sections of your form, make sure that the <ename> is identical in the XML. Do not allow any space in the XML as highlighted below.

ename space in custom field.png

Keywords

Performance Management, Domain, AdHoc, Report, Custom section, Custom Field, Column, Filter, Duplicate, Multiple, Copied, Data, Ename, XML, Template, Table, Space, records, Filter, Section, Values , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors Performance & Goals all versions