SSAS MDX named set

Question

I am trying to create a common named set with fixed members so it can be used in multiple calculated members. But for some reason, it's failing. I am new to MDX scripting. Let me know if there is an issue here.

Aggregate({[TT Collection].[TT Type].&[A]
,[TT Collection].[TT Type].&[O]
,[TT Collection].[TT Type].&[I]
,[TT Collection].[TT Type].&[J]})

Answer 1

The Aggregate function doesn't return a set. The set is what you've provided as the single argument to the function's call, specifically { [TT Collection].[TT Type].&[A], [TT Collection].[TT Type].&[O], [TT Collection].[TT Type].&[I], [TT Collection].[TT Type].&[J] }

Answer 2

Hi,
Did you have specific needs with aggregate function ?
If you only need a Named Set with only 4 members, you need only in the set expression give the four: