Versions Compared

Version Old Version 116 New Version Current
Changes made by

Meredith Ehrenberg

Valerie Jones

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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 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 can be queried using the corresponding tool(s) listed in the below matrix.
Please note that access to these systems 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

Availability

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

Section
Column
width40
Info
titleRequesting Access
  • Access to services is based on your campus roles & responsibilities are is only available with a UCINetID. DUO second factor authentication may be required for some data access.
  • To gain access to systems related to your role, contact your Departmental Security Administrator (DSA) or call the OIT Helpdesk at x4-2222 or email oit@uci.edu.
  • VPN may be required once you are granted access.
Column
width60
Info
titleGetting 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. 

  

Section

      

Column
width60
Info
titleReporting Tools

...

width40

...

titleGeneral Availability

COGNOS HOURS OF OPERATION: 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

LEGACY DATA WAREHOUSE: generally available XXXXXXXX

KFS DECISION SUPPORT:

...

Home Page: http://www.oit.uci.edu/bi-dss

ZotPortal Channel: https://portal.uci.edu/uPortal/f/decsupport/normal/render.uP

/wiki/spaces/adcom/pages/68012274

Child Pages

Child pages (Children Display)