Forum Stats

  • 3,757,494 Users
  • 2,251,236 Discussions
  • 7,869,844 Comments

Discussions

Last 3 months data dynamically

Hi Team,

We have Date_1 column with timestamp data type (9/30/2010 12:00:00 AM), we converted to month year format as Date_2 (SEP 2010) and using converted format Date_2 in the report and graph.

Also we are using Date_2 as dashboard prompt requirement is, in the report and graph when we open by default it as to show last 3 months data and it as to change dynamically every month.

As of we are hardcoding using presentation variables every month can anyone suggest how we can achieve this dynamically.

Version we are using: OBIEE 12.2.1.4.0  

Regards,

Tagged:

Comments

  • "We have Date_1 column" ==> You're not giving your columns an understandable and usable name?

    " report and graph" ==> Are you talking about analyses or reports? Analyses are analytics. Reports are BIP. Totally different technologies.

    "As of we are hardcoding using presentation variables every month" ==> How? You actually go into the RPD manually and set a value??

  • Newuser1
    Newuser1 Member Posts: 280 Blue Ribbon
    edited May 25, 2021 3:18PM

    Hi Christian,

    thanks for the reply find the below comments.

    ---- Column we are using Start_Date and converted to month year format (SEP 2010) in RPD level.

    ---- Directly using from RPD level in the OBI report and Graph.

    ---- Also we are using converted date format as prompt, for getting last 3 months data by default into the report and graph, created presentation variables date in the prompt and added filters as below.

    ---- How we can do this dynamically instead of changing every month hope this makes sense.

    Regards,

  • "How we can do this dynamically instead of changing every month hope this makes sense."

    No, because you didn't answer my question on HOW you set that? Precisely, in detail, with screenshots.

    Also please re-read the post above: What do you call "report" is most likely an "analysis" but please clarify as reports and analyses are two different object types from two different products and technologies.

  • User_AWXWU
    User_AWXWU Member Posts: 4 Green Ribbon

    Hi,

    You can try creating a repository variable CURRENT_MONTH with format you need and use CURRENT_MONTH,CURRENT_MONTH-1 and CURRENT_MONTH-2 in your filter.

    Thanks,

    Swathi