Symptom
Story report filter with date range is not working for any Foundation Object but is working fine with filter As of Date
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 HXM Suite
- SAP SuccessFactors Employee Central
Reproducing the Issue
- Go to Report Center
- Select Story Report
- See below screenshot
Example:
As an end user if I am showing multiple records in my report (such as movements) I want to show the related information as it was at that point in time for each record.
Note: When choosing the "Driving Table Start Date" the user needs to be given the option to select which table should act as the driving table.
Cause
Resolution
This is a known issue which our engineering team are currently working on a fix for.
- This KBA will be updated once we receive further information on the fix date.
You may request your CSM to monitor "FPA97-2654" to track the progress of the fix.
Functionality Required
- For any related tables when choosing the time filter "As of Date" there needs to be a new option "Driving Table Start Date".
Current workaround:
- For the joining MDF objects , click on "Time Filter -> Remove filter"
FAQ - Additional Information
Q) Where can I get information on this from the Guide?
A) Guide: Using Stories in People Analytics
Chapter: Permissions Required for Using Story Reports
See Also
Keywords
INC7988396, FPA97-2654, story report, MDF objects, Time Filter, Remove filter, foundation object, Driving Table Start Date, for Related Tables , As Of date, date range , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem