/
Cognos

Cognos

Note: The Cognos reports and workloads are being migrated to Tableau. The current plan is to fully retire Cognos by the end of FY25. Communications, data sources and documentation will be released through the year to prepare users.

Information below is provided to help support existing users as they transition to Tableau. Contact the Pitt IT Helpdesk if you'd like to schedule a consultation on your adoption of Tableau.

Cognos Analytics is a tool for enterprise reporting, ad hoc data reporting and self-service analytics. Using Cognos Analytics, authorized staff can view standard University financial and student reports. Data and administrative professionals can use Cognos Reports to create or run existing reports.

Data from the University data marts are organized into packages within Cognos. These packages provide data for pre-built reports, as well as providing data sources for ad hoc reporting via the Cognos Report tool for student, employee, and financial data.

Frequently Asked Questions

Cognos User Group Archives

The Cognos User Group no longer meets but you can view prior meeting recordings below.  Please note all Cognos User Group meetings were from version 11.0.12.  

  • April 24, 2020 -Recorded webinar on the following (video)

    • Cognos maintenance - deleting unused reports, schedules, and jobs

    • Creating prompts and prompt pages (including cascading prompts)

    • Inserting SQL code into a report

  • March 27, 2020 - Recorded webinar on the following (video)

    • Uploading an Excel spreadsheet for use in reports

    • Creating a data module from an uploaded spreadsheet

    • Scheduling reports and creating jobs (video)

  • February 28, 2020

  • December 13, 2019

    • ST Enrollment and Tuition Query Pkg (Notes on using this pkg)   

    • GL Transaction Query Pkg (Notes on using this pkg)

  • November 15, 2019

    • ST Mart - The Course Repeat Form is now available.  It can be run by EMPLID, Plan or Standing.  Reports are in folder:  Team Content > Cognos Reports > ST Class Enrollment Reports   

    • GL Mart - The new Variance report is available in folder:  Team Content > Cognos Reports > General Ledger Reports.  And is named:  Monthly Variance Report

    • ST Mart - How to create a report with two queries joined (applications that were WAPP yesterday but not today) (Video)

    • GL Mart - How to create a report with two queries joined (accounts with no budget this year) (PDF) 

    • Date Filter Examples (PDF)

  • October 18, 2019

  • September 20, 2019

  • August 8, 2019

  • July 11, 2019

    • Common ST Mart Cognos packages, purpose and tips for each (PowerPoint)

    • How to convert a Query to a Report (Step by step) 

    • How to conditionally format fields for different styles (Step by step) 

    • How to format Data Types (numbers, dates & percentages) (Step by step) 

    • How to change the numbers of rows shown in report output (Step by step)

    • How to write a report to identify Active Students not yet enrolled (Step by step)

    • How to write a report to list all Acad Program codes in which students are enrolled (Step by step)

  • June 11, 2019

Need help? Contact the Pitt IT Helpdesk