SAP Knowledge Base Article - Public

2659605 - Hyperlink in the embedded excel causes Dashboards to crash when previewed or saved to platform

Symptom

  • We get "could not generate the swf error" while previewing the dashboard or exporting it to swf or saving it to repository.
  • The dashboard is created in older version of Dashboards.
  • Not able to open the dashboard in the Dashboards designer after adding the url with excel hyperlink in the embedded excel.

Environment

SAP BusinessObjects Dashboards 4.2

Reproducing the Issue

  1. Open the dashboard in Dashboards 4.2 and add a url in the embedded excel with a hyperlink.
  2.  Preview or export the dashboard and we get the error "could not generate the swf error"
  3. Now save the dashboard locally and again try to open it and it will not open and will throw the error "could not connect to Microsoft Excel error".

Cause

The dashboard in the embedded excel has a url with an excel hyperlink which causes the issue.The dashboard files gets corrupted.

Resolution

Right click the cell which has the url and click on remove hyperlink.This can be done for all the hyperlinks in the embedded excel.So in the embedded excel  the url without the hyperlink should be used as the hyperlink causes the corruption.

Keywords

could not generate swf, dashboard, hyperlink, excel, not open , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.2