Symptom
When a user selects the Description field from the Foundation object and removes the Time filter, the system may fetch an incorrect value. This happens if the description has been changed for the same department code.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SuccessFactors HXM Suite
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Story reports (Analytics Cloud for SF)
- Query Designer - Filter, Calculated Column, Params
- Story reports (Analytics Cloud for SF)
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
- Login into instance
- Create new Story report
- Drag and Drop Position object
- Select Position Number and Position Title fields
- Remove Time Filter
- Click on Finish
- Create a Cross Tab widget
- Can see Same Position Title is shown for all the Effective Start date's even though there are changes in Position Title for this user in Employee Profile
- Please note in Replication Steps Position Object is considered, same is true for every Foundation Object
Resolution
Workaround:
Add the affected Foundation object field as a calculated column in the Query Designer, and use this calculated column in the Cross Tab widget instead of selecting the field directly.
Keywords
Foundation, Object, time, Filter, Incorrect, internal memo, Change, Description, Name , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem
SAP Knowledge Base Article - Public