- 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
- Login to instance
- Navigate to Report Center
- Create a new Canvas Report
- Use Advanced Reporting as data source.
- Choose Employee Time as driving table.
- Select the field displayQuantity
- Error getting query preview.
- 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.