Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to show last 3 weeks in obiee 10g reports?

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?
Answers
-
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
0 -
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,
0 -
0
-
Which variable am i supposed to create. I created presentation variable and got this error. I am totally newbie so please help?
0 -
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.
0