Row based varience in OBIEE

user652652

Hi Team,

I can I get row based variance in OBIEE. Nubmer of rows will based on filter selected for year(User can select many years). Always we need to show variance with previous row data.

For example:

           Year:

Row 1   2012          100  50  200

Row 2   2013          50    50  100

Row 3              10   20   50

  var(%)                    -80%    -60%     -50%    where (10-50)/50      (50-20)/50

Joel Acha

I'm not quite clear on Row 3 in your example. Also, what is it that you're not able to achieve?

[Deleted User]

Are you just abandoning your other thread and starting a new one??

how to make variance Calculation row wise in obiee?

Gianni Ceresa

You didn't like the other answer?

Well, let me remind you what it was ...

Stop thinking in terms of rows ...

If you really want to continue to think in rows ask somebody to export you the data in Excel and continue doing your calculations there.

[Deleted User]

+1. Your approach is not how BI works.