SAP Knowledge Base Article - Public

3063574 - Unable to report on displayQuantity field of EmployeeTime object


  • Since 1H 2021 Release, any reports with the field displayQuantity are not working
  • "Error getting query preview" in Advanced Reporting query with Employee Time object


  • SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Login to instance
  2. Navigate to Report Center
  3. Create a new Canvas Report
  4. Use Advanced Reporting as data source. 
  5. Choose Employee Time as driving table. 
  6. Select the field displayQuantity 
  7. Error getting query preview.
  8. If we remove displayQuantity field, of object EmployeeTime, then report would work fine


After a Business Entity migration in Employee Time object, the DisplayQuantity field no longer exists in the DB. This field, even though available in the query designer, was never reportable and never stored any data in the database.


Remove the field displayQuantity from your query.

See Also

2803123 - Employee Time displayQuantity is blank - Advanced Reporting


Employee Time displayQuantity field blank Advanced Reporting canvas center error getting preview
, KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Known Error


SAP SuccessFactors HXM Suite all versions