SAP Knowledge Base Article - Public

2203916 - 'Could not generate the Flash file (SWF); the cause is not known.' error displayed during exporting flash/html in Dashboard Designer when Optimize Spreadsheet enabled

Symptom

  • When trying to export to Flash/Html a complex Dashboard in Dashboard designer you receive the following error message:

"Could not generate the Flash file (SWF); the cause is not known. Try again. If the problem persists, contact your customer support representative."

Environment

  • SAP Dashboards 4.1
  • MS Office 2010/2013

Reproducing the Issue

  1. Open the dashboard
  2. Put large number of formulas into the excel, and bind them to several objects
  3. Go to File->Preferences->Excel options. Enable "Optimize spreadsheet"

    pic3.png
  4. go to File->Export->Flash / Html
  5. Wait few minutes and the error message appears

 

Cause

  • Spreadsheet optimization cannot be performed since you have large number of formulas in your embedded excel sheet in your dashboard file.

Resolution

    Disable the "optimize spreadsheet" option.

  1. Open your file in Dashboard Designer
  2. Disable "Optimite spreadsheet" in File->Preferences->Excel options
  3. Save your file and restart Dashboard Designer
  4. You will be able the generate the flash file

     Please note:

  • "optimize spreadsheet" option is enabled by default
  • It will make swf run faster, but will took longer (and more resource) to generate the swf. You can use it as long as the swf generation can finish successfully.

See Also

 

Keywords

optimize spreadsheet, Could not generate the Flash file, Dashboard, DD 4.1 , KBA , BI-RA-XL-DSL , Dashboards, design-time, design on multi-source , Problem

Product

SAP BusinessObjects Dashboards 4.1