title: Merging two tuples in the same hierarchy into one (in MDX WITH SET command)
body: <p>The following MDX query returns measure X on 3 tuples: 2001, 2002-1 and 2002-2. What I am trying to do is merging 2002-1 and 2002-2 into one tuple and have the measure X for 2001 and 2002-1&amp;2. Using SUM function is not possible. Because measure X is used on other axis.</p>
  
  <pre><code>with 
  member v as [Measures].[X]
  set w as {[Dim Date].[Calendar Date].[Year].&amp;[2001],
  [Dim Date].[Calendar Date].[Month].&amp;[1]&amp;[2002],
  [Dim Date].[Calendar Date].[Month].&amp;[2]&amp;[2002]}
  select w on 0, v on 1
  from [DS];
  </code></pre>