SAP Knowledge Base Article - Public

2342441 - Sort Column Not Behaving as Expected in an Adhoc Report - SuccessFactors

Symptom

  • Sort Column functionality in Adhoc is not working correctly
  • Data in Adhoc report is getting sorted in reverse manner than what is selected

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

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Go to Adhoc Report
  2. Sort the report using Sort Column functionality under Columns tab, i.e. sort report on columns Country and Degree (both ascending):

1.PNG

  1. Preview the report and notice the data is not getting sorted correctly for Degree column, instead of ascending it is sorted in descending order:

2_new.jpg

Cause

Check if the column which is not getting sorted in correct manner is a picklist column or not. If yes, then check the below steps:

  1. Sorting functionality for picklist columns in Adhoc sort data based on the Picklist Option ids and not the Labels
  2. Go to Admin Center > Picklist Management > download the Picklist (Not the order of the Option Id and the Labels)

picklist.PNG

In order to confirm the above mentioned cause in Adhoc, change the configuration of the column to show the Picklist Option Id instead of Label.:

  1. Go to Configuration Tab in Adhoc and click Show Value ID configuration
  2. Check the Show Value ID configuration in front of the column name
  3. Preview the report. Notice the report is getting sorted correctly on the basis of Option Id
  4. See the Picklist Labels in the Adhoc report get sorted based on the Option id. (Label with less Option id will display first in the report when sorted in ascending order)

3_new.jpg

Resolution

  • To sort Labels correctly in Adhoc, change the order of the Labels in Picklist and arrange them according to the Picklist Option Id order
  • If Option id is in ascending order, put the labels in ascending order and vice versa

Keywords

SF, success factors, ANA, RPT, ad hoc, PLT, platform, picklist, pick list, ID, Table, Center, ascending, descending, incorrect order , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HCM suite all versions ; SAP SuccessFactors Workforce Analytics all versions