title: Aggregate dated events in Analysis Services OLAP Cube
body: <p>I have a table with columns that store dates of various events, like so:</p>
  
  <pre><code>&lt;pre&gt;
  PersonID  DatePassedExam1 DatePassedExam2
     1      NULL            NULL
     2      01-11-2012      NULL
     3      01-12-2012      10-12-2012
  &lt;/pre&gt;    
  </code></pre>
  
  <p>I want to build a cube to see counts of people who have passed exam1 and exam2 by person attributes and time, e.g. year to date.</p>
  
  <p>So,  </p>
  
  <pre><code>YTD for Oct2012: exam1count=0, exam2count=0  
  YTD for Nov2012: exam1count=1, exam2count=0  
  YTD for Dec2012: exam1count=2, exam2count=1  
  </code></pre>
  
  <p>I'm guessing this needs semi-additive aggregation?</p>
  
  <p>I can't make changes in the database (without difficulty) and am not using Enterprise edition.</p>
  
  <p>Any advice gratefully received.</p>
  
  <p>Thanks,
  Dal</p>