Emporia State University Hornet 365

HOW TO RUN A COGNOS REPORT

This is a visual guide for running a Cognos report. For additional information: contact Kameron Neal at kneal@emporia.edu or on Microsoft Teams.


IMPORTANT: You must be on the ESU network in order to access Cognos. (You may also connect via the VPN)


STEP 1:

In the Hornet 365 University portal, select Employees from the main menu.

STEP 2:

On the Employees page, select the Cognos tile.

STEP 3:

On this page log in with your ESU username and password.

STEP 4:

You will be taken to the welcome page within Cognos.

Different reports are contained within each folder under Team Content. For this guide we will run the Universal Majors & Minors reports, which can be found in the Student Public Records Folder.

STEP 5:

The Universal Majors & Minors report is available to all departments, so it will be under the Campus Wide Reports folder.


Also note the directory path at the top of the list, highlighted in gold. Clicking on the names in the path will take you back to that area.



STEP 6:

Then click on the ellipses to the right of the report you want to run, select Run As and you will be taken to the prompt page.

STEP 7:

Select either the mailing or permanent address. If one does not exist it will fill in with the other.

STEP 8:

The Universal Majors/Minors Report can be run for majors OR minors. If you want both it must be run twice.

STEP 9:

(Optional)


This field is not required and optional if you want to narrow the results.

STEP 10:

The Checkbox means that multiple options can be selected. Select all fields you want to see results for.


(ex. Freshman & Sophomore Art Majors)

STEP 11:

To run the report, click ‘Finish’.

STEP 12:

Depending on the number of applicable students, your report might take some time to run. You can either wait for it to download or select a delivery method to receive the file when it is done.

STEP 13:

The report can then be opened in Excel.

Share by: