title: Default Prompt to first day of current month on OBIEE
body: <p>I have a Analysis created in OBIEE 11G, by default I want it to have the default values in: <em>is between</em> <em><strong>Calendar Date</strong></em>  <em>[First day of current month] - [Yesterday]</em>. For the first day i use the following (but didn't work):</p>
  
  <pre><code>TIMESTAMPADD (SQL_TSI_DAY, (DAYOFMONTH (CURRENT_DATE) * -1) + 1, CURRENT_DATE)
  </code></pre>