About Pricing Community Teams Start Free Trial

AXISHK

asked on 12/16/2014

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

Microsoft SQL Server 2008SSAS

Last Comment

AXISHK

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

12/16/2014

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

AXISHK

12/16/2014

ASKER

attached the data dimension for your reference. Tks
DateDimension.png

Phillip Burton

12/16/2014

Yes, I've seen that. My question was:

Is that reflective in what you see as the result?

AXISHK

12/16/2014

ASKER

Correct, tks

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

Plans and Pricing

Certified Expert Program

Credly Partnership

Udemy Partnership