Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

MDX YTD formula

Received Response
111
Views
2
Comments
Vijaykumar Yes
Vijaykumar Yes Rank 3 - Community Apprentice
in Oracle Analytics Forum

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)

also tried sum, but we have more then two intersections it did not worked

-Vijay

Version

11.1.2.4

TIME.PNG

Answers

  • GlennS_3
    GlennS_3 Rank 4 - Community Specialist

    Have you considered splitting it into two dimensions?  Adding an analytics or "View" dimension where you load all of the data to MTD and calculate QTD and YTD. That way the user has flexibility in what they see.

    I did not see  the attachment of the outline structure to see what you have

  • Vijaykumar Yes
    Vijaykumar Yes Rank 3 - Community Apprentice

    attaching the time hier..

    at this stage we not in a position to split the dim.. but we have an alternative YTD hier...

    we need this function to use in MDX calc