Complicated schedule for Cognos report

Hello,
I need to create schedule, based on day of week and time.
Here is requirement for schedule:
Report should run each business day at 08:00 A.M and return data for:

ProcessStartTime (some data item) BETWEEN
MON run - data from prior FRI 04:00 P.M. and today MON, 08:00 A.M.
TUE run - data from prior MON 04:00 P.M. and today TUE, 08:00 A.M.
WED run - data from prior TUE 04:00 P.M. and today WED 08:00 A.M.
THU run - data from prior WED 04:00 P.M. and today THU 08:00 A.M.
FRI run - data from prior THU 04:00 P.M. and today FRI 08:00 A.M.

Any suggestions, please.
Thank you,
- Boris

GIBoris
Profile Answers by GIBoris Questions by GIBoris
May 18th, 2011
4
6602

Questions by GIBoris

Cognos

Answer

Showing Answers 1 - 4 of 4 Answers

shailendra32
Profile Answers by shailendra32

Jul 23rd, 2011

Since you want data for last one week so put condition on the report to fetch data only for last week.
While creating schedule you can click check boxes for the required days.
let me know if you need any help.

Neeraj Shukla

Apr 5th, 2013

Create a radio button on the report and set its value Sch, create a filter on the report and set it like that

case when dayofweek is monday then (somedate between (currentdate-2 day)+8:00:00 and current date 4 hrs)
else somedate between (currentdate-1 Day)+8:00:00 and current date + 4 hrs)
end