WITH
SET Set1 AS
        Head([Due Date].[FY Hierarchy].Children, 1)

SET Months AS
    Generate(
        Set1
        , Descendants( [Due Date].[FY Hierarchy].CurrentMember, 2)
        )

SET Set2 AS
    Head(
        Except(
            [Due Date].[FY Hierarchy].Children
            , Set1
            )
        , 2
        )

SET Quarters AS
    Generate(
        Set2
        , Descendants( [Due Date].[FY Hierarchy].CurrentMember, 1)
        )

SET Years AS
    Head(
        Except(
            [Due Date].[FY Hierarchy].Children
            , {Set1, Set2}
            )
        , 1
        )

SET Details AS
    {Months, Quarters, Years}

SELECT [Measures].[Sales Amount - Fact Reseller Sales] ON Columns
, [Due Date].[Fiscal Year].Children * Details ON Rows
FROM [Adventure Works DW]