Expand +



Dashboarding Tips from BI 2013 Hands-on Lab: Dashboard prototyping with SAP BusinessObjects Dashboards 4.0

by Bridget Kotelly

April 9, 2013

The following dashboard best practices are taken from the presentation that Romaric Sokhan and Alexandre Dussac of SAP will be giving the Hands-on Lab: Dashboard prototyping with SAP BusinessObjects Dashboards 4.0 at BI 2013 Amsterdam.  This session was completely full at BI 2013 Las Vegas, and will be held in Amsterdam 11-13 June.  See for more information.  

Understanding dashboard initialization time

Six main factors to consider

    1. Size of the dashboard flash file (.SWF)
    2. Number of components
    3. Number of Excel cells used
    4. Amount of Excel calculations used
    5. Number and size of bindings to Excel ranges
    6. Number of queries or connections set to refresh during the Initializing … message (waits u ntil the last one completes)

 Run queries after dashboard has initialized

Do not run queries during Initializing … message

  • Edit query --> Usage Options

  • Deselect Refresh Before Components Are Loaded

 Run queries after Initializing … message

  • Add a Query Refresh Button canvas

  • Select queries to run
  • In Trigger Behavior, select
  • Refresh After Components Are Loaded

 For more information, on this Hands-on sessions and others, visit the web site at and follow me on Twitter @BridgetKotelly. 

An email has been sent to:

More from SAPinsider


Please log in to post a comment.

No comments have been submitted on this article. Be the first to comment!