| Table of Contents |
|---|
...
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 true 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 are available to query using the corresponding tool(s) listed in the below matrix. This matrix will be updated as new repositories are added to the Enterprise Data Warehouse and as Cognos reports are developed to replace existing tools.
Subject Area or System | Reporting Tool | How to Access | Load Frequency | Last Load Date/Time | Data Dictionary | Whom to contact for help | Subject Availability | Status |
|---|---|---|---|---|---|---|---|---|
| Kuali Financial System | Cognos | Portal Decision Support | Daily | 24/7 | ||||
| Kuali Financial Documents | eDocs | |||||||
| Kuali Budget System | Cognos | Portal Decision Support | ||||||
| Kuali Research Administration | Cognos | Portal Decision Support | ||||||
| KSAMS | Cognos | UCI's IBM Cognos Connection | Daily | Josh Drummond | ||||
| Student Enrollment | Cognos | Daily | ||||||
| Student Analytics | Cognos | |||||||
| University Advancement | Cognos | UCI's IBM Cognos Connection and email delivery | Daily | Julie George | ||||
| UCI Medical Center | Cognos | UCI's IBM Cognos Connection | Daily | Guna Raman | ||||
| Facilities Management | Cognos | Zot Portal, Tririga and UCI Cognos Dashboard | Monthly and on demand | Aileen Lin | ||||
| Research Proposal/Award Data | BLISS | Legacy Data Warehouse (BLISS) | ||||||
| Employee / HR | BLISS, eDocs, Filenet |
| Daily | |||||
| Payroll Expense | BLISS | Monthly | ||||||
| Payroll/PPS Reports | EDL/Mobius | EDL | ||||||
| Space | BLISS | Legacy Data Warehouse (BLISS) | Yearly | |||||
Resources
| Section | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Section | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Attachments |
|---|