HI people!

My query:

SELECT
{ [MyDimension].[MyMembers]} ON COLUMNS ,
{ [Measures].[MyMembers] } ON ROWS
FROM [MyCube]
WHERE [Time].[2004].[Quarter 4].[November]

I want total between today and today- (today,last year),
last 30 days and
last 7 days.


so I've tried something like this with VBA functions, but no success:

WHERE StrToMember("[Time].["+ CSTR(YEAR(NOW())+"].[Quarter
4].["+CTR(MONTH(NOW))]")>CSTR(YEAR(NOW())-1

Does anybody know how to do that?
Any help would be appreciated. Thanks.

Vlado.

You need to create calculated member:

WITH MEMBER [Time].Total AS ' Aggregate( {[Time].[2003].[Quarter
4].[November], [Time].[2004].[Quarter 4].[November]} ) '
SELECT
{ [MyDimension].[MyMembers]} ON COLUMNS ,
{ [Measures].[MyMembers] } ON ROWS
FROM [MyCube]
WHERE [Time].Total

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================