This discussion is archived
9 Replies Latest reply: Mar 11, 2013 3:40 PM by 844487 RSS

Add_months function on Month Column

844487 Newbie
Currently Being Moderated
Hello guys,

I have requirement where when user select Fiscal Year and then Month (MMM-YY) in prompt report should get last 13 months data. in report i have two columns Month and Count.

Expected results are
MAR-13 12
FEB-13 15
JAN-13 16
....
MAR-12 20


up to whatever the parameter has selected -13 months.

Please let me know what should i do to get this kind of report.
I am using OBIEE 10.1.3.4.1

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points