BusinessObjects Board

Xcelsius export to .swf problem...

other Xcelsius - Crystal Dashboard Design
#1

Hi everyone,

This issue about exporting my Dashboard into .SWF comes up every month and its becoming frustrating. Sometimes it exports and most of the time it doesn’t.

I get the following message:
“Could not generate the Flash file (SWF); the cause is not known. Try again, if the problem persists, contact your customer support representative”.

Solutions I used before but don’t work anymore:

  1. Re-boot computer.
  2. Re-start Xcelsius.
  3. Change VLOOKUP for INDEX MATCH formulas
  4. Click somewhere in the canvas.
  5. Reinstalling

I’ve read that I have to recreate everything from scratch? Timewise this is the worst case scenario and I can’t use Paste Special Values as my dashboard has the ability to use multiple selections.

Any other possible methods?

Thank you!

Dude to Dude (BOB member since 2014-08-13)

#2

I erased some complex INDEX/MATCH formulas and it does export - however, since the data is erased it doesn’t display the desired information.

My logic was that my SWF file is trying to include those complex formulas causing the file unable to export. In different cells I equal them to where my original formula is and changed the charts ranges so it took less long formulas but this approach didn’t worked.

:frowning:

Any ideas?

Dude to Dude (BOB member since 2014-08-13)

#3

I’m curious as to why you are exporting to a SWF every month? Are you making that many changes - or are you using the cells as direct data sources? If the latter, could you create a data connection instead?

Debbie

Debbie :uk: (BOB member since 2005-03-01)

#4

Hi Debbie, thank you for you answer.

The Dashboard is published once a month, as actuals need to be reported, I only take into account the last 12 months and last 12 quarters.

The graphs are connected to the cells in Xcelsius software Excel work book as a direct data source.

What is a data connection? I’m new to using the software so I don’t have deeper knowledge but the basics.

Thank you,
Dude

Dude to Dude (BOB member since 2014-08-13)

#5

A data connection allows you to connect to a remote data source, such as a database or a WebI report. Thus, you can update the data real-time without having to change the SWF.

Lugh (BOB member since 2009-07-16)

#6

What Lugh says. If you use a connection, you design and publish your dashboard once. The data connections fire periodically (every 5 mins, every day, monthly, on a trigger - you decide), query your data source and the dashboard reflects the changed data automatically.

I’ve just completed a 24 hour test today of connecting a dashboard to a live externally-managed database - refreshing every 3 mins, to show real-time data.

You can connect your dashboard to various data sources by various means - liveoffice, web services, xml etc. I query my databases directly via a script.

Have a browse around this forum for ideas - or there are some good books out there.

Debbie

Debbie :uk: (BOB member since 2005-03-01)