3667760 - Duplicate records in Story report cased by autojoin issue

There are one or more Duplicate records in Story Reports.

• SAP SuccessFactors HCM Suite
  • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
    • Stories in People Analytics
      • Query Designer - Filter, Calculated Column, Params

Currently this is a known issue with autojoint.

Workaround: To avoid Duplicates related to non-MDF object (like Job Information) joined with MDF objects, select Foundation fields from MDF object instead of Non-MDF object.

For example:

1. Unselect the field from Foundation object from Job Information table (i.e. Code under Position) 
2. add to the query separated table for Object to the query (i.e. Position) and add a field from the Object table (i.e. Code)

• 3211995 - Duplicate records in Story report due to selection of Foundation object fields
• 2637726 - Duplicate records in reports using Workflow information - Canvas Advanced Reporting and Story Reports
• 3412790 - Duplicate records in Story Reports
• 3050294 - Stories in People Analytics - Known Issues

Duplicate records, Story Report, Multiple Job Transactions, MDF, Multiple, Duplicate, Time filters, Job information, Duplicated, object, Position, autojoin , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-EC-REP , Reporting Data (EC core only) , How To