Overview
UCI Decision Support Services (UCI DSS) provides integrated, clean, timely, consistent, and documented data for reporting and analysis. Campus decision-makers and analysts can use UCI DSS to run reports in order to answer their business questions as quickly and efficiently as possible.
UCI DSS maintains a single source of trusted data in ODS and the Legacy Data Warehouse. Data is extracted at certain points in time and loaded into these data repositories from central administrative systems such as:
- Financial System
- Payroll System
- Employee System
- Purchasing System
- Equipment System
- Space Inventory System
- USA Address Database from the US Post Office
We currently leverage a number of tools for accessing these various data sources to develop reports, including: IBM Cognos, Legacy Reports (BLISS), the Electronic Document Library (EDL), and eDocs Document Images.
The Campus Business Intelligence team has launched a project to standardize UCI’s various data repositories into one Enterprise Data Warehouse (logical or physical) and to consolidate the various reporting tools into one. The IBM Cognos tool will be the new standard for delivering Professional Dashboards, Standard Reports, and Cubes for doing Analysis and AdHoc Query capabilities. This transition started with the KFS go-live in July, 2014 and we expect to be fully transitioned to the new and integrated campus data warehouse and Cognos by 2017, with the new Student Information System and UCPath go-lives.
Available Information or Data
Today, the following data sources can be queried using the corresponding tool(s) listed in the below matrix.
Please note that access to these systems is based on your roles & responsibilities and you may not be authorized to access all or any this information. Please consult with your supervisor.
Subject Area or System | Reporting Tool | How to Access | Load Frequency | Whom to contact for help | Subject Availability |
|---|---|---|---|---|---|
| Advancement | Cognos | UCI's IBM Cognos Connection and email delivery | Daily | Julie George | |
| Facilities Management | Cognos | Zot Portal, Tririga and UCI Cognos Dashboard | Monthly and on demand | Aileen Lin | |
| Human Resources/Employee - Campus | BLISS |
| Daily | OIT Help Desk | |
| Human Resources/Employee - Medical Center | Cognos | UCI's IBM Cognos Connection | Daily | Guna Raman | |
| Kuali Budget System (KBM) | Cognos | Portal Decision Support | Daily Tuesday - Saturday | KFS Help Desk | Daily 7:00 am - 10:00 pm |
| Kuali Financial Documents | eDocs | ||||
| Kuali Financial System (KFS) | Cognos | Portal Decision Support | Daily Tuesday - Saturday | KFS Help Desk | Daily 7:00 am - 10:00 pm |
| Kuali Research Administration | Cognos | Portal Decision Support | Currently not in Production | ||
| KSAMS - New Security Access Management System | Cognos | UCI's IBM Cognos Connection | Daily Tuesday - Saturday | OIT Help Desk | Daily 7:00 am - 10:00 pm |
| Payroll Expense | BLISS | Monthly | OIT Help Desk | ||
| Payroll/PPS Reports | EDL/Mobius | EDL | After each compute (Bi-Weekly/Monthly) | OIT Help Desk | |
| Research Proposal/Award Data | BLISS | Legacy Data Warehouse (BLISS) | Daily | OIT Help Desk | |
| Space | BLISS | Legacy Data Warehouse (BLISS) | Yearly (Spring) | OIT Help Desk | |
| Student Analytics | Cognos | ||||
| Student Enrollment | Cognos | Daily |
Resources
Requesting Access
- Access to services is based on your campus roles & responsibilities are is only available with a UCINetID. DUO second factor authentication may be required for some data access.
- To gain access to systems related to your role, contact your Departmental Security Administrator (DSA) or call the OIT Helpdesk at x4-2222 or email oit@uci.edu.
- VPN may be required once you are granted access.
Getting Help
- To report a problem, please call the OIT Helpdesk at x4-2222 or email oit@uci.edu
- To request a new report or to change a report, or to request new data, email oit@uci.edu and include a description of what you need, why you need it, and when you need the service by.
Reporting Tools
- Decision Support Applications
- For Cognos Report Developers: Guidelines, Templates, Tips, and Standards
General Availability
COGNOS HOURS OF OPERATION: generally available 24x7, except for emergencies and the following scheduled maintenance windows:
- Mondays 6:30 PM to 8:30 PM
- Saturdays 2:00 AM to 4:00 AM
LEGACY DATA WAREHOUSE: generally available XXXXXXXX
KFS DECISION SUPPORT:
Decision Support Applications may also be unavailable for individual subject areas due to maintenance related to those specific areas. Please contact the OIT Helpdesk at x4-2222 for further information.