SAP Knowledge Base Article - Public

2459733 - ORD Report export to CSV Returning blank data

Symptom

  • Advance Reporting Export to CSV
  • ORD Report Export to CSV

Environment

SAP Successfactor HCM

Reporting ORD Report's and Advance Report Export 

Production and Stage 

Reproducing the Issue

1) Access the Instance 

2) Go to Analytics 

3) Run the report via Background Export or Report Distributor (offline, Email) in CSV format 

4) Note that the Job has completed successfully but the report has no data except the column heading.

Cause

  • Export to CSV fails, if there are any grouped by columns applied on the query.
  • CSV output fails. Report distributor returns empty report after exporting to CSV if group columns in edit formatting is applied.
3.png

Resolution

1) Remove the "Group Column" by clickinng on report

2) Go to edit formatting

3) Press left top corner to select all.

4) Right click on any column and press ungroup selected columns

Or

Export the report XLS format, Export XLS format will work fine.

Keywords

Export to CSV ORD Export to CSV. Group Column , KBA , LOD-SF-WFA-DES , Report Designer , LOD-SF-LMS-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors Workforce Analytics all versions