Date Filtering

[Database Administrator]

What is the best way to create a custom set that only returns dates
past Jan 1 2008? Our date ids are INT and formatted like 20080101. I
have created this MDX statement but it doesn't return dates past Jan 1
2008.

FILTER([Retained To Create Date].[Date].[Date Name].Members,[Retained
To Create Date].[Date] >= [Retained To Create Date].[Date].[Date
Name].&[20080101])

Is there a better function than FILTER to do this? We're running SSAS
2007 SP2. Thanks.

[Database Administrator]

On Nov 14, 10:06*am, Nate wrote:
> What is the best way to create a custom set that only returns dates
> past Jan 1 2008? *Our date ids are INT and formatted like 20080101. *I
> have created this MDX statement but it doesn't return dates past Jan 1
> 2008.
>
> FILTER([Retained To Create Date].[Date].[Date Name].Members,[Retained
> To Create Date].[Date] >= [Retained To Create Date].[Date].[Date
> Name].&[20080101])
>
> Is there a better function than FILTER to do this? *We're running SSAS
> 2007 SP2. *Thanks.

Sorry... running SSAS 2005 SP2.