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)"

(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

OBIEE Difference between two rows

Found this one on the OTN Forum:

http://forums.oracle.com/forums/thread.jspa?threadID=692479&tstart=30

Handy when your database doesn't have a Lag or Lead function

Till Next Time