SAP Knowledge Base Article - Public

2478297 - Goal/Objective Management Adhoc report showing ID number instead of label/text value

Symptom

  • AdHoc Report of Goal / Objective Management domain has fields showing the ID number and not the text / label value.

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Reproducing the Issue

  1. Go to Adhoc reports
  2. Create a new report of Goal or Objective Management domain
  3. Add fields such as "Salutation" that are configured as picklist in the data model
  4. Preview the report
  5. See ID values instead of the label values "Mr.", "Mrs.", "Ms." or "Miss."

kba1.png

Cause

The reason the Goal/Objective Management report pulls numeric values in Ad Hoc is because some fields of the User Data File (Admin Center > Employee Export) have numeric values in it. These fields are configured with numbers because they are picklists and Goal/Objective Management domain currently does not support picklist transformation number to label function in the Adhoc Configuration tab.

kba2.png

 

If we create another adhoc with a different domain like Employee Profile we can see that the same field "Salutation" is available in the Configuration tab to be changed in label or ID:

kba3.png

kba4.png

Resolution

We encourage you to submit an enhancement request to have this functionality considered within future development cycles – you can do this on our Customer Community Portal at http://community.successfactors.com/ or https://influence.sap.com/SuccessFactorsReporting.

Keywords

KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Product Enhancement

Product

SAP SuccessFactors Workforce Analytics all versions