select
    { [Measures].[Qty]} on columns,
    { [Dates].members } on rows
from TestCube

select
    { [Measures].[Qty]} on columns,
    { [Dates].[Date Desc].members } on rows
from TestCube

create table facts (
store_id int,
date_id  int,
qty	 int )

create table store (
store_id   int,
store_desc varchar( 20 )
)

create table dates (
date_id  	int,
date_desc	varchar( 20 ) 
)

with member [Measures].[MyMeasure] as
'sum(Ascendants([Dates].CurrentMember),(sum([Dates].FirstSibling :[Dates].CurrentMember ,[Measures].[Qty])))'
select
    { [Measures].[Qty], [Measures].[MyMeasure] } on columns,
    { [Dates].members } on rows
from TestCube

insert into dates values( 1 , 'Summer')
insert into dates values( 2 , 'Winter')
insert into dates values( 3 , 'Spring')