Symptom
1. Trying to generate Table reports in XLS or XSLX format.
Environment
- SAP SuccessFactors HXM Suite
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Table Reporting
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
- Login to instance
- Navigate to Report Center
- Select any Ad Hoc report and Run it.
- Export the Ad Hoc report's output:
- Run Online and Export or
- Run Offline, choose Excel and download from Scheduled Reports
- The downloaded file is in '.xls' or '.xslx' format
Cause
Generated excel format of table report depends on the toggle configuration.
Resolution
Please create a Case with Reporting and Analytics Support team requesting to enable the below configuration via service request.
- Please turn on the AYT_ReportBuilder_MSOffice2010_1601578369 (If you had to generate in XLS Format)
- Please turn off the AYT_ReportBuilder_MSOffice2010_1601578369 (If you had to generate in XLSX Format)
Keywords
AdHoc, Table report, download, export, XLS, XLSX, Microsoft Excel 2007 format, MS Excel
Product
SAP SuccessFactors HXM Suite 2211