• 1. If you want only few members to show in dimension, use the view and modify view to show whatever members you need.

    2. In Dimension, if you want to see all members, for measures you want to aggregate all closed members. you can use following peseudo code(CELL CALCULATION)

    MEMBER [Measures].[Some Measure]

    AS

    ([Measures].[Amount],[Project].[Status].current member]

    CELL CALCULATION Closed

    FOR ''(([Measures].[Amount],{[Project].[Status].[Closed1],[Project].[Status].[Closed2]}))'' AS [Measures].[Some Measure Closed]