title: MDX Dynamic Set Filter Measuers
body: <p>I am new to MDX.
  I want to create a Dynamic Set on SSAS (SQL Server 2014) where this Set filters all  Measures 
  where Measure Date is greater than the current selected date.</p>
  
  <p>Is this possible with a Dynamic Set if not which other solutions are possible?</p>
  
  <pre><code>   ID|Date      |MeasureVal
     1 |15.01.2014| 100
     2 |16.01.2014| 150
     3 |20.02.2014| 500
     4 |21.02.2014| 150
  </code></pre>
  
  <p>So when the User select this Set and the Date Filter is on 16.01.2014 it should show return Measures with Date greater than 16.01.2014. 
  From the above example it should return Measures with ID 3,4</p>
  
  <p>Here is my Try</p>
  
  <pre><code>CREATE DYNAMIC SET CURRENTCUBE.[MyTestSet]
   AS  
    Filter (
    [Production Time].[Time Hierarchy].[Date].AllMembers , 
    ( [Production Time].[Time Hierarchy].[Date].CurrentMember.member_caption &gt; "Current selected Date?" )
     ;   
  </code></pre>