• Hi.

    You need to specify the TType as a set:

    SELECT NON EMPTY { [Measures].[Alternate Single Manager],

    [Measures].[Retail Structured] } ON COLUMNS,

    NON EMPTY { ([Agent].[Agent Consultant].[Consultant Id].ALLMEMBERS ) }

    DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

    FROM ( SELECT ( [Fund].[Fund].[All]) ON COLUMNS FROM ( SELECT ( [Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1732],[Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1733]) ON COLUMNS

    FROM [Cube])))

    WHERE ( [Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1732],[Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1733])

    CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

    becomes

    SELECT NON EMPTY { [Measures].[Alternate Single Manager],

    [Measures].[Retail Structured] } ON COLUMNS,

    NON EMPTY { ([Agent].[Agent Consultant].[Consultant Id].ALLMEMBERS ) }

    DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

    FROM ( SELECT ( [Fund].[Fund].[All]) ON COLUMNS

    FROM ( SELECT ( { [Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1732],

    [Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1733] } ) ON COLUMNS

    FROM [Cube])))

    WHERE ( { [Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1732],

    [Transaction Type].[Transaction Type Hierarchy].[Transaction Type Detail].&[1733] })

    CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

    You also do not need the where clause, you already have the data in the subselect.

    Hope this helps,

    Nick.