Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
11
Views
2
Comments
User_QVJMI
User_QVJMI Rank 3 - Community Apprentice
edited Aug 13, 2024 5:14PM in Oracle Analytics Forum

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 Rank 8 - Analytics & AI Strategist

    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 Rank 3 - Community Apprentice

    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.