title: MDX: How to make a WHERE when a member from the same Hierarchy already is in rows or cols?
body: <p>I have a dimension called Date, with one hierarchy in it (default).</p>
  
  <p>From that I want Months on rows and filter on Year = 2014.</p>
  
  <p>This doesn't work:</p>
  
  <pre><code>SELECT 
    [Date].[Month].Members ON 0,
    Measures.Amount ON 1
  FROM [GL]
  WHERE [Date].[Year].[2014]
  </code></pre>
  
  <p>I have tried with FILTER, and tuples also but nothing works. In <code>SSAS</code> (Im using Mondrian) I would use a Sub Query but there is no support for that in Mondrian.</p>
  
  <p>Does anyone know how to accomplish this?</p>