Create a hierarchy with country,state,city and postal code and use it in the MDX query. For ex: If the hierarchy name is Region which is part of [Dim Geography] dimension and you want to see the result for a measure 'Sales Amount' then the MDX would be:
Select [Measures].[Sales Amount] On 0,
[Dim Geography].[Regions].Members On 1
From [CubeName]
Where [Dim Employee].[EmpName].[GivenEmpName]
commented on Oct 23 2011 2:14AM