Wednesday, July 22, 2009

OBIEE get the previous row

Thought I had it on the blog, but couldn’t find it….. Q&D way of getting a value of the previous row:

Use MSUM (MovingSum)

MSUM("F1 Revenue"."1-01 Revenue (Sum All)",2) - "F1 Revenue"."1-01 Revenue (Sum All)"

image

(Yeah I know there better ways :-) )

Till Next Time

Stijn found the original post on this subject:

http://obiee101.blogspot.com/2008/08/obiee-difference-between-two-rows.html

3 comments:

stijngabriels said...

Hi John,

I think this is the one you mean:

http://obiee101.blogspot.com/2008/08/obiee-difference-between-two-rows.html

Stijn

John Minkjan said...

Thanks Stijn,

I really need to tag stuff better .... ;-)

John

Anonymous said...

My wish list:
1. Interaction on the calculated value in Pivot View
2. Interaction on the column header in pivot view
3. Carry the prompted values across Dashboard pages
4. Format measure values in Table view to work independently for each column

Please help me if these features are already available in current version. Thanks!