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

Obiee_Developer1 · May 27, 2016 4:48PM

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?

1008490 · May 30, 2016 5:23AM

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 · May 30, 2016 9:11AM

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 · May 31, 2016 4:36PM

Obiee_Developer1 · May 31, 2016 4:37PM

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

Chris Arnold · Jun 2, 2016 4:44PM

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.

Oracle Analytics Cloud and Server

Categories

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

Answers