Enterprise Performance Management (EPM)
Click on the links to download the star schemas. Some of the files are zipped and you will need the Visio Reader to view the information. You can download the Visio Reader here.
- Finance Star Schemas (Visio file) [04 Mar 2004]
- HR/Payroll Star Schemas (Visio file) [04 Mar 2004]
- Student Star Schema (Visio file)[12 Feb 2004]
- Grant Star Schema (Html file)[27 Aug 2004]
Click on the links to download the warehouse staging structure. Some of the files are zipped and you need the Visio Reader to view the information. You can download the Visio Reader here.
- Finance Warehouse Structure (Visio file) [25 Feb 2004]
- HR/Payroll Warehouse Structure (Visio file) [22 Jan 2004]
- Student Warehouse Structure (Html file) [03 Aug 2004]
Click on the links to download the data dictionaries.
- Student Warehouse Data Dictionary (Excel file)[28 Jan 2004]
Information regarding the implementation of PeopleSoft EPM system, including the Operational Data Store (ODS), Data Warehouse and Data Marts, will be available here. In addition, this site will provide information regarding the Cognos suite of business intelligence and reporting tools which have been licensed by UF as well as information about legacy data available in the EPM.
- UF Reporting/Data Warehouse Strategy: draft statement of direction [15 Dec 2002]
- Cognos Reporting Architecture [04 Apr 2003]
- University of Florida Value Chain [18 Jul 2003]
Status Reports
- 24 May 2004 –– Enterprise Reporting, Cognos, Student/ Directory Datamart, Budget Preparation Application.
- 27 Apr 2004 –– Student / Directory Datamart, Cognos, Enterprise Reporting, Budget Preparation Application.
- 19 Apr 2004 –– Student / Directory Datamart, Cognos, Enterprise Reporting, Budget Preparation Application.
- 12 Apr 2004 –– Student / Directory Datamart, Cognos, Budget Preparation Application.
- 05 Apr 2004 –– Student / Directory Datamart, Cognos, Budget Preparation Application.
- 15 Mar 2004 –– PS Jumpstart HR and Finance Datamarts, Student Directory Datamart, Cognos.
- 08 Mar 2004 –– PS Jumpstart HR and Finance Datamarts, Student Directory Datamart, Cognos.
- 01 Mar 2004 –– PS Jumpstart HR and Finance Datamarts, Student Directory Datamart, Cognos.
- 22 Feb 2004 –– PS Jumpstart HR and Finance Datamarts, Student Directory Datamart, Cognos.
- 16 Feb 2004 –– PS Jumpstart HR and Finance Datamarts, Student Directory Datamart, Cognos.
- 09 Feb 2004 –– PS Jumpstart HR and Finance Datamarts, Student Directory Datamart, Cognos.
- 02 Feb 2004 –– PS Jumpstart HR and Finance Datamarts, Student / Directory Datamart, Cognos, Other.
- 22 Jan 2004 –– PS Jumpstart HR and Finance Datamarts, Student Directory Datamart, Budget Prep and Grad Waivers, Cognos.
- 12 Jan 2004 –– PS Jumpstart HR and Finance Datamarts, Student Directory Datamart, Budget Prep and Grad Waivers, Cognos.
- 22 Dec 2003 –– Cognos, PS Jumpstart.
- 15 Dec 2003 –– Cognos, DB2 Version 8 Upgrade, PS Jumpstart.
- 01 Dec 2003 –– Cognos, Report Requirements.
- 24 Nov 2003 –– Cognos, Report Requirements.
- 03 Nov 2003 –– Cognos, EPM, Report Requirements.
- 27 Oct 2003 –– Cognos, EPM, Report Requirements.
- 20 Oct 2003 –– Cognos, EPM, Report Requirements.
- 25 Aug 2003 –– Cognos, Production Security
- 11 Aug 2003 –– Cognos, Production Security
- 04 Aug 2003 –– Cognos, Productio Security
- 28 Jul 2003 –– Cognos, Production Security
- 14 Jul 2003 –– Cognos, Reporting Beta Instance, GL Authentication
- 07 Jul 2003 –– Cognos Portal Integration, GL Authentication, Beta System Deployment.
- 30 Jun 2003 –– Cognos.
- 23 Jun 2003 –– Cognos.
- 05 May 2003 –– Cognos, Training, AUC.
- 28 Apr 2003 –– Cognos, Training, AUC.
- 21 Apr 2003 –– Cognos, Cognos/PeopleSoft Integration, AUC.
- 14 Apr 2003 –– Cognos, Training, Cognos/PeopleSoft Integration, AUC.
- 07 Apr 2003 –– Training, Cognos, AUC, EPM.
- 31 Mar 2003 –– Training, Staffing, Cognos, AUC.
- 24 Mar 2003 –– Training, Staffing, GatorLink Authentication, AUC.
- 17 Mar 2003 –– EPM, Report Survey and Analysis, Training, AUC.
- 10 Mar 2003 –– Cognos, Training, AUC, EPM.
- 03 Mar 2003 –– Cognos, Training, Project Plan, AUC.
- 24 Feb 2003 –– Staffing, Cognos, Training, AUC.
- 17 Feb 2003 –– UF Directory Integration to PS Modules, Functional Group Assistance, Security, Roles and Permissions, Integration, and Usage of PeopleSoft Instances, Staffing, Cognos, Training.
- 10 Feb 2003 –– UF Directory Integration to PS Modules, Staffing, Cognos, Training, Planning, Standards Documents.
- 03 Feb 2003 –– UF Directory Integration to PS Modules, Staffing, Cognos, Training, Planning, Standards Documents.
