SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

  • 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

Cause

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.

Resolution

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

Keywords

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

Product

SAP SuccessFactors HCM Suite all versions