SAP Knowledge Base Article - Public

3063574 - Unable to report on displayQuantity field of EmployeeTime object

Symptom

  • 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

Environment

  • 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


Cause

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.

Resolution

Remove the field displayQuantity from your query.

See Also

2803123 - Employee Time displayQuantity is blank - Advanced Reporting

Keywords

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

Product

SAP SuccessFactors HXM Suite all versions