COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: sworios on 04 Jul 2014 03:13:54 AM

Title: Scheduled report 1st day working of each month
Post by: sworios on 04 Jul 2014 03:13:54 AM
Hello there,

I wish to schedule a report for the 1st day working of each month in Cognos 10.

for example: 1st June is a Sunday, so the launch of the report Monday, June 2

Is this possible?

Thank you in advance
Title: Re: Scheduled report 1st day working of each month
Post by: jmills on 04 Jul 2014 10:55:06 AM
In the schedule settings, click on the By Month tab.  In there, you have the option to select the first Monday of every month.
Title: Re: Scheduled report 1st day working of each month
Post by: JBCLARK20 on 28 Jul 2014 02:17:23 PM
We  encountered a similar issue as Cognos does not provide Workday Calendars.
We created our own workday calendar table including the workday, and the workday date ie WD1, 1-Jul-2014.
The Workday calendar is added to a package. The package is referenced in the event.
Now we can schedule reports using events where Current_date =  Workday_ date and workday = 'WD1'.

Hope this helps.