SAP Knowledge Base Article - Public

2393735 - Unable to download the report in xls or xlsx from Online 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 Workforce Analytics
  • 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 - Unable to download the report in xls or xlsx - ORD - Download report - export report , KBA , LOD-SF-WFA-DES , Report Designer , Problem

Product

SAP SuccessFactors Workforce Analytics all versions