The header/column names are missing when an Adhoc report is exported / downloaded in the Excel format.
- SAP SuccessFactors HCM Core
- Ad Hoc Report
- Analytics & Reporting
Reproducing the Issue
- Run/export the Adhoc report in Excel format: The output file does NOT contain the column names
- Run/export the Adhoc report in CSV format: The output file does contain the column names
The instance does not support Excel 2010 output format for Adhoc Reports. In Excel 2003, each tab/worksheet supports a max of 65,536 rows. However, CSV supports a max of 1,048,576 rows.
If the report output contains more than 65,536 rows, the extra/remaining rows are added to the next/new worksheet. The column headers are only available in the first worksheet. As Adhoc report export does not support more than one worksheet, only the last worksheet data is exported in the output. Hence, the column names go missing.
Enable the ‘Generate Excel 2010 Output for Adhoc Reports’ option from provisioning for the instance.
KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem