Link to home
Start Free TrialLog in
Avatar of AXISHK
AXISHK

asked on

SQL 2008 SSAS MDX formula

What's the purpose of 'ANCESTOR' and .lag(1) used in the following mdx formula ? I have attached our current data dimension for reference, Tks


([Measures].[BaseAmount],ANCESTOR( [DIM DATE].[Year Group].CurrentMember, [DIM DATE].[Year Group].[Year] ).lag(1))
DateDimension.png
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AXISHK
AXISHK

ASKER

attached the data dimension for your reference. Tks
DateDimension.png
Yes, I've seen that. My question was:

Is that reflective in what you see as the result?
Avatar of AXISHK

ASKER

Correct, tks