Reporting question - schedule for the last day of the month

[SandraA]

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.

[DavidW]

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.

[TomV · Accepted 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

[SandraA]

Tom -

That's fabulous!   I'd no idea that would work.

[ELEIBLE]

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

[KevinD]

@ELEIBLE Tom is referring to Cognos Business Intelligence.