Hyperion Essbase (MOSC)

MOSC Banner

12 Month Avg & Total Calc both Income Statement & Balance Sheet Accounts

edited Jan 10, 2012 6:38AM in Hyperion Essbase (MOSC) 1 commentAnswered
Need 2 difference calcs:  one for Balance Sheet & Income Statement

Calc for a 12 Month Rolling Avg using MDX Function in ASO Cube

Case when (IsLeaf([Month].currentmember) and not (IsEmpty([Month].currentmember))) then
AVG (
{TUPLERANGE(
   ([Fyear].currentmember.lag(1), [Month].currentmember.NextMember), ([FYear].currentmember.lag(1), [Dec])),
  TUPLERANGE(
    ([FYear].currentmember, [Jan]), ([FYear].currentmember, [Month].currentmember))})
Else
   Missing
END

However this DOES NOT Work if the 12th month has a zero balance.   The calc brings back a zero

Same happens for the 12 Month Rolling Total (Want the total for the past 12 months)  here is that MDX Function from the ASO Cube

Case when (IsLeaf([Month].currentmember) and not (IsEmpty([Month].currentmember))) then

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center