Overview
UCI DSS is responsible for designing and delivering solutions to business problems using a combination of operational data stores (ODS), campus data warehouse (DWH), Cognos Reports, Legacy Reports (BLISS), and document imaging (Electronic Document Library (EDL) and eDocs/Filenet)
We provide the following services to cater to the information and reporting needs of various departments at UCI:
- Establish and maintain single source of true data (in ODS and DWH) for reporting and analysis.
- Assure that data is documented, clean, consistent, and timely.
- The Campus Data Warehouse provides a central repository for many areas of administrative data including Financials, Personnel/Payroll, Billing and Accounts Receivable, Budget, Facilities, Research, Contracts/Grants and Security.
- Build and maintain standard reports & dash boards to cater to enterprise and department’s needs.
- Provide platform and training for self-service reporting and analytics, supporting staff report development.
- Data education, appropriate use, and training.
- Access.
The Campus Business Intelligence utilizes IBM Cognos tools to deliver Professional Dashboards, Standard Reports, Cubes for doing Analysis and AdHoc Query capabilities.
We are in a major transition phase where the legacy data warehouse built in 1996 and the legacy reporting tool BLISS, are being replaced with a new campus data warehouse and reporting tool (IBM Cognos). This transition started with the Kuali FS go-live in July, 2014 and we expect to be fully transitioned to the new campus data warehouse and Cognos in 2017, with the new Student Information System and UCPath go-lives.
Requesting Access
- To gain access, contact your Departmental Security Administrator (DSA) or call the OIT Helpdesk at x4-2222.
- VPN is 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.
- To request Cognos Report Training contact Larry Coon at (lcoon@uci.edu).
- To request training on data contact Valerie Jones at (vjones@uci.edu)
- Cognos Service Level Agreement
Resources
- Tools
- Zotportal Decision Support (Cognos)
- Legacy Data Warehouse (BLISS)
- Excel (you can download data into Excel from Cognos, BLISS, or EDL for analysis).
- VPN
- Data Dictionary
- Metadata / Refresh dates by subject area
General Availability
Hours of operation: Decision Support is 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
Decision Support 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.
Available Information or Data
Subject Area or System (click to see list of reports) | 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 | ||||||
| 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 | |||||
| Cognos Portal | Cognos | |||||||
| EDL Reports / Images | Mobius | |||||||
| eDocs Images | Filenet |
Project
- Project Timelines / Milestones
- Status - What are we working on? Scorecards.
- Strategic Plan (Current state, Future State/Vision, Roadmap, Costs)
- Presentations
More Information
- Data Warehouse/BI Leadership Meetings
- UCI Decision Support Organization
- UCI Data Management and Governance Project
- UCI Data Inventory
- UCI Reporting Assessment Report Inventory.xlsx (Nice Template used for SIS by Ellucian)
- Additional Resources