

SELECT 
NON EMPTY {Hierarchize(Union({[Time.defaultHiera].[All Time]}, [Time.defaultHiera].[All Time].children))} on columns,
NON EMPTY {Hierarchize(Crossjoin(Union({[Customers.defaultHiera].[All Customers]}, [Customers.defaultHiera].[All Customers].children, [Customers.defaultHiera].[All Customers].[Australia].children, [Customers.defaultHiera].[All Customers].[Australia].[Melbourne].children, [Customers.defaultHiera].[All Customers].[Australia].[Melbourne].[Australian Collectors, Co.].children), {[Measures].[Quantity]}))} on rows
FROM [Sales Analysis]
