Extra Pages

▼

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

at

3 comments:

  1. stijngabrielsJuly 22, 2009 at 9:47 PM

    Hi John,

    I think this is the one you mean:

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

    Stijn

    ReplyDelete
  2. John MinkjanJuly 23, 2009 at 7:52 AM

    Thanks Stijn,

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

    John

    ReplyDelete
  3. AnonymousJanuary 22, 2010 at 5:01 PM

    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!

    ReplyDelete

Note: Only a member of this blog may post a comment.