Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Set date differentiation in BI: 7 days ago

Received Response
1
Views
2
Comments
3162914
3162914 Rank 1 - Community Starter
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

Hello,

I am using Oracle BI.

I would like to create a report to be based on the recent 7 days.

What is the formula / code to be used in BI?

Regards,

Uriel

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    CURRENT_DATE is today, so TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) is 7 days ago.

    If you add a filter on your data using that formula you get data of the last 7 days (your date >= 7 days ago).

    If you want 8 or 6 days just change the number in the formula, if you want 1 month you must change the first parameter and use SQL_TSI_MONTH.

    Look the documentations provided in OBIEE itself when you choose the formula TIMESTAMPADD for more details on how it works and the possible values of the first parameter.

  • 3162914
    3162914 Rank 1 - Community Starter

    Many thanks for your prompt reply.