You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

MDX YTD formula

Received Response
edited Sep 11, 2019 5:18AM in Oracle Analytics 2 comments


not able to calc YTD members


Hi All,

we have a req. where we need to get the YTD value of current member(Select Member), so have a alternative Time hier which is called YTD

attached the hier,

EX: if users select SEP month, we need to get data for YTDSEP data and calculate a member, so I tried almost all the possibilities

Parent ([YTD].CurrentMember), result : its taking currentmember instead of Parent member  

Ancestor([YTD].CurrentMember,1), result: its taking currentmember instead of Parent member  

also tried concat but prefix(YTD_SEP) YTD is in the beginning, concat will only if YTD is suffix(SEP_YTD)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!