Skip to Content
Author's profile photo Kayla Toelle

Change Reporting in ORD Advanced Reporting

I have been working with the analytics tool since before it was a SuccessFactors tool. One of the most common questions I receive from customers and on the SF Community site is how to do change reporting after they’ve upgraded to Advanced Reporting.  There is a delivered ‘Change Reporting Configuration’ option in Advanced Reporting, but you’re only able to report on one change field at a time. The benefit of the below method is that you can show as many changes as you want within one report.

Below is an example of a report showing the employment status and function changes.

  1. Start with Compensation table
  2. Select employee ID from compensation information
  3. Join to Global Job Information by clicking the arrow next to Compensation Information

  4. Add the effective start date to the report
  5. Select the Objects tab and click the blue edit table icon next to Global Job Information
  6. Click the duplicate table button in the top (this will be the old data)


  7. Create a custom column for days different. It will subtract the end date from global job info 2 table from the start date of the global job info table.


  8. Add the following filters:

    Days Difference = 1
    Employee Status is not equal to Employee Status 2 (use the field comparison tab to select employee status2)
    Function is not equal to Function 2 (use the field comparison tab to select function2)


  9. In date options, go to the overrides tab.
  10. Click Edit next to global job information
  11. Select ‘Show All’ from the date type drop down and then click set


  12. Repeat for global job information 2
  13. Create a custom column for the old and new values.

    If old value = new value then blank else old value
    If old value = new value then blank else new value/wp-content/uploads/2016/09/6_1029546.png/wp-content/uploads/2016/09/7_1029548.png

  14. View results and only the values that changed should be populated.


If you’d like to also show the data that didn’t change, you can stop at step 12 and then add your fields from Global Information 1 and 2.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Chris Wilpert
      Chris Wilpert

      Great! Well done.... I just had the same idea for my blog. Now I just need to mention yours =)

      Author's profile photo Kayla Toelle
      Kayla Toelle
      Blog Post Author

      Thank you!

      Author's profile photo Luke Marson
      Luke Marson

      This is a topic not well covered so thanks for adding some knowledge to the community. For reference of other readers, here's the SAP guide to Change Reporting in ORD:

      Author's profile photo Christopher Trum
      Christopher Trum

      The link is broken, I guess you are referring to this document:

      Author's profile photo Francesco Melillo
      Francesco Melillo

      Hi Kayla,

      is not possible duplicate the first table, Compensation Information in your example.
      There is a way to show changes on more field from the first table?


      Author's profile photo Ehab Arif
      Ehab Arif

      Can the same thing be done in Integration Center? or an ORD report leveraged

      Author's profile photo Tim Helzlsouer
      Tim Helzlsouer

      Kayla...can you please tell me why you started with Compensation Information when you are not comparing data specifically from compensation? Thanks!