title: MDX query date range
body: <p>I am working pentaho dashboard trying to generate report to get transaction count per day between two date. i am beginner to mdx query below query shows only two date transaction count what i want is range between. i know it how to do it on simple query</p>
  
  <p>SQL Working Query</p>
  
  <pre><code>SELECT
      DATE(modified) AS trndate,
      COUNT(id)
  FROM
      log.transaction
     WHERE  DATE(modified) BETWEEN DATE(${from_date}) AND DATE(${to_date})
  
  GROUP BY
       trndate 
  </code></pre>
  
  <p>MDX Query which shows only two date transaction instead i want range between two date</p>
  
  <pre><code>WITH
  SET [~ROWS] AS
      {[created].[2014-10-01 12:01:53.507787], [created].[2014-10-01 20:34:14.410064]}
  SELECT
  NON EMPTY {[Measures].[id]} ON COLUMNS,
  NON EMPTY [~ROWS] ON ROWS
  FROM [transaction]
  </code></pre>