Mount Hood

Newsletter – August 2014

UCS has been working very diligently on the Data Warehouse over the past month. We’ve been adding data to the warehouse, revising the warehouse’s structure, optimizing financial data, generating reports, and integrating the warehouse with some third party applications.

Here are some of the things that our warehouse team has been working on:

Richard Kavanagh

PROGRAMMER ANALYST, Dimensional model expert kimball rules expert, odi guru

  • Added cumulative GPA, prior school attended, high school subjects taken, and prior degrees earned to the Data Warehouse
  • Working on 4th Week data

Nick Miller

PROGRAMMER ANALYST, BANNER Finance & Human Resources Expert, Cognos Framework Guru

  • Partitioned all of the Finance tables by fiscal year
  • Optimizing Athletics reports
  • Working on Calculated Columns
    • Permanent Budget Adjustments for the Operating Ledger is now in Development
    • Sorting and Account Code groups for IFC purposes is now in Development
  • In the process of bringing in General Ledger Data

Shea Hawes

Programmer Analyst, BANNER Student Expert, Student Modeler Guru

  • Added new dimensions and cubes to the Data Warehouse for
    • Admissions
    • Advisors
    • Benefits/Deductions
    • Retirement
    • Review/Salary Eligibility Date
    • Generated a few smaller reports

Max Chartier

Data Architect, BANNER Human Resources Expert, Cognos Reports Guru

  • Developing reports for Finance, the College of Liberal Arts and Sciences, the Graduate Office, and the Business Office
    • 8 new reports are now in production and more are waiting in QA for validation
  • Feeding data from the Data Warehouse to two third party applications, GradesFirst and CollegeNET, owned by Academic Advising and Academic Affairs, respectively

Jared Petersen

Student Programmer, Cognos Report Developer, Honors Student

  • Programmed the Data Dictionary
  • Currently adding information to the Data Dictionary
  • Wrote documentation for Cognos Report Scheduling
  • Updated the website