How to show a Ratio in dashboard

other Performance Management
1

Hi,

I am trying to do some dashboards based on a universe. The main measure I would LIKE to use is a ratio

Loss Ratio = Sum(Loss)/Sum(Earnings).

Unfortunately though, since it is a ratio which would need to be aggregated correctly, I cannot make it a measure and need to do it at the report level if I were using it in WebI.

However my main requirement is for dashboards, and this ratio is what I would mainly like to show against several dimensions. How do I accomplish this?

Is there some way of creating metrics, or specifying formulas(like measures) in creating a dashboard?

I am using BO XI.

Please help.

Thanks & Regards,
Rekha.

rekha_bo (BOB member since 2005-09-16)

2

It is possible to have a ratio defined as an object in the universe to be used by AF.

Create the measure object as SUM(tableA.column)/SUM(tableB.column) in the universe. Add the AGGR=SUM text to the description field. This will tell AF that the measure object is already aggregated and AF itself will not try to aggregate the measure.

I hope this solves your problem.

straelet :belgium: (BOB member since 2002-08-22)

3

Hi Tom,

This does seem to work, but I am not sure. It still doesnt roll up in WebI. So I am thinking of using a variable or a formula in webi and using this object in case of dashboards.

Hopefully that should solve it.

Thanks a lot,
Rekha.

rekha_bo (BOB member since 2005-09-16)

4

I think you want to set it to AGGR=NONE

raydar (BOB member since 2003-08-28)