Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 112 Next »


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 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
AdvancementCognosUCI's IBM Cognos Connection and email deliveryDaily   Julie George  
Facilities ManagementCognos Zot Portal, Tririga and UCI Cognos Dashboard Monthly and on demand   Aileen Lin  
Human Resources/Employee - Campus

BLISS

eDocs

Filenet

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 SupportDaily 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 SupportDaily Tuesday - Saturday  

KFS Help Desk

kfs@uci.edu

(949) 824-7001

Daily 7:00 am - 10:00 pm 24/7
Kuali Research AdministrationCognosPortal Decision SupportCurrently 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     

Resources
 

Requesting 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 the Data Warehouse team at (dwh@uci.edu)
  • Cognos Service Level Agreement

  

General Availability

Hours of operation: Decision Support Applications are 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 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. 

     

     

  • No labels