

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