BusinessObjects Board

Dashboard and Dynamic Visibility Speed

other Xcelsius - Crystal Dashboard Design
#1

I have a dashboard with 3 ‘links’ along the top which changes the components displayed using dynamic visibility, however there is such a delay now when switching between them.

Is there any workaround which will help with the speed and make the dashboard more responsive?

Hagbard (BOB member since 2013-09-23)

#2

Check this.: Xcelsius Dashboard - How to improve performance

Judia

judia (BOB member since 2008-06-24)

#3

Hi
Thanks for the reply, however this thread doesn’t really address the problem i’m having.
At the moment the data is static - there is no query being run yet, it is purely data held in excel and as such it runs quite fast.

The problem is when we are using dynamic visibility to change the components on the dashboard (not the whole thing, just 3/4 charts and some text labels).

Any other ideas?
Thanks

Hagbard (BOB member since 2013-09-23)

#4

I got a couple of Questions for you:

  1. Size of Source code = XLF file?

  2. Size of generated SWF file?

  3. Amount of data cells in underlying MS Excel?

  4. HW configuration of your laptop that is running SWF file?

  5. Version of Adobe Flash on your laptop running SWF file?

  6. How many components is your XLF using? Are you using bubble charts by chance?

  7. Are you using any of the following MS Excel formulas: VLOOKUP, HLOOKOP SUMIF, COUNTIF?

Andreas :de: (BOB member since 2002-06-20)

#5

Hi, thanks for the reply.

500kb

1.89mb

Around 5 worksheets each with about 20 rows x 20 columns each - thought for readability they’re not all holding data

It’s not the fastest but i’ve tried on much better spec’d machines and if there is a performance boost it’s minimal

I’m not sure about this, so far i’ve just been previewing it through the dashboard interface or exporting to Business Objects Launch Pad to view through web

No bubble charts, around 125 components total including labels and shapes for aesthetics. Most of which stay on screen no matter which option is selected, only the data changes - and the data changes are immediate. There are maybe 8 components which are switched out (2 sparkline charts, 3 bar charts and a handful of labels) for about the equivalent number of components.

Yes i’m using VLookup, i read this should be avoided because of performance issues, but like i said, the switching of data is fine (when this formula is in use) it’s literally the triggering of the dynamic visibility which seems to cause very noticeable delay.

Thanks

Hagbard (BOB member since 2013-09-23)

#6

Are you using more than 512 rows in any of your excel sheet???

Naveen.SAP (BOB member since 2012-11-16)

#7

If you have too many formulae and if too many vlookups, the flash will take time to process it dynamically.
I would suggest you to replace static values in place of all formuale you are using and then try to see if the dynamic visbility is now processed faster in preview. If you still have issues after replacing all formuale with hard cided values (with no formulae), then it would seem to be some flash version compatibility issue.

The first step towards resolving these kind of issues is to ste by step rule out all possibilities each at a time.

I would recommedn these steps overall:

  1. Remove all vlookups, if conditions etc in all your excel work sheets and try to run it and see if it is faster. if it is faster then you know its the formuae that are slowing it up.
  2. If thats not the case try to see if you can get rid of some components and make your file size slimmer. some components can be heavy like grid component etc.
  3. To trouble shoot closely, map a spreadsheet component and see it in real time what cells are getting populated slower.
  4. Try to see if your MS Excel has any add-ins added. for example sometimes Liuve Office add in also can create some minor performance issues.

tsarivan (BOB member since 2008-11-19)

#8

Thanks for the replies i’ll certainly take those steps to identify exactly what is causing the slow down.

Hagbard (BOB member since 2013-09-23)