Oracle Business Intelligence

Products Banner

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

Received Response

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
    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
    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.