COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: dssd on 13 Mar 2012 12:44:18 AM

Title: Schedule Reports - First business day of the month
Post by: dssd on 13 Mar 2012 12:44:18 AM
Can i schedule a report to run on every first business day of the month?
Title: Re: Schedule Reports - First business day of the month
Post by: PRIT AMRIT on 13 Mar 2012 02:51:35 AM
First identify your logic for the 'first business day of the month'

Then using Event Studio, you can define the expression and schedule the report based on the same.

Hope this helps. Thanks
Title: Re: Schedule Reports - First business day of the month
Post by: johnbdmills on 17 May 2012 09:45:04 AM
There is no way to do this using the scheduling options alone, but if you use Event Studio there is a method.
For example we need monthly reports to run, but not just on the 1st of the month but on the 1st weekday of the month.
So for example if the 1st of the month is a Sunday we don't want to run the report until Monday (the 2nd).
In Event Studio set up the event condition, either a real condition or otherwise. Then set up a calculation and call it say 'month_no',
the expression would be something like extract(month,current_timestamp), then use 'month_no' as the event key and schedule the event to
run every week on Monday - Friday. The event will run every week day but you condition your reports on New Events which in this case
will be when the 'month_no' changes.