scorecard or grid alerts

system · November 28, 2013, 3:27pm

Hi

I am using Bo 4.0 and Dashboard design to build a dashboard.

I have data in first table. there are no thresdhold for this data, in second table there is a formula which gives us 1, 2 or 3… These values I can use to map alerts. My problem is how do I make a relationship between these 2 tables.

for example

I have my data like this

        East   West  North   South
East 50 60 40 80
West 40 30 40 50
North 50 80 40 60
South 50 70 40 80

There are no thresholds for this data…

I have a formula say if A > B then 1, if A < B then 2 else 3
where A and B are 2 dimensions called rank no. Now If I put this variable in the above table I get
       East   West  North   South
East 1 2 3 1
West 1 3 3 1
North 2 2 3 2
South 1 2 3 3

How can i use the second table to put alerts on first table…

any ideas or pointers

Thanks

rajx72 (BOB member since 2006-08-02)

system · December 2, 2013, 2:44pm

Hi

any idea guys. how to acheive this…

Thanks

rajx72 (BOB member since 2006-08-02)

system · December 3, 2013, 12:26pm

I have attached a sample that I think addresses what you were looking for. Let me know if I missed a requirement.
Sample File.zip (12.0 KB)

mtbiknole (BOB member since 2009-01-21)

system · December 3, 2013, 2:34pm

Hi mtbiknole

Could you please explain a bit. I am sorry… but I can not download anything at my work place and at home I don’t have xcelsius…

Thanks for help

rajx72 (BOB member since 2006-08-02)

system · December 4, 2013, 1:09pm

I essentially setup the excel layer as two seperate tables with the same structure. One table contains the values that will actually be output to the scorecard and the other contains the alerter values (1, 2 or 3). The table with the values is bound to the Display Data property and the alerts are bound column by column in the Alerts tab to the columns that were generated in the scorecard.

Once that is all connected then you can setup your alert thresholds and colors to match the data.

If you would like me to email the sample directly just let me know.

mtbiknole (BOB member since 2009-01-21)

system · December 4, 2013, 2:21pm

HI

could you please attach only the excel file… as it is easy for me to open and understand the logic…

Thanks for help

rajx72 (BOB member since 2006-08-02)

system · December 5, 2013, 12:45pm

There really isn’t much to the Excel layer, basically what you had listed earlier hard coded. I have attached a PDF highlighting how it is all bound to the component.

Let me know if I’m missing the mark on what you are looking for.
Scorecard or Grid Alerts.pdf (260.0 KB)

mtbiknole (BOB member since 2009-01-21)

system · December 6, 2013, 2:54am

Hi

Thanks for the Pdf… really appreciated your help… I am also doing the same, but looks like i missed something… will try again…

Update : My bad. I was doing everthing right. but the mistake I did was when setting the values for Alerts I was selectiong the whole 2nd table instead of individual cols… Thanks for help

One more stupid question… ( always wonder how it works)
say

min to 1 is green
1 to 2 is yellow
2 - 3 red

say my values are 1 , 2 3… what color will i get… (sometimes i am getting green for 1 and sometimes yellow as 1 is present in both…)

thanks

rajx72 (BOB member since 2006-08-02)

system · January 2, 2014, 10:42pm

Adjust your thresholds like this:

Min - 1.1 = green
1.1 - 2.1 = yellow
2.1 - 3.1 = red

That way, a 1 will always fall into the green threshhold, etc.

Hope this helps,
~Roxanne

Sr BI Consultant
Infosol

RoxanneP (BOB member since 2006-08-07)