Reporting System

Creating a single, efficient reporting solution for financial management

The Office of University Controller (OUC) has been charged with developing the Cognos Reporting System as the single reporting solution for the University of Colorado. In pursuit of this goal, we have already begun to decommission other, unsupported reporting tools.

Through Cognos, we offer on-demand reports to suit common departmental financial management needs. We also provide training, documentation, and support to facilitate knowledgeable use of the Cognos Reporting System and transition away from other systems.

We consult with campus controller staff and campus users to ensure that Cognos reports are developed to serve their financial data needs. This includes both creating new management reports and replacing management reports that have been useful in other systems we are decommissioning.

m-Fin

The University of Colorado has other Cognos content, including legacy Cognos financial reports. We therefore use the m-Fin brand to distinguish the on-demand reports developed for this initiative. m-Fin stands for management financial

m-Fin reports are:

  • Cognos technology
  • For internal CU use
  • Drawn on financial data from CU's Central Information Warehouse (CIW)
  • Tuned for performance with reasonable run times
  • Developed with input from CU administrative financial data users
  • Published and maintained by CU's Office of University Controller (OUC)

Team

OUC's team for the Cognos Reporting System Initiative is made up of Carl Sorenson and Sarju Khadka. Carl and Sarju work with the campus users for input on development of Cognos reports. They also collaborate with University Information Systems (UIS) and Information Research Management (IRM) on development of the Cognos data model, enhancement of CIW database infrastructure, and Cognos software support.

Carl and Sarju are joined by other members of the OUC staff in testing, training, and supporting CU's use of the Cognos system for financial management.

Timeframe

Decommissioning of other reporting tools will be according to the following schedule:

  • cms "Denver CIW" site decommission: August - December 2011
  • accounting.cudenver.edu site decommission: February 2012
  • FishNet financial queries decommission: September - December 2012
  • PSLite decommission: To be determined

Development of new Cognos content, including supporting ad hoc query and leveraging new features of Cognos, will be ongoing over several years.

Communication and Training

Get oriented

Get Help

Stay Informed

Monitor or subscribe to Carl's m-Fin blog: http://www.cu.edu/blog/m-fin

Provide Feedback

It is best to leave comments on Carl's m-Fin blog because it is a public forum ... but you may also contact carl.sorenson@cusys.edu

 

The timeframe for decommissioning PS Lite is under consideration.

Build-A-Query

  • Journal Detail
  • Ledger Detail
  • Payroll Detail

Reporting by Projects/Awards

  • Cumulative Summaries through a Specific Accounting Period (By Project or Award)
  • Journal Detail (By Project or Award)
  • Detail for Account Period (Or Range of Periods) - By Project or Award
  • Detail Within a Range of Dates (Across Fiscal Years) - By Project or Award

Summaries by Org or Org Tree Level

  • Reports for General Funds
  • Reports for Auxiliary Funds
  • Reports for Restricted Funds
  • Reports for Plant Funds
  • Reports for All Funds

Look-Ups

  • Accounts
  • Orgs
  • Programs
  • Projects
  • Account Tree
  • Fiscal Roles

Groups

  • Org Summaries
  • Org Detail
  • Program Summaries
  • Program Detail
  • Project Summaries
  • Project (By Date Range)

FRS (Financial Reporting System)

  • SL Summaries
  • Project SL Summaries
  • GL Summary
  • Detail