row based calculations

Question

Hi,

I am using OBIEE version 11.1.1.7.15. I have an analysis that compares months vs month previous year

For example

MonthSalesSoldJan-1410045Jan-158060Feb-146645Feb-157735Mar-143423Mar-152312

I would like to add a row calculation for each month that looks at the variance between the months, like below. I tried to add a new calculated item but that would be required for each month

MonthSalesSoldJan-1410045Jan-158060Variance0.81.3Feb-146645Feb-157735Variance1.10.8Mar-143423Mar-152312Variance0.60.5

Can anyone suggest the best way to add this calculation at row level into the pivot table?

Thanks

[Deleted User] · Answer

Hehe good one.

Thomas Dodds · Answer

Your layout won't work as your Variance % is not a dimensional attribute of Time - it's a measure label.

The force of a good BI program is:

Answers at the speed of thought - can people get accurate information and does the system perform?

Delivery at the speed of business - can new insights be developed and made available before the 'window of opportunity' expires?

Don't waste good cycles after non-value-added items ...

User_97XVQ · Answer

Hi,

I followed this method, placed all measures onto row axis, month onto measure labels and measure section(one measure is required) but not giving the required layout.