1 Reply Latest reply: Jan 25, 2013 12:08 AM by user12301120 RSS

    How to Calculate Leap Year ago in OBIEE 11g

      Hi Gurus,

      I have one fact table and having one measure column. I have to calculate current year and Last year.

      Using Time series function (Todate,Ago) have calculated current year as well last year also.
      The problem is Current year is showing correct value only but Last year was showing wrong data.

      We found the problem is Leap year, last year FEB month is having 29 dates. Due to this we are getting wrong date.

      Kindly suggest me how to achieve this requirement.