Archive for category Business Objects

03/31/10: SAP achieves awareness.

04/01/10: The end of life as we know it.

(Cue Terminator theme.)


This was the page that loaded when I logged into the SAP BusinessObjects Innovation Center (formerly BusinessObjects Labs) today.


No Comments

How to reduce “glitz” in Xcelsius


I thought this thread was too valuable to remain buried on the Perceptual Edge message board.  “Candy-like” is the adjective I often use to describe shiny, round, three-dimensional-looking dashboard components, and Xcelsius is incredibly candy-like if you don’t make the effort to create a clean, professional dashboard.  Even the samples on the SAP website are enough to offend anyone’s Tuftean sensibilities, also frequently lacking the appropriate data context required for quick analysis.

Here are some takeaways from the thread:

  • Apply a skin like Halo or Windows Classic instead of the default, Aqua (you can permanently change your default theme under File, Preferences, Document)
  • Remove gridlines when not they’re not necessary, e.g. when the purpose of a chart is to provide relative comparisons, not quantitative precision
  • Show limits on circular, horizontal, and vertical gauges; show targets when feasible, e.g. when target locations will be static, not moving with scaling axes
  • You can create sparklines with tiny line graphs with all labels, axes, etc. disabled
  • Create multiple bullet charts with a stacked bar chart (targets) overlaid with a bar chart (actual), provided that they share a scale, which works best with percentages


And a few things I would add that were not mentioned in the thread:

  • Left-align titles and subtitles
  • Subtitles, help text, and axes should be a lighter shade than the axis labels, dimension labels, and data itself
  • There is a free add-on for Xcelsius 2008 that allows you to create basic bullet charts and sparklines without employing workarounds (scroll to bottom of linked page)

While on his site, I also noticed that Stephen Few has a new book coming out June 1.  Preorder!



No database tables showing in Business Objects Designer

Has this ever happened to you?


You’re in Designer, minding your own business, trying to build a universe on top of SQL Server 2005 data, and you have no database tables in the table browser.  The connection works fine when you test it, you’ve double-checked the ODBC DSN, and everything seems normal.  I see this fairly often – especially when using VMs, where the software is infrequently maintained.  (That’s a little hint as to the cause of this problem.)

Check that the instance of SQL Server 2005 hosting your default database is up to date on its service packs.  You just need to be up to date through SP2 to resolve this.  Proof that it works:


Here is a screenshot from the About panel of the updated SQL Server instance with version information: