O'Reilly logo

SAP BusinessObjects Dashboards 4.1 Cookbook by David Lai, Xavier Hacking

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Making component colors dynamic

SAP BusinessObjects Dashboards allows users to fully control the coloring of their components based on whatever event they desire. For example, if a major alert were to occur we would be able to dynamically change our background to red in order to signal an emergency. This is extremely useful because developers can not only dynamically control the color of bars on a chart but also the rest of the chart components such as the background and text as well.

How to do it...

  1. Take a look at the following screenshot. In cell E2 (highlighted in yellow), we have a COUNTIF statement that will set the bar color to red if any of the regions have sold a number of items less than 40, or blue otherwise.
  2. In the chart properties, go ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required