How to show last 3 weeks in obiee 10g reports? — Oracle Analytics

Oracle Analytics Cloud and Server

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

How to show last 3 weeks in obiee 10g reports?

Received Response
81
Views
5
Comments
Obiee_Developer1
Obiee_Developer1 Rank 2 - Community Beginner

How can i show data of the last 3 weeks in obiee 10g? I don't wanna change anything at the back end. I would like to know fix at the front end like in the dashboard or analysis. Attached is the snapshot of the columns under TIME table. Which one to use and how please?Capture.PNG

Answers

  • 1008490
    1008490 Rank 3 - Community Apprentice

    Create a filter or Column which displays greater than last three week.

    1. Create Var_Current_Week Variable (Always give current Week)

    2. Put a filter condtion like

    Current_Week>VALUEOF("Current_Week")-3

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    If you just want to change in the front end and nothing in bi rpd, there is two ways:

    1. First, if you have a evaluate function enable you could use, the functino of your database to get the value into a presentation variable.

    2. And you could use TimestampAdd(interval, intExpr, timestamp), and use the Interval which in you case is SQL_TSI_WEEK.

    Kind Regards,

  • Obiee_Developer1
    Obiee_Developer1 Rank 2 - Community Beginner

    Capture3.PNG

    Capture4.PNG

    Capture5.PNG

  • Obiee_Developer1
    Obiee_Developer1 Rank 2 - Community Beginner

    Which variable am i supposed to create. I created presentation variable and got this error. I am totally newbie so please help?

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    If you are simply wanting to always return data that is within the past 3 weeks, then why can't you just add a filter to your report that is something like this:

    "Date"."Date" is greater than or equal to timestampadd(sql_tsi_day,-21,current_date)

    I use the '-21' because there are 21 days in a 3 week period.

    I am using "Date"."Date" as an example. You would need to replace it with whatever date you are using from your date dimension.