[Product].[Category].[(All)]		(All)		[Product].[Category].[Category]				Category
[Product].[Category].[All Products]	All Products	[Product].[Category].[All Products].[Accessories]	Accessories
[Product].[Category].[All Products]	All Products	[Product].[Category].[All Products].[Bikes]		Bikes
[Product].[Category].[All Products]	All Products	[Product].[Category].[All Products].[Clothing]		Clothing
[Product].[Category].[All Products]	All Products	[Product].[Category].[All Products].[Components]	Components



WITH 
        MEMBER [Measures].[Code Category1] AS   
        IIF('[Product].[Category].[All Products].['+ [Product].[Product Categories].MEMBER_NAME +']'='[Product].[Category].[All Products].[x Code Category]',"[Product].[Category].[(All)]","[Product].[Category].[All Products]") 
        MEMBER [Measures].[Code Category2] AS   
        IIF('[Product].[Category].[All Products].['+ [Product].[Product Categories].MEMBER_NAME +']'='[Product].[Category].[All Products].[x Code Category]',"(All)","All Products") 
        MEMBER [Measures].[Code Category] AS 
        IIF('[Product].[Category].[All Products].['+ [Product].[Product Categories].MEMBER_NAME +']'='[Product].[Category].[All Products].[x Code Category]',"[Product].[Category].[Category]",'[Product].[Category].[All Products].['+ [Product].[Category].MEMBER_NAME +']') 
        MEMBER [Measures].[Libellé Category] AS 
        IIF('[Product].[Category].[All Products].['+ [Product].[Product Categories].MEMBER_NAME +']'='[Product].[Category].[All Products].[x Code Category]',"Category",[Product Categories].MEMBER_NAME) 
        MEMBER [Product].[Product Categories].[x Code Category] AS
        {
        '' 
        }
SELECT 
        {[Measures].[Code Category1],[Measures].[Code Category2],[Measures].[Code Category],[Measures].[Libellé Category] } ON COLUMNS
 
       , 
        NON EMPTY {{{
        [Product].[Product Categories].[x Code Category], 
        [Product].[Product Categories].[Category].MEMBERS 
        }}}   
        ON ROWS 
FROM 
        [Adventure Works]