'SSRS parameters with combined members not working

I've created a new report parameter. It seems to work in the parameter query, and I have all the desired members in my drill-down parameter list. But, when I try to see my report in preview mode I do not have all the data: the data regarding both of the new member ([DEEM] and [Autres]) are missing.

Any help? I'm a biginner in MDX and SSRS. Here my code:

    WITH MEMBER [Measures].[ParameterCaption] AS 
[Etudes].[Niveau].CURRENTMEMBER.MEMBER_CAPTION 

MEMBER [Measures].[ParameterValue] AS 
[Etudes].[Niveau].CURRENTMEMBER.UNIQUENAME 

MEMBER [Measures].[ParameterLevel] AS 
[Etudes].[Niveau].CURRENTMEMBER.LEVEL.ORDINAL 


SET [DEEMaggregate] AS
     
        {
        [Etudes].[Niveau].&[DAES II]
,[Etudes].[Niveau].&[DEEM]}

MEMBER [Etudes].[Niveau].[Deem] AS Aggregate([DEEMaggregate])



SET [combined2] AS
    
{
[Etudes].[Niveau].&[Autres diplômes]
,[Etudes].[Niveau].&[Formation complémentaire]

,[Etudes].[Niveau].&[Licence-diplôme]
,[Etudes].[Niveau].&[Post-doctorat]
,[Etudes].[Niveau].&[Préalable DAES II]
,[Etudes].[Niveau].&[Préalable DEEM]
,[Etudes].[Niveau].&[Préalable doctorat]
,[Etudes].[Niveau].&[Préalable master]

        }
        
MEMBER [Etudes].[Niveau].[Autres] AS Aggregate([combined2])

SELECT 
{
[Measures].[ParameterCaption],
[Measures].[ParameterValue], 
[Measures].[ParameterLevel]

} 
ON COLUMNS,
 
 Union(
        Except([Etudes].[Niveau].[Niveau].ALLMEMBERS, {[Etudes].[Niveau].[All],
        [Etudes].[Niveau].&[N/A],[DEEMaggregate], [combined2]}),
        {[Etudes].[Niveau].[Deem] , [Etudes].[Niveau].[Autres]}
    )
            
ON ROWS

FROM [my cube]```



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source