Limit Date Prompts in OBIEE

Question

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

Thomas Dodds · Answer

The documentation:

https://docs.oracle.com/middleware/12213/biee/BIEUG/GUID-663B5A97-06B1-4486-8C5E-4261B1758581.htm#biee0113

986359 · Answer

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.

Thomas Dodds · Answer

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.