SES Reporting Information

If you are a Northwestern staff member looking for student information, there are currently three main options, as outlined below. These reporting tools have been made available to users so they are able to access student information in order to support the functions required to fulfill their job responsibilities. If you have questions about any of these reporting options or how you can utilize one or more of them, please contact us via the NUIT Support Center


SES-BI Reporting and Analytics Solution


The SES-BI Reporting and Analytics Solution is a web-based reporting and analytics solution built on the NU Business Intelligence platform (powered by Cognos BI) that allows users to run pre-existing reports and/or create their own analyses using a supported web browser (Internet Explorer or Firefox). Many of the popular, high-demand Crystal Reports have been converted to this system with plans to convert and create new reports in the future. See below for a list of Crystal Reports that have been converted to the SES-BI system.

SES-BI Materials & Info

To obtain access to the SES-BI Analytics System, you will need to submit the SES Student Records access form specifying that you are requesting access to Academic Reports.

For questions and/or more information about the SES-BI system, please contact us via the NUIT Support Center


Crystal Reports for SES


Crystal Reports is an end-user reporting tool that allows users to run read-only, on-demand reports from their workstation, provided they have a valid SES administrative user ID. After walking through the installation steps, reports can be easily run and exported to Microsoft Excel or to PDF. These reports are written and maintained by the Registrar's Office and are mostly Student Records related.

Crystal Reports is not currently compatible with Windows Vista or any Mac operating systems. In order to install and use Crystal Reports, you will need to be using Windows XP or Windows 7 as your operating system.

Crystal Reports Materials & Info

To obtain access to Crystal Reports, you will need to submit the SES Student Records access form specifying that you are requesting access to Academic Reports.


PeopleSoft (SES) Query Tool


PeopleSoft Query is an end-user reporting tool that allows users to extract information from SES by using visual representations of the SES/CAESAR database, without writing Structured Query Language (SQL) statements. Users can be granted "run-only" access, which allows them to simply run and download queries that have been developed by others, or more experienced users can be granted "write" access which allows them to develop their own queries. The queries can be as simple or as complex as necessary; they can be one-time queries or queries that are used repeatedly. Potential SES Query writers should be able to demonstrate an aptitude for developing queries either from previous work experience or by attending a training session.

To obtain access to PS Query, you will need to submit the SES query access form(s). Access to the Query tool is granted on a module-by-module basis (i.e. Student Records, Admissions, Financial Aid, etc).

Query/Report Database


SES Data Feed Request


If you need data from SES/CAESAR in a feed or format not supported by one or more of the reporting options listed above, please fill out and submit the form below and we will review your request and contact you regarding next steps.


Note:


For information regarding custom Student/Academic Records reporting, please click here to visit the Academic Reporting page on the University Registrar website.