Hi all,
i have started reading about analysis services, OLAP, and MDX only the last
week so execuse me if my question is a bit silly...
in my mdx query i create a set for a date range by the following
with set [DateRangeSet] AS '{[Fiscal Time].[All Fiscal Time].[2003].[Quarter
3].[March].[1] : [Fiscal Time].[All Fiscal Time].[2003].[Quarter
2].[December].[15]}'

now i want to use the Ancestorsfunction on all the set
SELECT Ancestors([DateTimeSet],Month) on columns From theCube where
[Measures].[any measure]
ofcourse this will not work because the Ancestors function works with
members only

how i'm supposed to solve this??

Mohamed Mesalem

The Generate() MDX function iterates over a set, so:

Generate([DateRangeSet],
Ancestors([Fiscal Time].CurrentMember,Month))
on columns
From theCube
Where [Measures].[any measure]

- Deepak

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