title: How to show one value for all days of month in obiee?
body: <p>It might seem strange but I have a requirement to show one value for all days of a month. </p>
  
  <p>In database, there are records only for the first day of months. When I create analysis in BI with day prompt, obviously I get null values for every day except the first day of a month. How can I fix this measere(value in 01.01.2018, 01.02.2018 etc.) for all days? Of course when months changes column should present the value of first day of the next month. 
  Is there a way to do this?</p>