title: Add filter or where condition to MDX query?
body: <p>It should not be one difficult problem. Unfortunately I don't know how to solve it:</p>
  
  <pre><code>SELECT {[Source].[Source].CHILDREN, [Source].[Source].[All]} ON COLUMNS, 
  NON EMPTY(
      [Account].[Hierarchy].[Account Type].&amp;[Assets].CHILDREN) 
   ON ROWS  
  FROM [Test] 
  WHERE ([Measures].[Amount])
  </code></pre>
  
  <p>It works well for all the year. </p>
  
  <p>Now I want to add one time condition such as </p>
  
  <pre><code>[Date].[Date].&amp;[2005-10-03T00:00:00]:[Date].[Date].&amp;[2005-12-30T00:00:00]
  </code></pre>
  
  <p>or </p>
  
  <pre><code>[Date].[Period].&amp;[Oct 2005],[Date].[Period].&amp;[Nov 2005],[Date].[Period].&amp;[Dec 2005]
  </code></pre>
  
  <p>Can you give me some help? </p>