title: SSAS Handling snapshot cumulative measures
body: <p>I have project to build a Cube using Microsoft BI Stack to handle Project Progress reports.
  I have issue on how to handle semi additive or cumulative measures.</p>
  
  <p>I now receive monthly or weekly reports that show something like :</p>
  
  <ul>
  <li>Project Original Value</li>
  <li>Value Added This Report</li>
  <li>Current Project Value (which is Original + Total Value Added Till Now)
  For each Project currently present in the Company.</li>
  </ul>
  
  <p>I believe i should design a snapshot type warehouse each row is the report for that project that just arrived.</p>
  
  <p>I am not sure however how to handle the measures of Current Project Value, where its possible for user to know what is Total Value of Projects for a year , which would be the Sum of the Last Reported Value for the projects that came during that year . Or view this measure by Country or Department.</p>