SAP Knowledge Base Article - Public

3100458 - Error query preview in Employee Time Sheet report - Advanced Reporting/Canvas

Symptom

  • Since 2H 2021 Release, EmployeeTimeSheet reports with the custom transient fields are not working
  • "Error getting query preview" in Advanced Reporting query with Employee Time Sheet object

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Create a new Canvas Report
  2. Use Advanced Reporting as data source. 
  3. Choose Employee Time Sheet as driving table. 
  4. Select a custom transient field
  5. Click on Results
  6. Error getting query preview.
  7. If you remove the field from the query, the report works fine

Cause

After a Business Entity migration in Employee Time Sheet object, custom transient fields no longer exist in the DB and cannot be used in the report.

Resolution

Remove any custom transient field from the objects EmployeeTimeSheet, EmployeeTimeSheetEntry or EmployeeTimeValuationResult in your report.

Please note that transient fields are anyway not reportable and do not display any data in the reports.

See Also

2283381 - Calculated \ Transient fields are inconsistent in reporting - Advanced Reporting

Keywords

2111 2H 2021 Release EmployeeTimeSheet report transient fields are not working "Error getting query preview" in Advanced Reporting query with Employee Time Sheet object , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-EC-TIM , Time Off , Known Error

Product

SAP SuccessFactors HCM suite all versions