FoodMart2000, this query returns 0

[Shab]

FoodMart2000, this query returns 0 months for my predefined quarters, where as the way I define them, there are only one month in each.

Any idea?

WITH

MEMBER [Measures].[Count] AS 'Count(Descendants( [Time].currentmember ,[Time].[Month],SELF))'

SET [Month7_Set] AS '{[Time].[1998].[Q1].[3],[Time].[1998].[Q2].[4]}'

MEMBER [Time].[Q 3] AS 'AGGREGATE(INTERSECT(Descendants([Time].[1998].[Q1],[Time].[Month],SELF),[Month7_Set]))'

MEMBER [Time].[Q 4] AS 'AGGREGATE(INTERSECT(Descendants([Time].[1998].[Q2],[Time].[Month],SELF),[Month7_Set]))'

SELECT {[Measures].[Count]} on columns,

NON EMPTY {[Time].[Q 3],[Time].[Q 4] } on rows

from Sales

 

[MDXer]

Lets approach this a bit diffrently, what is the goal of your query. is it just to get teh values for count for qtrs 3 and 4?

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck