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

User_QVJMI

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.

Joel Acha

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.

User_QVJMI

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.