- Date Range reports in Advanced Reporting, will fetch all the records during the chosen period.
- This article explains how to include only the last change (last transaction) done for the day, in the employees' records.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
- SAP SuccessFactors HCM Suite
- Online Report Designer / Report - Canvas: Advanced reporting
Reproducing the Issue
One or more users have multiple Job Transactions on the same day and a result, the report fetches multiple entries with the same effective start date(s):
The ‘Last Trans Seq’ field under Global Job Information holds the value ‘True’ for the last change done for the day and ‘False’ for the remaining transactions.
Applying a filter for this field will meet the requirement.
REALMS, Advanced, Reporting, Canvas, Report, Last, Transaction, Latest, Change, Date, Range, Analytics, Global, Job, Information, Last Trans Seq, Employment, , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To