• I have reproduced you requirement using a different cube. The issue is the hierarchy you have chosen to show ([Date].[Calendar Semester of Year].[Calendar Semester of Year]) is part of a user defined hierarchy and you are using a level within that. The ALL member is not available here without adding it back in using UNION. Changing the hierarchy to the attribute hierarchy would be simpler.

    WITH MEMBER

    [Measures].[ParameterCaption] AS [Date].[Calendar Semester of Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER

    [Measures].[ParameterValue] AS [Date].[Calendar Semester of Year].CURRENTMEMBER.UNIQUENAME MEMBER

    [Measures].[ParameterLevel] AS [Date].[Calendar Semester of Year].CURRENTMEMBER.LEVEL.ORDINAL

    SELECT

    {

    [Measures].[ParameterCaption],

    [Measures].[ParameterValue],

    [Measures].[ParameterLevel]

    }

    ON COLUMNS,

    [Date].[Calendar Semester of Year].ALLMEMBERS ON ROWS

    FROM

    (

    SELECT ( { STRTOSET(@Year, CONSTRAINED) } ) ON COLUMNS

    FROM [Adventure Works]

    )

    You may need to change your report dataset query to also handle the ALL item.

    Fitz