skip to navigation skip to content
Thu 7 May 2020
13:00 - 16:30

Venue: Finance Division, Greenwich House, Ferrara Room (IT Training Room)

Provided by: Finance Training


Booking
There are places available Book a place
(Provisional)

NOTE: Bookings on this event require approval by the event administrator.

You may make a provisional booking using this page, but your place will not be confirmed until the booking has been approved.

Other dates:


2019


2020


[ Show past events ]



Register interest
Register your interest - if you cannot make any of the currently scheduled dates and would be interested in additional dates being scheduled.


Booking / availability

Grants Part 2: Grant reports in Cognos
Prerequisites

Thu 7 May 2020

Description

This course will concentrate on how to use the Cognos reporting tool to help manage departmental research grants. These reports can be divided into three main categories:

  • Summary financial information for Projects
  • Detailed expenditure analysis
  • Management reports for Grants due to close

In this course we will not access the Grants module in CUFS.

Target audience

Staff who manage departmental Grants.

Please Note: If you work in the ROO, this course only covers the reports that are available to grant administrators in the depts. It doesn't focus on the central reports that you will run as part of your role as this will be covered internally by the ROO. If you would just like to know how to use Cognos and create some shortcuts, personalised pages then refer to the Getting Started in Cognos course.

Prerequisites

Your booking will remain 'provisional' until the following prerequisites have been completed and you have advised finance.training@admin.cam.ac.uk thereof:

(Finance Division > Systems > Reporting > Cognos Access Request)

You will need to know whether you require access to the Grants/General Ledger folder or both for your department. Please liaise with your department key contact/line manager to ensure you complete the form correctly. If you require access to more than one department, all the departments within the school, or across schools, this must be clearly indicated on the form. You also need to know whether or not you will need to receive 'burst reports in your school/department. These are reports that are automatically generated and emailed to you regularly. If you are a PI, you will need your payroll number. The form also allows you to indicate whether you are a member or ROO or Central Finance.

Once you have Cognos access, please complete the following tasks 5 working days prior to your training to eliminate any problems logging into Cognos on the day.

  • Log into Cognos by clicking on Cognos Login: http://www.admin-reporting.cam.ac.uk/
  • Click on 'Log into Cognos'
  • Enter your CRSID, raven password and click OK
  • Public Folders page will display.
  • Click on the folder called 'LIVE'
  • Click on the folder for your School
  • Click on the folder titled 'Departmental (Shared) Reports'
  • Depending on what access has been requested, you should have a folder for Grants or General Ledger or both with reports listed in each folder.

If you cannot see these reports, it means your access has not been correctly set up or is still in progress. This requires time to resolve so please do not leave to the day before the course.

Your booking will not be approved until you have confirmed that you have completed these steps. If you experience any problems, then please email finance.training@admin.cam.ac.uk.

Sessions

Number of sessions: 1

# Date Time Venue Trainer
1 Thu 7 May 2020   13:00 - 16:30 13:00 - 16:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room) map Christine Rogerson
Objectives
  • Accessing Cognos to run Grant reports in both PDF and Excel formats
  • How to set up short cuts to ‘My Folders’
  • How to create personalised pages
  • Schedule reports to run in the future and email them to yourself and others
  • Identify the various reports available and discuss the data that they show
  • To explore what reports are available to PIs
Aims

To report and manage Grants efficiently and effectively by utilising COGNOS.

Format

Demonstrations and practicals to consolidate learning

Duration

One half day session

Frequency

Every other month

Related courses
Themes

Booking / availability