Project (ServiceNow Link) | Description | Start | Current Status | Comments |
|---|---|---|---|---|
| /wiki/spaces/adcom/pages/68026129 (ServiceNow) | Accounting is requesting the ability to run specific Cognos reports in batch mode and burst the output to a secure location where campus fiscal officers can review their reports. For a later phase, Accounting wants fiscal officers to be able to annotate and/or sign-off on the burst reports. | 3/1/2016 | Complete | |
| Implement easy-to-use "save query" functionality in Cognos reports (ServiceNow) | It is difficult for Cognos users to save query selections to easily re-run the same report at a later time. Implement an easy-to-use "save query" where the user presses a "Save" button, a window pops-up and asks for a name (optionally, a description) and all parameters will be saved. Also implement a "Load" button where the user can choose a previously-saved query. When a saved query is chosen, the prompt screen is re-loaded with all previous parameters. The user may make changes (eg: change the fiscal period) and hit "Run" to re-run the query. | 2/24/2016 | Complete | Phase 2 pending 2016 year end and 2017-01 month end. |
| Develop a TM1 forecasting application to produce financial forecasts for the Budget Office based on the SRECNP (Statement of Revenues, Expenses and Changes in Net Position). | 12/15/2015 | Complete (received sign-off from Katherine Gallardo) | Please see EKS&H Design Doc in wiki | |
| KFS Historical Chart of Accounts | Enhancement of KFS data warehouse to track changes on the chart of accounts attributes. Develop reports to display historical attributes based on requirements. | 9/1/2015 | In Testing | Data model design and ETL complete, changes will be implemented in Fall 2016 |
| KFS Pending Entries | New addition to KFS data warehouse to include pending entries. Modify or develop reports based on requirements. | 9/1/2015 | In Testing | Data model design and ETL complete, changes will be implemented in Fall 2016 |
| KFS Purchasing/Accounts Payable | New addition to KFS data warehouse to include purchasing and accounts payable documents, attributes and transactions. Develop reports based on requirements. | 9/1/2015 | In Progress | Modeling is complete. ETL and Cognos framework development is in progress. |
| KFS Kuali Budget (KBM) | New addition to KFS data warehouse to include Kuali Budget Module (KBM) documents, attributes and transactions. Develop reports based on requirements. | 5/1/2016 | In Progress | Requirements gathering and functional specification development in progress. Data model design in progress. |
| AdHoc Query Tool (ServiceNow) | Develop an ad-hoc prompting interface for Cognos that provides more usability and flexibility than the current tool, which is simpler to use and guides the user more than Workspace Advanced. This interface should address immediate needs for KFS GL ad-hoc prompting, and also be generalizable for other KFS data sets and other subject areas, including HR/Payroll (UCPath) and student (Banner). | 4/1/2016 | In Progress | Proof of concept using Data Clarity completed. So far no tools have been identified that can be deployed w/o programming. Will continue to use BLISS until further notice. |
| Implement the UCPath CDW (Common Data Warehouse), including UCI customizations. Import Informatica mappings delivered from UCLA. Maintain UCI's implementation of the DDODS (data dissemination operational data store). Design SQL Views to be used by campus Tier-N systems using the Enterprise Service Bus (ESB). Develop reports based on campus and UCIMC requirements. | In Progress | |||
| Re-design process for loading Administrative LDAP | As the first phase of the Internal Directory decommission, re-design the ETL process to load tables used to load employees, guests, and group accounts into the Administrative LDAP. Maintain and track historical changes. | In Progress | ||
| Research Administration Reporting & Data Warehouse | Phase I of project (report remediation): Develop ODS and replace legacy reports with new reports in Cognos Phase II of project (new reports): Develop ODS and/or dimensional data warehouse and reports based on requirements | 3/2/2015 | In Progress | Phase I is complete. Phase II requirements gathering is in progress. |
| /wiki/spaces/SIS/pages/21103609 (SIS) | Work with Ellucian to implement Banner ODS, EDW and reporting for SIS and related student systems. This project also includes integration of historical student data into the ODS, as well as Canvas, DegreeWorks, GradAid and other student systems as needed. | In Progress | ||
| Implement metadata maintenance using Data Cookbook (ServiceNow) | Implement Data Cookbook as a metadata management tool. | 5/1/2016 | In Progress | Finishing configuration; working with OIR as functional owners to identify data owners & stewards; workflow. |
| /wiki/spaces/public/pages/31361193 | Cognos 11, aka Cognos Analytics, was released in December 2015. This latest release of Cognos offers a more modern GUI, and consolation of several report development tools. | 8/1/2016 | In Progress | Installation of test instance in progress. |