Versions Compared

Version Old Version 101 New Version Current
Changes made by

Marina Arseniev (Unlicensed)

Valerie Jones

Saved on

Key

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

Table of Contents
typeflat

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
width40
Info
titleRequesting 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. 
  • 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
width40
Info
titleGeneral 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. 

     

     

Column
width60
Info
titleResources

 

 

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 SystemCognosPortal Decision SupportDaily   24/7 
Kuali Financial DocumentseDocs       
Kuali Budget SystemCognosPortal Decision Support      
Kuali Research AdministrationCognosPortal Decision Support      
KSAMSCognosUCI's IBM Cognos ConnectionDaily  Josh Drummond  
Student EnrollmentCognos Daily     
Student AnalyticsCognos       
University AdvancementCognosUCI's IBM Cognos Connection and email deliveryDaily   Julie George  
UCI Medical CenterCognos UCI's IBM Cognos ConnectionDaily   Guna Raman  
Facilities ManagementCognos Zot Portal, Tririga and UCI Cognos Dashboard Monthly and on demand   Aileen Lin  
         
Research Proposal/Award DataBLISSLegacy Data Warehouse (BLISS)      
Employee / HR

BLISS,

eDocs,

Filenet

Daily     
Payroll Expense

BLISS

Monthly     
Payroll/PPS ReportsEDL/MobiusEDL      
SpaceBLISSLegacy Data Warehouse (BLISS)Yearly     
         

Project 

  • Project Timelines / Milestones
  • Status - What are we working on? Scorecards.
  • Strategic Plan (Current state, Future State/Vision, Roadmap, Costs)
  • Presentations

More Information

 

 

...

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)