Oracle Business Intelligence

Products Banner

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

Received Response
4
Views
2
Comments

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.

Tagged:

Answers

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