Page Comparison

Overview

UCI Decision Support Services (UCI DSS) use a combination of the Campus Data Warehouse (DWH), Cognos, and other web-based reporting and analysis tools to provide 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. It is a source for operational, ad-hoc and analytical reporting and carries years of historical data for trend analysis. Many administrative data subject areas are available for reporting needs including Financials, Personnel/Payroll, Billing and Accounts Receivable, Budget, Facilities, Research, Contracts/Grants, and Student Enrollment.

UCI DSS provides a number of tools for accessing data warehouse data including: IBM Cognos, Legacy Reports (BLISS), the Electronic Document Library (EDL), and eDocs Document Images. Cognos, BLISS, and EDL provide an Excel data download capability.

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.
Build and maintain standard reports & dash boards to assist enterprise and department’s needs.
Provide training for self-service reporting and analytics, supporting staff report development.
Data education and training on appropriate use.
Access and security.

Campus Business Intelligence utilizes the IBM Cognos tool to deliver Professional Dashboards, Standard Reports, and Cubes for doing Analysis and AdHoc Query capabilities. This tool comes with training in UCLC and we support using it against the Campus Data Warehouse or for building reports against departmental data repositories.

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 and integrated campus data warehouse and Cognos in 2017, with the new Student Information System and UCPath go-lives.

Section

Column

width	40

Info

title	Requesting Access

Services are available to faculty and staff with a UCINetID. DUO second factor authentication may be required for some data 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.

Column

width	60

Info

title	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

Section

Column

width	40

Info

title	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.

Column

width	60

Info

title	Resources

Tools
- Zotportal Decision Support (Cognos)
- Legacy Data Warehouse (BLISS)
- Electronic Document Library (Mobius)
- Excel (you can download data into Excel from Cognos, BLISS, or EDL for analysis).
Data Dictionary
Metadata / Refresh dates by subject area
For Cognos Report Developers: Guidelines, Templates, Tips, and Standards

Available Information or Data

Subject Area or System (click to see list of reports)	Reporting Tool	How to Access	Load Frequency	Whom to contact for help	Subject Availability
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	Legacy Data Warehouse (BLISS) eDocs EROS Filenet Imaging	Daily
Payroll Expense	BLISS	Legacy Data Warehouse (BLISS)	Monthly
Payroll/PPS Reports	EDL/Mobius	EDL
Space	BLISS	Legacy Data Warehouse (BLISS)	Yearly