Symptom
No records displaying in Form List Report if we use the exact PM Form End date in Date options.
End date should be the day after the Form’s End Date
Environment
SAP Successfactors Workforce Analytics
SAP Successfactors Analytics/Reporting
Reproducing the Issue
(Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.)
- Go to Classic Reporting Page
- Select List Views
- Click Form List to generate it
Use the exact Form Dates in Date Option Filter
Result: No data displayed in the Report
Use the date after Form End Date
Result: Records will display
Cause
Configuration of List Reports in Hana using “to_date” which is not including the Form’s end date.
Resolution
Moving forward use the date after the Form End date as filter in the List Report (i.e. Form End Date +1).
Example:
Form End Date: December 31, 2017
Used the report date: January 1, 2018
See Also
Keywords
Form List, List Views, Classic Reporting, End Date, Form End Date , KBA , LOD-SF-ANA-VIE , List View, Spreadsheet & Classic reports , Problem