Hyperion Essbase (MOSC)

MOSC Banner

Calculation Function equivalent to MDX ".lastchild"

edited Oct 16, 2012 8:02AM in Hyperion Essbase (MOSC) 4 commentsAnswered ✓
Hi all,

In a calc script i have to check if the current lvl 0 member of the time dimension is the last month of a quarter.

Hierachy of time dimension: Time -  Year - Quarter - Month

In mdx i would do it like this  : 

IIF(IS([Time].CurrentMember, [Time].CurrentMember.Parent.LastChild),

In the calculation script i can only say   

@CHILDREN(@PARENT (Time))

There is no "first" or "last" child possibility

I have no idea how to check this.

One thought was to use  "@NEXTSIBLING(Time)". When the current member is the last month of a quarter this function will return an empty string.

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