SAP Knowledge Base Article - Public

2720379 - Report on Foundation Object Schema is not fetching translated field values


Report on Foundation Object Schema is not fetching translated field values.


SAP SuccessFactors HCM Suite

  • Analytics & Reporting(Ad Hoc, YouCalc, ORD)

                      Advance Reporting (ODS)

                      Ad hoc Reports & Report Builder

Reproducing the Issue

Navigation Steps to Check Data:

  • Go to Admin Center > Manage Organization, Pay and Job Structures > Select "Location" or any other Foundation Object > Select any Location which has translation set for field (Such as - Description)
  • Click the Translation icon of "Description" or "Name" field, you can see the Translated values in rightly appearing for desired locale (for example japanese language).

Replication Steps:

  • Go To Home > Option > Change the BizX Language to Japanese > Switch
  • Home > Analytics > Reporting > Adhoc /Advance Report.
  • Create Adhoc/Advance Report based on Foundation Object
  • Select all fields from Location object
  • Location Name, Location Description etc in Adhoc/Advance Report
  • Run Adhoc/Advance Report 
  • Translated values does not appear in output file.


Adhoc/Advance report doesn't support translation in Foundation Objects reports. This is expected behavior.


Adhoc, Translation, Foundation Object, Language, Ad Hoc, Translated, Advance, Manage, Organization, Pay, Job, Structures, Locale, Event Reason , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem


SAP SuccessFactors HXM Suite all versions