Schedule Reports - First business day of the month

[dssd]

Can i schedule a report to run on every first business day of the month?

[PRIT AMRIT]

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

[johnbdmills]

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.