Comparing SETS in MDX

 

i want compare 2 sets , based on result come :

 

like  :

 

case @parameter

when @parameter set(of members or tuples)

then set , on

end

 

anybody have idea

 

thanks in advance

 

nishant

first thing comes mind is:

when intersect (@parameter, otherset).count = otherset.count

maybe better way else?

hth

george spofford

SQL Server  >  SQL Server Analysis Services