SAP Knowledge Base Article - Public

2158259 - Header/column names missing in Ad Hoc report exported in excel format

Symptom

The header/column names are missing when an Adhoc report is exported / downloaded in the Excel format.

Environment

  • SAP SuccessFactors HCM Core
  • Ad Hoc Report
  • Analytics & Reporting

Reproducing the Issue

  1. Run/export the Adhoc report in Excel format: The output file does NOT contain the column names
  2. Run/export the Adhoc report in CSV format: The output file does contain the column names

Cause

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.

Resolution

Enable the ‘Generate Excel 2010 Output for Adhoc Reports’ option from provisioning for the instance.

Keywords

KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SuccessFactors Workforce Analytics 1207 ; SuccessFactors Workforce Analytics 1210 ; SuccessFactors Workforce Analytics 1302 ; SuccessFactors Workforce Analytics 1305 ; SuccessFactors Workforce Analytics 1308 ; SuccessFactors Workforce Analytics 1311 ; SuccessFactors Workforce Analytics 1408