Skip to Content


The following dashboard best practices are taking from the presentation that Romaric Sokhan and Alexandre Dussac of SAP will be giving at their hands –on lab at BI 2013 Amsterdam.  This session was completely full at BI 2013 Las Vegas, and will be held in Amsterdam 11-13 June.  See www.sapbi2013.com 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 until the last one completes)

Run queries after dashboard has initialized

Do not run queries during Initializing … message

  • Edit query –> Usage Options

/wp-content/uploads/2013/04/pic2_204092.jpg

  • Deselect Refresh Before Components Are Loaded

Run queries after Initializing … message

  •     Add a Query Refresh Button canvas

/wp-content/uploads/2013/04/pic1_203977.jpg

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

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply