Forum Stats

  • 3,759,068 Users
  • 2,251,495 Discussions


Report: Run the report for past 1 year from Month and Year as Front End Prompt. OBIEE

Hi All,

If someone can please help me with this issue.

Business Case

Month and Year are taken as input from front end as Presentation Variable; PV_M, PV_Y. Once I select Month (March) and Year (2021) it should bring the results from last year March 2020 to March 2021.

The Issue I am facing is to built the filter in report. I have a Dimension of Calendar Date which has attributes(with example): Date (01-03-2021), Month(January, February, March) and Year(2020,2021) etc.

if Someone has developed something similar please help.