2569174 - ORD Advance Reporting - How to use Change Reporting Column Tool

SAP Knowledge Base Article - Public

2569174 - ORD Advance Reporting - How to use Change Reporting Column Tool

Symptom

How to display Previous and Current values in the same report in Advance Reporting using Change Reporting Column Tool

The Change Reporting function in Advanced Reporting allows a user to retrieve before/after values for a selected column in their report results.

Functions:

  • Show the previous value for a single column
  • Show up to the previous two values for the selected column
  • Show the start date for the previous value
  • Select previous values based on the main query filter
  • Previous columns can be used in sorting and re-labeled

The Change Reporting function works by using an existing query. Create one in the designer, or open pre-saved query, then click Change Reporting Columns:

changereportingAR1.png

Change Reporting ConfigurationChange Reporting On:

This is the column that you would like to show the previous value/s for. Ensure the column is selected in your query, then select it from this list.

changereportingon.png

Change Reporting For:

This column is pre-defined based on the “key” or anchor of the query. Queries that are reporting on Employees will anchor on User Sys ID, whereas queries that are reporting on objects (for example: Position) will anchor on the Object ID (for example: Position ID).

changereportingfor.png

Change Reporting Filter:

This column allows you set the same filter to the previous value/s as has been applied in the query. Set a column filter on the query and then select the same column here to apply the filter to the previous value/s.

changereportingfilter.png

Distance:

Set how many previous values to show in the query – “1” to show the previous value, “2” to show both the previous and the previous previous values.

distance.png

Show Start Date for previous value(s):

Check this box if the start date for the previous value/s is required in the query.

showstartdate.png

Filter records without a previous value:

Check this box to remove records that do not have a previous value from the results.

filterrecords.png

Results:

Here is a sample of the expected results

changereportingresults.png

Deleting the CR Column

To remove the Change Reporting column, open Change Reporting Configuration and select Delete:

delete.png

Relabeling the CR Column/s

To change the default name for the “previous” columns, go to the Columns tab, select the column and click Rename Selected Column:

RenameColumn.png

Environment

  • SAP SuccessFactors HCM Core
  • Workforce Analytics

Resolution

For further information, please see the following link from the SAP Help Portal.

Keywords

  • Advanced Reporting 
  • ODS
  • Change Reporting Column
  • Online Reporting Designer
, KBA , LOD-SF-ANA-ODS , Advanced Reporting , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core 1708 ; SAP SuccessFactors HCM Suite all versions