SAP Business Exchange
cancel
Showing results for 
Search instead for 
Did you mean: 
SandraA
Routine Member - Level 2

Reporting question - schedule for the last day of the month

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.

 

 

Sandra Ahola
T-Mobile
Senior Analyst Travel, Card & Expense
US
https://www.linkedin.com/in/sandra-ahola-4704553/
1 Solution

Accepted Solutions
TomV
Occasional Member - Level 2

Re: Reporting question - schedule for the last day of the month

@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

3 Replies
DavidW
Routine Member - Level 1

Re: Reporting question - schedule for the last day of the month

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.:

 

Capture.JPG

Play around with the standard options and you'll get something that works for you.

TomV
Occasional Member - Level 2

Re: Reporting question - schedule for the last day of the month

@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

Highlighted
SandraA
Routine Member - Level 2

Re: Reporting question - schedule for the last day of the month

Tom -

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

 

 

Sandra Ahola
T-Mobile
Senior Analyst Travel, Card & Expense
US
https://www.linkedin.com/in/sandra-ahola-4704553/