Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

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 Data typically are extracted from their source systems at defined 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

various data repositories that can be queried for reporting and analysis.

We currently leverage a number of tools for accessing these various data sources to develop reports, including: repositories, such as IBM Cognos, Legacy Reports (BLISS)Data Warehouse, the Electronic Document Library (EDL), and eDocs Document Images.

The Campus campus Business Intelligence team has launched a project to standardize UCI’s various these 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 Dashboardsdashboards, Standard Reports, and Cubes for doing Analysis and AdHoc Query capabilities. This transition started with the KFS go-live in July, 2014 reports, ad-hoc query capabilities and other functionality. This effort began with the KFS launch in July 2014, and we expect to be fully transitioned to the new and integrated campus data warehouse and Cognos complete the transition by 2017, coinciding with the launch of 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 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

Whom to contact

for help

Subject

Contact

Availability

AdvancementCognosUCI's IBM Cognos Connection and email delivery Daily Julie George 
Facilities ManagementCognos 

ZotPortal

Zot Portal,

Tririga

and UCI


Cognos

Dashboard 

Monthly and on demand Aileen Lin 
Human Resources/Employee - Campus

BLISS
eDocs
Filenet

Legacy Data Warehouse

(BLISS)


eDocs EROS
Filenet Imaging

Daily

OIT Help Desk
oit@uci.edu

(949) 824-2222
 
Human Resources/Employee - Medical CenterCognos UCI's IBM Cognos ConnectionDaily Guna Raman 
Kuali Budget System (KBM)CognosPortal Decision SupportZotPortalDaily Tuesday - Saturday 

KFS Help Desk
kfs@uci.edu
(949) 824-7001

Daily 7:00 am - 10:00 pm
Kuali Financial DocumentseDocs    
Kuali Financial System (KFS)CognosPortal Decision SupportZotPortalDaily Tuesday - Saturday

KFS Help Desk
kfs@uci.edu
(949) 824-7001

Daily 7:00 am - 10:00 pm 
Kuali Research AdministrationCognosPortal Decision SupportZotPortalCurrently not in Production   
KSAMS - New Security Access Management SystemCognosUCI's IBM Cognos ConnectionDaily Tuesday - Saturday

OIT Help Desk
oit@uci.edu
(949) 824-2222

Josh Drummond
Daily 7:00 am - 10:00 pm 
Payroll Expense

BLISS

Legacy Data Warehouse (BLISS)

Monthly

OIT Help Desk
oit@uci.edu
(949) 824-2222

 
Payroll/PPS ReportsEDL/MobiusEDLAfter each compute (Bi-Weekly/Monthly) 

OIT Help Desk
oit@uci.edu

(949) 824-2222
 
Research Proposal/Award DataBLISSLegacy Data Warehouse (BLISS)Daily 

OIT Help Desk
oit@uci.edu

(949) 824-2222
 
SpaceBLISSLegacy Data Warehouse (BLISS)Yearly (Spring)

OIT Help Desk
oit@uci.edu

(949) 824-2222
 Student AnalyticsCognos    
Student EnrollmentCognos Daily  

...