

SELECT 
NON EMPTY {Hierarchize(Union({[Time.defaultHiera].[All Time]}, [Time.defaultHiera].[All Time].children, [Time.defaultHiera].[All Time].[2008].children))} 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])
