I'm trying to create a calculated member that looks ahead a year,
rather than the default behavoir of looking back a year.

WIth a time dimension of
Time
Year
Season
Month

and a meaure of [Measures].[Net Dollars], what could be used as an MDX
expression to provide a year look ahead at all Time dimension levels?

I've tried some variants as:
- (ParallelPeriod(Year,1,Time.CurrentMember.Lead(12) ),[Measures].[Net
Dollars]) where I change the lead number. This does not of course work
across all dimension levels.

- Time.CurrentMember.Lead(X)), [Measures].[Net Dollars] where X is a
number from 1 to 12. Again, this doesn't work across all time dimension
levels.

Thanks,
b.

(ParallelPeriod(Year,-1), [Measures].[Net Dollars])


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!