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 answer their business questions quickly and efficiently.
Data typically are extracted from their source systems at defined points in time, and loaded into various data repositories that can be queried for reporting and analysis.
We currently leverage a number of tools for accessing these data repositories, such as IBM Cognos, Legacy Data Warehouse, the Electronic Document Library (EDL), and eDocs Document Images.
The campus Business Intelligence team has launched a project to standardize these data repositories into one Enterprise Data Warehouse and to consolidate the various reporting tools. IBM Cognos will be the new standard for delivering dashboards, reports, ad-hoc query capabilities and other functionality. This effort began with the KFS launch in July 2014, and we expect to complete the transition by 2017, coinciding with the launch of the new Student Information System and UCPath.
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 subject areas 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 | Contact | Availability |
|---|---|---|---|---|---|
| Advancement | Cognos | Daily | Julie George | ||
| Facilities Management | Cognos | ZotPortal | Monthly and on demand | Aileen Lin | |
| Human Resources/Employee - Campus | BLISS | Legacy Data Warehouse | Daily | OIT Help Desk | |
| Human Resources/Employee - Medical Center | Cognos | Cognos | Daily | Guna Raman | |
| Kuali Budget System (KBM) | Cognos | ZotPortal | Daily Tuesday - Saturday | KFS Help Desk | Daily 7:00 am - 10:00 pm |
| Kuali Financial Documents | eDocs | ||||
| Kuali Financial System (KFS) | Cognos | ZotPortal | Daily Tuesday - Saturday | KFS Help Desk | Daily 7:00 am - 10:00 pm |
| Kuali Research Administration | Cognos | ZotPortal | Currently not in Production | ||
| KSAMS - New Security Access Management System | Cognos | Cognos | 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 | Daily | OIT Help Desk | |
| Space | BLISS | Legacy Data Warehouse | Yearly (Spring) | OIT Help Desk | |
| Student Enrollment | Cognos | Daily |
Resources
Requesting Access
- Access to services is based on your campus roles & responsibilities and 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 (requires login)
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.