Enterprise Business Intelligence Solutions

Support

Service Contact: 
Ron Forino
CUIT Executive Owner: 
Elvira Spika, Enterprise Systems

Service Description

Enterprise Business Intelligence Solutions consists of DARTS (Departmental Advanced Tracking & Reporting), COB (Consolidated Operating Budget) and the Data Warehouse.
Status: 
Active
Related Services: 
Financial Systems

Details

Enterprise Business Intelligence Solutions consists of the following reporting and database systems:

DARTS (Departmental Advanced Tracking & Reporting)
A web-based application that brings together diverse University financial data from FAS and LDS to financial administrators, and allows them to run a variety of GL and SL based management reports.
 
SERVICE ELIGIBILITY- Any school, department or individual satisfying prerequisites
 
PREREQUISITES- Approval by the appropriate Functional Owner and the following:
  • Microsoft Internet Explorer (IE) 5.5 or higher is the preferred web browser for DARTS. 
  • You will also need 128-bit encryption, Columbia site certificates, to properly set the IE configurations.
  • These are included in the installation instructions (see web site) 
  • Access to the online Data Warehouse interface.
 
SERVICE INITIATION- For application access contact: Edwin Hamilton or complete this form.
For application security access go to http://www.columbia.edu/acis/adminapps/#fas
 
