How To Schedule Cognos Financial Reports for Monthly Delivery


Overview

Reports that are typically run with a time parameter (by accounting period or as of a date) can be scheduled for periodic (i.e. monthly) delivery using features built into each report. Reports run with an accounting period can be scheduled to run with the last closed accounting period, while reports run as of a date can be scheduled to run through today’s date. This article details how to schedule monthly Cognos reports. 

Essential Information

Accounting Periods are designated as Closed when the General Ledger has been closed for all campus business units. Typically, this is completed by the 20th of the subsequent month. It is therefore recommended to schedule Accounting Period-based reports to run after the 20th of each month.

Next Steps

Prepare the Report for Scheduling

Please note, the steps necessary to prepare a report for scheduling vary slightly by report.  

Faculty & Researcher Dashboard and Project Management Dashboard

  1. Run the desired report from BAH.
  2. On the 'Period End Date' prompt enter 'Jan 1, 0100'. 
  3. Fill in any other desired prompts and run the report.

GL Fund Balances and GL Project Balances

  1. Run the desired report from BAH.
  2. Select ‘Yes’ in the ‘Are you planning to schedule this report’ prompt. Select either Last Closed Accounting Period or Last Open Accounting Period according to your preference. Run the report.

Transaction Details Report

  1. Run the report from BAH. 
  2. Pick any prompts you want, and then check ‘Last Closed Accounting Period’. Do not use any other time prompts. Run the report.

Schedule the Report

          1. On the top right, click the blue three dots, and select 'Subscribe'.

 

          2. A small menu with scheduling settings will appear, where you can customize how you want your report to be scheduled and sent. Click on ‘Create’.

 

          3. On the top right, click on your profile icon, and go to ‘My schedules and subscriptions’.

 

          4. On the top left, go to the dropdown menu and select ‘Schedule’.

 

          5. Look for ‘My [Name of Report]’). To change the name of your scheduled report, click on the three dots to the far right and go to ‘Properties’, then edit the name.

 

          6. From the triple dots,  go to ‘Modify this schedule’.

 

          7. Select monthly frequency and start date. Select a time that is not during business hours and not on the hour or half hour.

 

          8. Go to the Options tab, select the desired format, and ‘Send report by email’. 

 

          9. Click on ‘Edit details’ to enter email recipients, a subject line, and message for the body of your email. Select ‘Attach report output’ to have the report attached in the  monthly email.

          10. Save and close. The report will be emailed to the designated recipient(s) monthly.

Questions?

If you need any additional assistance, please submit a ticket here.