COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: swarupa on 05 Feb 2016 11:11:52 AM

Title: cognos report should run on first working day of every month
Post by: swarupa on 05 Feb 2016 11:11:52 AM
Hi All,

I have requirement that cognos report should run automatically on first working day of each month.
I have CURR_BIZ_DT, PREV_BIZZ_DT and NXT_BIZ_DT fields in Date Table.

Please suggest step by step how to achieve this functionality.
Thanks in-advance!
Title: Re: cognos report should run on first working day of every month
Post by: BigChris on 01 Apr 2016 06:20:15 AM
And what do those fields represent?
Title: Re: cognos report should run on first working day of every month
Post by: a3nCognosUser on 08 Apr 2016 03:00:06 PM
Just a few thoughts, not sure if you looked at them all.

1. Have you checked the Event Keys? (go to Manage the task execution rules... , Event Keys)
2. Have you checked under Manage the task execution rules... , Event Selection? It has to be set for each of the tasks in the Event separately. We normally set it to New Events only, then make sure that he shceduling is appropriate.
3. Also check that the Event is scheduled properly: Schedule the agent...



Title: Re: cognos report should run on first working day of every month
Post by: karuna79 on 08 Apr 2016 04:05:47 PM
Hi,

What are these 3 dates represent and may be you should use event studio for schedule.
The holiday and weekends listed in your table.