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.
- Start with Compensation table
- Select employee ID from compensation information
- Join to Global Job Information by clicking the arrow next to Compensation Information
- Add the effective start date to the report
- Select the Objects tab and click the blue edit table icon next to Global Job Information
- Click the duplicate table button in the top (this will be the old data)
- 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.
- 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)
- In date options, go to the overrides tab.
- Click Edit next to global job information
- Select ‘Show All’ from the date type drop down and then click set
- Repeat for global job information 2
- 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
- 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.
Great! Well done.... I just had the same idea for my blog. Now I just need to mention yours =)
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:
The link is broken, I guess you are referring to this document:
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?
Can the same thing be done in Integration Center? or an ORD report leveraged
Kayla...can you please tell me why you started with Compensation Information when you are not comparing data specifically from compensation? Thanks!