Scheduling report to run on 3rd working day of month

[amit.surrey]

Hello All,

Sorry if this question is asked before but I am a total novice in Cognos.

I need to schedule report to run on 3rd working day of every month.

Is there a calculation I could use in Event Studio without making changes to Framework.

Any help is greatly appreciated.

Thanks
AA

[New_Guy]

Hi,
You can do this by scheduling, no need of event studio for this purpose. Check the scheduling icon for the report.
Good luck
New guy

[amit.surrey]

Thanks for the response New Guy.

In the regular scheduling, I have options for Calendar days and not working days.

I do not want to send report if working day 3 is a saturday or sunday.

[New_Guy]

Hi,
Sorry about that, I ignored 'working day' in your post.
We can use day of week and first of month and add days functions to create a condition using event studio. Let me try and will get back to you.
Good luck
New guy

[amit.surrey]

Thanks New Guy.

Sent from my ONEPLUS A5000 using Tapatalk

[BigChris]

How would you deal with holidays etc.? I get that you can work out the standard 3rd working day...but if there's a national/statutory holiday in the middle of those three days it'll throw it all out of sync.

[amit.surrey]

Hi BigChris,
I am not too worried about the national holidays. I just need help with standard 3 working day calculation.

Sent from my ONEPLUS A5000 using Tapatalk

[BigChris]

Ok, in that case you can probably use something like this:

Code Select Expand

_add_days(_first_of_month(current_date),
case _day_of_week(_first_of_month(current_date,),1)
when 1 then 2
when 2 then 2
when 3 then 2
when 4 then 5
when 5 then 5
when 6 then 5
when 7 then 4
else 0
end)
= current_date
You'll obviously need to do your own testing, but that should get you started at least. I've assumed that if the 1st of the month is a Monday then you want the schedule to fire on the Wednesday...but if that's not right then you'll need to tweak the number of days to add in the case statement.

[amit.surrey]

Thanks BigChris. Great help.

Sent from my ONEPLUS A5000 using Tapatalk