Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
MDX YTD formula — Cloud Customer Connect
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

MDX YTD formula

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

Summary

not able to calc YTD members

Content

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.

Register

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