BusinessObjects Board

Scorecard Alerts

other Xcelsius - Crystal Dashboard Design
#1

Hi to all,

I’m new in this forum, I hope that you can help me to solve a problem with Xcelsius. I’m sorry if my english isn’t correct.

I have a table like this below with 6 columns and some lines

Item - 1° Year - 2°Year - 3°Year- Gap 1°/2° (%) - Gap 2°/3° (%)
Cost - 100€ -
…
Production-

I try to use Scorecard to show on video the data. I’ld like, when the Gap is more than 10%, the alert advise me. This is very easy but the problem is that: if the cost go down, probably the production is higher. In other words, I’d like some lines would follow one kind of alerts and some lines would follow other rules.

Do you know some objects that are able to do that? Or do you know a trick to turn around the problem?

Thank for you help

scubidoo (BOB member since 2013-11-19)

#2

Two options:

First, can you develop logic flags in the database table? These flags would produce 1 or 2 or 3…(etc) based on case statement code. You can then easily create alerts based on values

Second, if you cannot do the first item, then create your own logic flags in Excel. Create a column next to your incoming data, and write several if statements. The Output of these IF statments will be 1 or 2 or 3 or 4…(etc). You will hide the text values of this column in a scorecard, but use alerts on this column to shade the background based on the flag value.

Cairmor :us: (BOB member since 2008-06-05)