OBIEE YTD Issues
<p>I have a fact table housing different granularity (date grain)</p>

<ol>
<li><p>Monthly </p></li>
<li><p>Daily</p></li>
</ol>

<p>The month data can be accessed by filtering by end of month date or using YYYYMM date format. In OBIEE RPD repo, the fact is set to LAST Aggregation.</p>

<p>I want to perform Year to Date analysis. And I want to sum only month end dates. </p>

<p>Using function TODATE(Measure), it tends to sum up all the data through out the month e.grain</p>

<pre><code>Date            Amount  YTD TODate(Amount)
31/01/2106      100     100
28/02/2016      200     300
14/03/2016      50      350*
31/03/2016      100     450
</code></pre>

<p>I want YTD to ignore 50 and return 400, so also any other dates that falls within any month. And if if I Select 14/03/2016 I want 350 to return.</p>

<p>Thanks.</p>