
WITH 
	member [Time.defaultHiera].[All Time].[Aggr] as 'Aggregate({[Time.defaultHiera].[All Time].[2009], [Time.defaultHiera].[All Time].[2008]})'

SELECT 
NON EMPTY {Hierarchize(Union({[Time.defaultHiera].[All Time].[2008]}, {[Time.defaultHiera].[All Time].[2009]}, {[Time.defaultHiera].[All Time]}))} on columns,
NON EMPTY {Hierarchize(Crossjoin(Union([Customers.defaultHiera].[All Customers].[France].children, {[Customers.defaultHiera].[All Customers].[France]}, {[Customers.defaultHiera].[All Customers]}), {[Measures].[Quantity]}))} on rows
FROM [Sales Analysis]
WHERE ([Customers.defaultHiera].[All Customers].[France],[Time.defaultHiera].[All Time].[Aggr])
