Has anyone figured out how to Schedule a Cognos report to run MTD on (or close to) the last day of the month?
I get asked to do this a lot from Finance folks. But I don't know any way to set up the scheduler to do this since each month ends on a different date.
Solved! Go to Solution.
@SandraA - Yes, If you have Concur Intelligence Reporting, the report can be scheduled to run on the last day of the month.
-Click the schedule button for the report that you want to schedule.
-Under Frequency, select the 'By Month' tab, and then select 'Day'.
-Enter Day 31 of every 1 month(s).
Then proceed with the rest of the scheduling options.
When you select 'Day 31 of every 1 month(s)', the report will run on the last day of the month regardless of how many days are in the month.
Tom
You can use alot of the standard dates/schedules in concur.
In Intelligence, select the <MORE> option, and then <new schedule...>
I run a report that is close to last day of the month with the following.:
Play around with the standard options and you'll get something that works for you.
@SandraA - Yes, If you have Concur Intelligence Reporting, the report can be scheduled to run on the last day of the month.
-Click the schedule button for the report that you want to schedule.
-Under Frequency, select the 'By Month' tab, and then select 'Day'.
-Enter Day 31 of every 1 month(s).
Then proceed with the rest of the scheduling options.
When you select 'Day 31 of every 1 month(s)', the report will run on the last day of the month regardless of how many days are in the month.
Tom
Tom -
That's fabulous! I'd no idea that would work.
Hi TomV,
Does Intelligence (Cognos) have this capability as well ? We may be talking the same reporting tool, but want to be sure your not talking about SAP Concurs new analytics platform that they are trying to migrate everyone too .
Thanks
@ELEIBLE Tom is referring to Cognos Business Intelligence.