Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Limit Date Prompts in OBIEE
Hi All,
Am using obiee 12c and my requirement is, there is date field and in dashboard prompts I have to split it as Date Start and Date End as two filters.
Based on value selected in Date Start the value for Date End should limit for 7 days only. i.e The user strictly want to see only 7 days (1week) data.
For eg:
If User Selects Date Start: 11/1/2017 then Date End should be restricted to 11/7/2017.
If User Selects Date Start: 11/5/2017 then Date End should be 11/11/2017
For any value of Date Start selected the End Date should be +7, How can this be achieved in OBIEE prompts.
Any help would be greatly appreciated.
Thanks,
LonaD
Answers
-
Not possible in OBIEE Unless you maintain a separate table with regular dates and end date( date+ 7) in DB. Then you can pull in OBIEE prompts and use it.
Thanks
Venkat
0 -
Yes, this is possible. Here is how you can do it. Use presentation variable pv_start date in start date ..then user that in second end_date …
SELECT
TIMESTAMPADD(SQL_TSI_DAY,7,"Usage Tracking"."Time"."Start Date") s_1
FROM "Usage Tracking"
0 -
I think I was wrong. It does take from default value and then does not refresh subsequently.
Thanks
Arijit
0 -
if it is always +7 then have the user select a date, and you have a hidden request that has the date + 7, then set your main request to use that hidden request as a filter on any date in it.
0 -
Hidden request is something like conditional reporting i have to implement is it ? or How to set main request to use the hidden request as a filter ?
Am sorry i didn't get.
0 -