Hyperion Essbase (MOSC)

MOSC Banner

Is there something like NextSibling which chooses the next lvl 0 member - Dec2012 --> Jan_2013

edited Aug 5, 2013 5:59AM in Hyperion Essbase (MOSC) 5 commentsAnswered
Hi All

I have a time dimension with the hierachy  Year - Quarter - Month.

When the current member is on november it is easy to get the next month with @NextSibling or @ShiftSibling BUT

when the current member is december these function doesn't deliver january of the next year. Is there any function to handle this?

As a workaround i asked for the year (I did this with a substring and not with the parent function because the variable is no member of the time dimension) and selected the next member here and then choose january with the concatenate function

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