ssas - Calculated measures in MDX not working -

i wanted have results this:

city zip revenue x

a | 1 | 2000 | 10000

a | 2 | 3000 | 10000

a | 3 | 5000 | 10000

b | 6 | 1500 | 3000

b | 9 | 1500 | 3000

to results, wrote mdx statement, revenue , x coming out same. thought revenue aggregated on city , each zip value same because city associated zip same. wonder if body can me out here.

with member [measures].[x] '([location].[city].currentmember, [measures].[revenue])'

select non empty { measures.[revenue], [measures].[x]} on columns, non empty { ([location].[city].[city]*[location].[zip].[zip] ) } on rows [state revenue]))

regards

you have specify explicitly need aggregated total zip code. try adding defaultmember of [zip] hierarchy in tuple, follows:

with member [measures].[x] '([location].[city].currentmember, [location].[zip].defaultmember, [measures].[revenue])'  select non empty { measures.[revenue], [measures].[x]} on columns, non empty { ([location].[city].[city]*[location].[zip].[zip] ) } on rows [state revenue])) 

the defaultmember function represents (all) member unless specified otherwise.