ssmithjohn
Occasional Member - Level 1

How do I schedule a report to run each month for last month's data?

Need to know exactly where in Intelligence this is done.

0 Kudos
1 Reply
SAP Concur Employee
SAP Concur Employee

Re: How do I schedule a report to run each month for last month's data?

Hello there. Although I don't like to assume things, I'm going to assume you have some Cognos experience.

To schedule a report for last month's data, you need to build out your report and be sure that Sent for Payment Date is one of the data items on your report. Then be sure to go into the Common Report Header Filters folder. Look for a folder labeled Filters Based on Sent for Payment Date. Expand that folder, then select the Last Month filter. This will ensure the report you run only pulls data from the previous month.

Last_month.jpg

Once you have created the report and saved it in your My Folders, go to your My Folders and look for the icon below:

Schedule_Icon.jpg

This will take you to the scheduling screen. On the scheduling screen, be sure the setting look like the following:

Schedule_by_Month.jpg

This should be what you are looking for.

Kevin