Hi all,

Using FoodMart 2000, I have a calculated set formed of
two quarters in 1997 and I put that on rows. For each row
I want to calculate how months are in that row. (In this
example I know the answer is 3, because all quarters have
all months, but my other cube does not have all months in
each quarter)
What I get back is 6 instead of 3. When I change the
MEMBER definiton to be like [Time_Selection].CurrentMember
or if I use Current I get #ERR as the result.

Any ideas for a workaround?

Shabnam



WITH

SET [Time_Selection] AS '{[Time].[1997].[Q1],[Time].
[1997].[Q2]}'
MEMBER [Measures].[Months_In_Quarter] as 'Count(
Descendants( [Time_Selection],[Time].[Month],SELF ))'

SELECT
{[Measures].[unit sales],[Measures].
[Months_In_Quarter]} on columns,
{[Time_Selection]} on rows

FROM SALES