SAP Knowledge Base Article - Public

3041827 - How to perform Change Reporting in Story [People Analytics]


How to perform Change Reporting in Story

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


  • SAP SuccessFactors HXM Suite
  • People Analytics
  • Story Reports


  1. Login to the instance
  2. Navigate to Reporting
  3. Click on 'New' to create a Story report OR click on the three dots to the right of the existing Story report > Edit
  4. Create a query as per the requirement
  5. Ensure that the driving table is set to Current Date/Today

  6. Next

  7. Set the date filter for change table (eg. ''Job Information'') to 'Same Filter as First Table'

  8. Duplicate the change table (eg. ''Job Information'')

  9. Remove the date filter from the duplicated table and set it to 'Date Range...'

  10. Next

  11. Set 'Range Extension: Start' to '100' (to set it to 'Show All')

  12. Change the names of the columns as desired (eg. 'Current' and 'Previous')

  13. Next

  14. Create a Calculated Column

  15. Next, create DAYS_BETWEEN formula applied on the 'Effective End Date' of duplicated table and Effective Start Date of the change table

  16. Next

  17. Next

  18. Change the Aggregation Type of the Calculated Column to 'None'

  19. Create Advanced Filter

  20. Set the filter on Calculated Column to be equal to 1 and save.

  21. Next

  22. Now, when previewing the query, the columns from the duplicated table will show the previous value.

Note: Change Reporting cannot be applied to the Driving Table as it cannot be duplicated.


SAC, People Analytics, Story Reports, Change Reporting, Previous, Current , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To


SAP SuccessFactors HXM Suite all versions


Pasted image.png