5 Replies Latest reply on Oct 12, 2016 4:23 PM by Gianni Ceresa

# how to make variance Calculation row wise in obiee?

Hi, I need variance Calculation row wise in obiee . We calculated this in excel by (((2014 year row- 2015 year row)/2015 year row)*100), same we need in obiee report in pivot view.

Regards,

• ###### 1. Re: how to make variance Calculation row wise in obiee?

Hi,

The easier way to do that kind of calculation is by using the AGO function, so on the 2015 row you can retrieve the 2014 figures and make your calculation.

• ###### 3. Re: how to make variance Calculation row wise in obiee?

Ago will give the previous year data. As we dont want to see previous year data, we want to see variance with previous row.

Number of rows will be based on year prompt. User may select any number of random year..like 2000,2004,2006, 2009 etc.

so we need to always show variance with previous row(Not with previous year)

• ###### 4. Re: how to make variance Calculation row wise in obiee?

Stop thinking in terms of rows ... lagging on a row to get a variance will produce inconsistent results if the query grain changes (and it becomes unusable).  Using the time-series functions can give you a dynamic way to show the % change and variance between periods consistently independently of the query grain (much more re-usability and less to maintain).

Your example has Month and Year ... so the logical built-in function would get you the same period a year ago ... change the query to the week - you end up with same week a year ago ...

• ###### 5. Re: how to make variance Calculation row wise in obiee?

Thomas Dodds wrote:

Stop thinking in terms of rows ...