SAP Knowledge Base Article - Public

3595355 - Story Report Filter with date range is not working for any Foundation Object

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

  1. Go to Report Center
  2. Select Story Report
  3. 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
     Chap
ter: Permissions Required for Using Story Reports

See Also

  • 2274688 - How to report on Workflow Information? - Employee Central / Canvas Reports / Story Reports
  • 3067736 - How to generate user login data report using Stories in People Analytics
  • 3412790 - Duplicate records in Story Report

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

Product

SAP SuccessFactors HCM Core 2411