!

Cognos: Frequently Asked Questions

Frequently Asked Questions about Cognos

Can I automate a query or report from Cognos?

Cognos provides jobs that can be configured to run reports or queries and email the results to a user.

How can I find training for Cognos?

New users of Cognos are notified about upcoming on-campus training opportunities. In addition, CSSD Business Intelligence regularly conducts webinar-based training for Cognos.

What data is available in Cognos?

Access is provided to data extracted from two systems that support major University business functions: the PeopleSoft Student Information System and the PRISM financial system. Data is organized into groups of tables called “Data Marts”. Student information will be housed in the Student Data Mart, and financial information will be housed in multiple Marts, beginning with the General Ledger Data Mart. See the Data Collections information for complete details about available Cognos packages.

How often is the data updated?

The General Ledger Mart will be updated monthly immediately following month-end closing. The Student Mart will be updated on a daily basis (Monday through Friday). Check the "Data Refresh" in My Pitt to view the effective date of data for each Data Mart. 

What is the system availability of the Cognos Business Intelligence tool suite? The Cognos Tool set is always available with only one weekly outage.  The weekly system outage occurs Sunday evening from 6:00 until 7:00 PM.   Additional planned System outages may occur during the regularly scheduled maintenance window that occurs each Saturday from 11:00 P.M. through 7:00 A.M. Sunday.   

What is the Cognos Business Intelligence tool?

The Cognos Business Intelligence tool is an integrated business intelligence suite that provides a wide range of functionality to help you access and analyze the University’s data. You can currently use the Cognos Business Intelligence tool to view reports that have been automatically generated. In the future, you will also be able to develop your own queries and reports.

How can I request a new report in Cognos?

If you have Cognos Query Studio Access, you can create your own report. CSSD creates standard University reports in Cognos. If you have an idea for a report that would have application for users outside of your school, business unit, or area, contact the Technology Help Desk to suggest it.

What web browsers and operating systems are supported? (see table below)

COGNOS CONNECTION / REPORT

VIEWER / QUERY STUDIO / METRIC STUDIO

OPERATING SYSTEM 

SUPPORT STATUS

Note: A small number of Cognos Connection dialogs are used in Framework Manager.  Reference testing platform is Windows.

Microsoft Internet Explorer 7.0

Windows 1 2000 /2003/XP/Vista

Active

Microsoft Internet Explorer 6 SP1

          Windows1 2000 / 2003

Compatible

Microsoft Internet Explorer 6 SP2

Windows1 XP

Compatible

Firefox 3.0

Windows1 / Mac2 / UNIX / Linux

Active

Firefox 2.0

Windows1 / Mac2 / UNIX

Compatible

Firefox 1.5

Windows1 / Mac2

Compatible

Firefox 1.5.02

Linux / UNIX

Compatible

Note: Microsoft Office integration is only supported on Windows platforms (i.e. export to Excel)

REPORT STUDIO / ANALYSIS STUDIO / EVENT STUDIO

OPERATING SYSTEM

SUPPORT STATUS

Microsoft Internet Explorer 7.0

Windows1 2000 /2003/XP

Active

Microsoft Internet Explorer 6 SP1

          Windows1 2000 / 2003

Compatible

Microsoft Internet Explorer 6 SP2

Windows1 XP

Compatible

1- The Windows operating system applies to all versions of Windows that are currently supported by Microsoft.  2- The Mac operating system refers to any version up to Mac OS 10.6.