Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FoodMart2000, this query returns 0 months for my predefined quarters

Status
Not open for further replies.

Shab

Programmer
Oct 9, 2001
60
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top