

SELECT 
{Hierarchize(Crossjoin(Union({[Customers.defaultHiera].[All Customers].[France].[Lille]}, {[Customers.defaultHiera].[All Customers].[France].[Lyon]}, {[Customers.defaultHiera].[All Customers].[France].[Marseille]}, {[Customers.defaultHiera].[All Customers].[France].[Nantes]}, {[Customers.defaultHiera].[All Customers].[France].[Paris]}, {[Customers.defaultHiera].[All Customers].[France].[Reims]}, {[Customers.defaultHiera].[All Customers].[France].[Strasbourg]}, {[Customers.defaultHiera].[All Customers].[France].[Toulouse]}, {[Customers.defaultHiera].[All Customers].[France].[Versailles]}), Union({[Time.defaultHiera].[All Time].[2012]}, {[Time.defaultHiera].[All Time].[2013]}, {[Time.defaultHiera].[All Time].[2014]})))} on columns,
{Hierarchize({[Measures].[Quantity]})} on rows
FROM [Sales Analysis]
