SAP Knowledge Base Article - Public

2393735 - ORD - Unable to download the report in xls or xlsx from Report Designer

Symptom

  • Unable to download the report in xls or xlsx from Report Designer
  • Runtime failure of the report when downloading in xls or xlsx format from Report Designer.

Environment

SAP Successfactors

Online Report Designer

 

Reproducing the Issue

1. Login to Analytics/ORD

2. Go to Report Designer -> Preview a report.

3. Download report in xls or xlsx format

xls.PNG

 

4. Check the Report status under "Report distributor download".

5. Report will be in Red status with Runtime failure message.

 

status.PNG

 

runtime.PNG

 

Cause

There can be multiple cause of this issue and one of them is below:

  • Measure and Dimension Permissions switch is ON although it is not a WFA instance.
  • Measure and Dimension Permissions switch must be turned off for all the non WFA instance. If it is turned ON then it will cause these failures

Resolution

  1. Confirm that the instance is not a WFA instance.
  2. Go to Admin Center
  3. Follow path : Reporting and Analytics -> Manage Workforce Analytics
  4. Check if the Switch "Measure and Dimension Permissions" is ON or OFF.
  5. Turn the switch Off and save
  6. Try downloading the report again.

MWA.PNG

Keywords

xls xlsx Report Designer Runtime Failure Measure and Dimension Permissions , KBA , LOD-SF-WFA-DES , Report Designer , Problem

Product

SAP SuccessFactors Workforce Analytics 1605 ; SAP SuccessFactors Workforce Analytics 1608 ; SAP SuccessFactors Workforce Analytics 1611