PeriodsToDate help 1

[PerlIsGood]

I have a query that works when I feed it a specific date, but can't seem to get it to work using variable select (LastChild, etc). Trying to create two subsets one for Current YTD and one for Last YTD (ie 1-2008 to 8-2008, and 1-2007 to 8-2007, based on the last date currently in dataset)

Any advice is welcome.

with member [ChangeMonthsIncDec].[YrMonth].[YTD LY] as 
		Aggregate(
			PeriodsToDate(
				[ChangeMonthsIncDec].[Year -  Month].[Year]
				,[ChangeMonthsIncDec].[Year -  Month].[Month].[b]&[200708][/b]
			)
		)
select {
		[Measures].[Num Line Increases]
		,[Measures].[Avg New Line Size]
		,[Measures].[Avg Prev Line Size]
	} on columns,
	{
		[ChangeMonthsIncDec].[YrMonth].[YTD LY]
		,[ChangeMonthsIncDec].[YrMonth].[YrMonth]
	} on rows
from [PerformanceAtLineIncrease]

Notorious P.I.G.

 

[MDXer]

Is this a SSAS Cube?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[PerlIsGood]

Yes sorry forgot that detail.

Notorious P.I.G.

 

[MDXer]

check out this thread in the SSAS Forum

thread960-1488889

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[PerlIsGood]

Thanks Paul! Didn't see the AS forums, just what I was looking for.

Notorious P.I.G.