cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Manager
Community Manager

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

In the report studio, use a pre-defined filter "Last Month" in the data warehouse (e.g. Sent for Payment date) to build your report. Then you can schedule a report (click on the calendar icon) by day, week, month or more. This can help you (or those you configure to email) keep on top of a specific business metric.

3 Replies
Routine Member - Level 3

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

Do scheduled reports have to me in My Folder or can they be setup in the Public folder?

ค๓๒єг ɭєє - ᴄᴏɴᴄᴜʀ ᴄᴏɴɴᴏɪssᴇᴜʀ
(っ◔◡◔)っ  ☆ Fort Worth, Texas ☆
patilr1982
Routine Member - Level 1

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

Hi Amber,

Whilst there is no technical limitation stopping you from scheduling reports from Public Folders, you take on the risk of the schedule being inadvertently changed by someone else with access to the Public Folders.

Also, as per my understanding, the report schedule will use the timezone of the user that last saved the schedule. It does that when we set up the schedule.

For above reasons, the reports are usually scheduled from My Folders.

Best Regards,
Rohan
SAP Concur and SAP FICO Implementation Functional Consultant
SandraA
Routine Member - Level 2

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

We use the public folder for scheduled reports for continuity and access. 

If the report builder is on vacation or medical leave, the other team members can access the reports and make updates or re-run reports the recipient has missed.

This is also crucial should one of your team members terminate.  This just happened in my group and I'm in the process of cleaning up and resaving the reports he built.    We found out awhile back that even though the reports are in the public folder - and still "work",  the schedule stops working once the report author is listed as Inactive in Concur.

 

 

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