|
|
|
What's New
|
Phase II of the Caltech Data Warehouse is live ,effective Thursday, 14 August 2008. Three new datamarts have been added: FAMIS (Facilities information), GA (Grants Accounting), and LD (Labor Distribution).
To get started, register for a training session. Upon completing training, you will be able to login to the new Caltech Data Warehouse with your access.caltech username and password.
NOTE: Firefox 2.0 is the only recommended browser for MAC users.
Click here for more information.
|
Coming Soon
|
More datamarts will follow. The Human Resources and Student Affairs datamart will be added in 2009.
|
What is the Caltech Data Warehouse?
|
Overview
The Caltech Data Warehouse is a reporting tool that gathers and analyzes data from the central administrative systems. It takes huge amounts of data from various source systems and converts it into meaningful information.
The new datamarts are described below.
Grants Accounting Datamart
The Caltech Grants Accounting (GA) Datamart consists of essential financial reporting information from the Oracle Applications Grants Accounting module. Information in the GA Datamart includes financial summaries; expenditure and commitment details; and installment, funding, and budgeting data.
FAMIS Datamart (Facilities)
The Caltech FAMIS Datamart consists of essential Facilities information from the FAMIS system. Information in the FAMIS Datamart includes Capital Project cost analysis, work order detail, labor utilization, equipment history, and building maintenance costs.
Labor Distribution Datamart
The Labor Distribution (LD) Datamart consists of essential labor schedule and distribution information from Oracle Applications' Labor Distribution module. Information in the LD Datamart includes detailed information on employees' labor schedules, labor distributions and adjustments.
The LD Datamart is updated on a nightly basis.
|
History
|
Caltech implemented its first Data Warehouse in 1999 when the Oracle Applications went live. Since then, Oracle Discoverer and Webster have been the main reporting tools on Campus. Approximately 1,500 people still use Discoverer for reporting. Over the last several years, other reporting tools have been implemented to meet the needs of specific business areas. These tools are not integrated with one another.
In 2005, Caltech purchased the Cognos reporting tool. The first phase of the Caltech Data Warehouse re-design project implemented the Accounts Payable, Purchasing, and General Ledger datamarts. For the first time, Caltech had an integrated reporting tool that could be expanded to fit the needs of a Campus-wide user community. |
|
|
