Oracle Analytics Cloud and Server

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

OBIEE last 7 days of data

Received Response
1097
Views
4
Comments
790283
790283 Rank 1 - Community Starter

how do I write the formula to pull the last 7 days of data from the day the report runs? I used timestampdiff(sql_tsi_day,-7,CURRENT_DATE) but that doesnt seem to work

Answers

  • If you read the error OBIEE return you when using your formula you see that TIMESTAMPDIFF is used to get the difference (in your case in days) between 2 dates, so your "-7" isn't really a date ...

    Maybe you wanted to use TIMESTAMPADD ?

    With your current parameters it will work, so if you set a filter like "date" >= timestampadd(...) you get data for the past 7 days.

  • Satya Ranki Reddy
    Satya Ranki Reddy Rank 2 - Community Beginner

    Hi,

    Follow below link. you may resoled your issue.

    TIMESTAMPS and Presentation Variables - Rittman Mead Consulting

    pastedImage_0.png

    Thanks,

    Satya Ranki Reddy

  • user9176407
    user9176407 Rank 1 - Community Starter

    Please provide the command for details of data manipulation on “XYZ” table after 17-july-2023

  • @user9176407

    Post a new question instead of commenting on a 7 years old thread.

    Also make sure to provide the minimum information for people not seeing your screen or knowing your environment: product name and version, and what means for you "command", "data manipulation", "XYZ" etc.