Reporting/Business Intelligence

The mission of the Business Intelligence and Reporting Team (BIRT) in the Enterprise Applications Department of C&IT is to provide world-class information delivery for use in operational, tactical and strategic reporting and analysis at Wayne State University. Wayne State uses three primary tools: Cognos, the Operational Data Store (ODS) and the Enterprise Data Warehouse (EDW). Cognos allows for users to build and view reports based on information stored and analyzed within the ODS and the EDW.

Reporting/Business Intelligence

  • How do I create a report view with saved parameters in Cognos?

    Follow the steps below to set saved parameters or settings for your reports in Cognos. Go to Public Folders and find the report you want. Under Actions on the same line as the report you want, click on the Report View Icon (looks like a window) t...

  • I cannot export my report data in either an .xls format or .csv format.

    If you are running your reports from within Internet Explorer and cannot export your report data in either Excel (.xls) or Comma Separated Values (.csv) formats, it is because of Internet Explorer. There are three potential issues; Any combination or...

  • How do I use Cognos in IE 10?

    Cognos is available in Internet Explorer 10 with the following settings. Enable Compatibility View Add to Trusted Sites http://bireporting.wayne.edu https://bireporting.wayne.edu Security Settings for Trusted SitesActiveX controls and p...

  • What is the Enterprise Data Warehouse (EDW)?

    The Enterprise Data Warehouse (EDW) is designed to work with the ODS to provide event-based processing to capture point-in-time information for trend analysis and historical reporting, enabling the institution to proactively plan business activities....

  • How do I use Cognos Connection? (Job Aids)

    These job aids assist in using Cognos Connection, the Business Intelligence and Reporting system at Wayne State University. You have the ability to stop/pause, rewind and fast forward the video using the control panel at the bottom of the video scree...

  • Is there documentation for Cognos?

    Find available Cognos documentation below. Commonly Used Functions for Cognos Reporting Cognos 10 Desktop Computer Configurations for Cognos Cognos 10 Connection User Guide Cognos 10 - Report Studio User Guide High Usage and Sta...

  • Is there documentation for Operational Data Store (ODS)?

    Find all of the available Operational Document Store (ODS) documentation below. ODS 8.4 Handbook ODS 8.4.1 Release Guide

  • Is there documentation for Enterprise Data Warehouse (EDW)?

    All of the available Enterprise Data Warehouse documentation is below. EDW 8.4M Stars Reference (Uncompress and open edw80400sr_readme in a text editor for instructions) EDW 8.4.2 Handbook (PDF) EDW 8.4.3 Release Guide (PDF) EDW Metadata Analy...

  • Which version of Microsoft Excel should I use to run Cognos reports?

    Cognos provides two options for running a report in Microsoft Excel. Excel 2007: C&IT recommended. Excel 2002: Has presented two issues. Images do not display. When emailing the report as an attachment, the file is in the .mht format.

  • Why can't I log in to Banner Pre-Production?

    There is a two step process to log in to Banner Pre-Production. Log in to Banner Pre-Production using your AccessID and password, and then use your Pre-Production password when you are prompted for your Oracle password. If you continue to experie...

  • How do I change my Cognos password?

    You may change your Cognos password by changing your AccessID password via Academica; your AccessID and Cognos passwords are automatically synchronized. If you get the message, "The provided credentials are invalid," you need to change your password....