Hello,
Database: ORACLE10g
BO Version: BOXIr3
I have created a filter in Universe named as Previous N Days and the folrmula which I placed is as follows:
@Select(Time Resolutions\Five Minutes) between (trunc(SYSDATE,'DD') - INTERVAL '@Prompt('Please enter the number of previous days to retrieve','N', {'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30'},Mono,free,persistent,{'30'})' day(4)) and (trunc(SYSDATE,'DD')- interval '1' SECOND)
When I will run the report with putting the above in query filter, it will ask me for number of days and data will come for the previous N days.
Now in report I want to show the From and To date. How can I show that since with a given number how can I get the dates for which data was fetched. I tried to use the SYSDATE in formula to get the dates but its not working.
Please suggest.
_________________
Thanks & Regards,
Vijesh Chandra