FEATURES
Access to DARTS is controlled by your Budget Inquiry access in the Security module of the University's Financial Front End (FFE) system. If you do not have access to FFE, you must fill out an application form will need to be filled out.
To access Payroll/Labor information in DARTS you will need to activate the "PAD Access Flag" in your FFE security profile, which requires the approval of your Chairman, Dean or VP. Click to the right for the application form. (Morningside users send the form to the Controller's Office, Health Sciences campus users to the HS Business Office.)
 
STANDARD COSTS
Note: Most expenses to use Enterprise Business Intelligence Solutions applications (i.e. DARTS, COB, Data Warehouse) and databases are centrally funded by the University.
 
SERVICE SUPPORT CONTACTS
Technical Support (create ticket)
DARTS support only: *Service Now Ticket*
 
Technical Support (telephone)
Health Sciences: 305-0213 | Morningside, Lamont, other: 854-1919
 
Login (UNI/Cunix) Id or password problems, please refer to:
Cunix Accountsor COLUMBIA COMPUTING SUPPORT CENTER
 
For all DARTS training related questions click here: DARTS TRAINING
 
SERVICE TARGETS
24/7 application access
 
 
 
COB (Consolidated Operating Budget)
A suite of operating activity reports that provide financial managers with summary and detail views of historical financial data, current operating activity, as well as future year budget information. The report suite serves as a tool for monitoring and budgeting financial activity for a given unit or, at an aggregate level, for a set of units up to a total University level.
 
SERVICE ELIGIBILITY - Any school, department or individual satisfying prerequisites
 
PREREQUISITES - 
  • Approval by the appropriate Functional Owner and the following: Microsoft Internet Explorer (IE) 5.5 or higher, the preferred web browser for the Data Warehouse.  You will also need 128-bit encryption.
  • Access to the online Data Warehouse interface (see below). 
  • Online access to COB reports is governed by your Budget Inquiry access in the Security module of the University's Financial Front End (FFE) system. If you do not have access to FFE, please fill out an application form: http://finance.columbia.edu/forms/DAFFFEapplication.pdf 
 
SERVICE INITIATION - For application access contact Jill Goldstein or complete this form.
For application security access go to http://www.columbia.edu/acis/adminapps/#fas
 
FEATURES
  • On-demand generation of COB reports through an online interface in the my.columbia.edu portal.
  • COB reports can be run against historical data snapshots of Actuals and Budget data as well as the latest Budget entries for immediate review of budget updates in the Budget Tool.
  • Daily generation of Budget Summary, Ledger Cob, Detail, Overdraft and Error files using Excel templates to provide alternative views of COB data.
 
STANDARD COSTS - Note: Most expenses to use Enterprise Business Intelligence Solutions applications (i.e. DARTS, COB, Data Warehouse) and databases are centrally funded by the University.
 
SERVICE SUPPORT CONTACTS - Contact Jill Goldstein (jtg2006@columbia.edu) and/or managementreporting@columbia.edu for COB-related questions.
 
SERVICE TARGETS - 16/7 application access, 8am - midnight.
 
 
 
DATA WAREHOUSE
Provides administrators with reports and, optionally, access to data extracted from the central University systems for analysis, decision support, and ad-hoc reporting. These central systems are:
 
  • Financial Accounting System (FAS)
  • Labor Distribution System (LDS)
  • AP/CAR
  • Purchasing
  • Student Information Systems (SIS, PowerFaids)
  • People @ Columbia (PAC)
 
SERVICE ELIGIBILITY - Any school, department or individual satisfying prerequisites
 
PREREQUISITES
  • Approval by the appropriate Functional Owner and the following:  Microsoft Internet Explorer (IE) 5.5 or higher, the preferred web browser for the Data Warehouse. You will also need 128-bit encryption.
  • Access to the online Data Warehouse interface (see below).
  • Online access to COB reports is governed by your Budget Inquiry access in the Security module of the University's Financial Front End (FFE) system. If you do not have access to FFE, please fill out an application form: http://finance.columbia.edu/forms/DAFFFEapplication.pdf 
  • Authorization to access data stored in the Data Warehouse is granted by the data custodians of the administrative systems listed under CUIT services. For general information about the Data Warehouse, please send mail to dwhmgrs@cuvmc.ais.columbia.edu.
  • Any current model Windows XP or later PC using Internet Explorer version 6 or higher
  • Reports must be deployed using an approved database implementing a design that follows RDBMS or data mart best practices and is accompanied by proper documentation.
  • Qualified report developer
SERVICE INITIATION - For application access go to  www.my.columbia.edu
For the security access form go to: https://www.ais.columbia.edu/ais/nff/ais_id_form1.html
 
FEATURES
Data contained in the Data Warehouse is updated on a daily/monthly basis and provides you with a "snapshot" of the activity recorded on the above specified host systems. You may access data in three ways:
 
  • Web-based Data Warehouse Reporting System (DWR).
  • Downloads and scheduled reports from the Data Warehouse Reporting (DWR) system.
  • Desktop Query Tool. For assistance with ODBC connection, please contact helpdesk.
 
STANDARD COSTS
Note: Most expenses to use Enterprise Business Intelligence Solutions applications (i.e. DARTS, COB, Data Warehouse) and databases are centrally funded by the University.
 
SERVICE SUPPORT CONTACTS -  Please contact administrator at: dwhmgrs@columbia.edu for access to all information in the Data Warehouse systems.
 
SERVICE TARGETS-  16/7 application access, 8am - midnight.
 
 

 

 

 

 

 

 

 

 

 

 
BUSINESS INTELLIGENCE REPORTING
Business Objects report delivery platform supporting the Business Objects suite of report development tools such as Crystal Reports, Web intelligence, Dashboard Builder, Live Office, etc. 
 
SERVICE ELIGIBILITY
Any school, department or individual satisfying prerequisites
 
PREREQUISITES
  • Approval by the appropriate Functional Owner and the following: 
  • Any current model Windows XP or later PC using Internet Explorer version 6 or higher
  • Reports must be deployed using an approved database implementing a design that follows RDBMS or data mart best practices and is accompanied by proper documentation.
  • Qualified report developer
 
SERVICE INITIATION
For application access contact Joe Toscano
For information about security and access, contact the data steward of the subject area data that is needed
 
FEATURES
Delivery of reports organized in folders for departmental users. Reports can be developed with Crystal Reports or Web Intelligence using a CUIT supported database.
 
Standard reports (Crystal Reports) - features include parameter based report creation, report scheduling, bursting, and archiving.
Ad-hoc, self-service and OLAP reporting (Web Intelligence) – Users having a CUIT supported or approved “Universe” can opt to deploy public reports to Business Objects.  
 
STANDARD COSTS
Report Consumers will be able to simply use an approved Web Browser (i.e. Internet Explorer).
 
Report developers will incur the cost of developer licenses. A recurring charge for annual maintenance may also be incurred (typically 22% of license cost).
 
For Deployment of Reports to Business Objects
Standard one time project cost and annual recurring depend on project size and number of users as follows:

Enterprise Business Intelligence Solutions:

Estimated Annual User Charges

 

 

 

 

 

 

 

 

Recurring Charges

 

 

 

 

Business Objects Infrastructure

Description

Incremental Costs To Be Shared

 

 

Small

Medium

Large

Servers

 

$1,152

    $4,032

 TBD 

 

 

 

 

 

Business Objects Administrator

$12,445

 $43,558

 TBD

Sybase Database License

 

 

 

 

Oracle Database License

 

 

 

 

Bus Objects Server license

 

 

 

 

 

Total Recurring Charges

$13,597

 $47,590

 TBD

 

 

 

 

 

 

 

 

 

 

Additional Recurring Charges

 

 

 

 

End-User Reporting Tool Licenses (Procured Directly by Departments)

Description

Small

Medium

Large

Web Intelligence License

$1000 per user

Crystal Reports License

$500 per user

 

 

 

 

 

Required One-Time Charges

 

 

 

Business Objects Infrastructure Setup

Description

Small

Medium

Large

One-time conversion/setup

 

$1,500

4,500

TBD

 

 

 

 

 

 

 

 

Optional One-Time Charges

 

 

 

 

Business Objects Infrastructure Setup

Description

Small

Medium

Large

Report Development- Crystal

Design/develop new report

$1,400

4,200

TBD

Design & develop Universe, Bus View

$2,000

6,000

TBD

Data Mart/Star Schema* Design

$9,800

29,400

TBD

 

 

 

 

 

Notes:

 

 

 

 

 

 

 

 

 

Resource planning per implementation:

 

 

 

 

Small      1 - 25 Users    (Low = 1-12, High = 13 - 25)

 

Medium 26 - 75 Users    (Low = 26 - 50, High = 51-75)

 

Large    76 - 900+ Users (Low = 76 - 250, High = 251+)

 

SERVICE SUPPORT CONTACTS
For PowerFaids or SIS-extracted data contact, Elena Birenbaum in Student Information Systems at 212-854-8535 or send e-mail to infoline@columbia.edu.
 
1st level support – provided by department’s administrator
2nd level support – CUIT’s Business Objects administrator  
 
SERVICE TARGETS - 24/4 application access. Reports will only be available during hours when database is available (e.g. see Data Warehouse availability) 
  

Standard Service Features

Click on our Enterprise Business Intelligence Solutions web site to find information about the data reported in our systems.

Optional

Business Intelligence Reporting: Ability to integrate with University databases, such as Data Warehouse, SIS, PowerFAIDs, etc. 

Costs: 
DARTS, COB and Data Warehouse: NA Business Intelligence Reporting:  Report Development  Design and development of database tables, data mart  Design and development of Universe needed for Web Intelligence reporting  Report development tools (i.e. Crystal Reports developer, WEBI developer)