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

Question

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.

User_QVJMI · Answer

Hey Joel, Thank you for answering.

How will be I able to pass 2 presentation variable in a single Add_months(date,n) formula.

I have 2 presentation variables: Month and Year.

Joel Acha · Answer

Have you tried using the ADD_MONTHS function?

ADD_MONTHS( date, n )

Where n is the number of moths you want to add. In this case, set that to -12 in order to go back 12 months. You can then do a BETWEEN filter of the 2 dates.