title: Range parameter on the MDX-query
body: <p>I have a correct MDX-query:</p>
  
  <pre><code>SELECT NON EMPTY { [Measures].[IssueOpened] } ON COLUMNS, 
  NON EMPTY { ([Projects].[Id].[Id].ALLMEMBERS * [Priorities].[Id].[Id].ALLMEMBERS ) } ON ROWS 
  FROM [Reports]
  WHERE [CreatedOn].[Date].&amp;[2010-01-01T00:00:00]:[CreatedOn].[Date].&amp;[2010-02-01T00:00:00]
  </code></pre>
  
  <p>I need to create SSRS-report with filter on CreatedOn dimension.</p>
  
  <p>Here is my non-working solution:</p>
  
  <ul>
  <li><p>I transform query to:</p>
  
  <pre><code>SELECT NON EMPTY { [Measures].[IssueOpened] } ON COLUMNS, 
  NON EMPTY { ([Projects].[Id].[Id].ALLMEMBERS * [Priorities].[Id].[Id].ALLMEMBERS ) } ON ROWS 
  FROM (SELECT (STRTOSET(@CreatedOnDate, CONSTRAINED) ) ON COLUMNS
  FROM [Reports])
  </code></pre></li>
  <li><p>CreatedOnDate parameter (type = datetime)</p></li>
  <li><p>Set value of CreatedOnDate parameter to value:</p>
  
  <pre><code>="[CreatedOn].[Date].[" + Format(CDate(Parameters!CreatedOnDate.Value), "yyyy-MM-dd") + "T00:00:00]"
  </code></pre></li>
  </ul>
  
  <p>But when I run the report I get:</p>
  
  <pre><code>The restriction imposed by the CONSTRAINED flag in the STRTOSET function were violated
  </code></pre>