SAP Knowledge Base Article - Public

2318122 - Online Report Designer (ORD) Duplicate Date Records in Position History report


You run a report on Position History and the result show Multiple (duplicate) Date rows for the same Position.

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


  • SuccessFactors HCM Core all version
  • Advanced Reporting, Online Report Designer (ORD)

Reproducing the Issue

  1. Login to the affected instance.
  2. Analytics - Analytics - Select the report from the folder.
  3. Click on the Manage filters select position code to filter only one user> enter the position code and click ok.
  4. Go to Edit - Date Options - The Date Range is selected
  5. Run the report / the result show for the same Position Code - multiples row with different dates.

For example:

The start date 1: 03/11/2016 End date 31/12/9999

The start date 2: 03/06/2015 End date 30/07/2016

The start date 3: 05/01/2014 End date 30/10/2015


Because The Date Range is selected in the Date Options, the system return the data within the selected Date Range Filter having as result multiples lines with different dates.


To solve the issue:

  1. Go to Edit > Date Options > change from "Date Range"  to  "As of Date"
  2. Run the report, the result show only one row (line)

Date Option in Legacy ODS

Date Range legacy ODS.png

REALMS Date Options

Date Range to As of Date.png


  • Duplicate Dare lines
  • Multiples Rows
  • Duplicate Data,
  • Advanced Reporting
  • ORD Duplicatte Date data
, KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem


SAP SuccessFactors HXM Suite all versions