2014_06_13_JonesValerie

DWH Team Status Report for 06/13/2014

DWH KFS Decision Support JIRA Tasks - Status Chart

Prior Two Week Activity

Kuali Financial System

Report List

Report Development Status	Complete	Data Model Changes Needed	In Progress	Incomplete	On Hold	Grand Total
Critical	21		2	3	2	28
Major	4	2	4	6	1	17
Minor	2	2		14		18
TBD				1		1
Grand Total	27	4	6	24	3	64

All of the Critical Reports labeled as "Incomplete" or "In Progress" were recently bumped up in priority and are for Accounts Payable, except for the Campus Report (400 Report).

Specs are still needed on the "TBD"

Completed

ETL bug fixes (ongoing)
Trained Purchasing department on Cognos, showed them their data
Met with Linda Sizemore to finalize production turnover process, fine tune the reports used by Financial Services
Balance jobs are now complete with Maribeth's changes, testing is still in progress
Development of SBS Aging Cognos Package
Added PDP fields to Cognos package directly from KFS tables in the data warehouse ODS. We will add these to the data model at a later time.
Met with Housing to review the conversion of their open receivables.

In Progress

Balance jobs are being updated per finalized specs from Maribeth
Testing of KSAMS Cognos package

Final production testing of Talend server
Production roll-out planning
Testing of all jobs
Ongoing meetings with Focus group
Build data warehouse tables in production server for KFS, move Cognos reports to point to production database
Scripts to add KFS attributes to legacy data warehouse (employee, payroll, fs). Coding is complete - currently testing every night for pps daily and every pps month-end. (Grace)
Conversion of KFS data into legacy tables for use by Payroll Certification and legacy DWH (Grace)
Testing of new BOToolkit that points to KFS Webservices
Model and ETL changes needed due to new reporting requirements:
- PURAP - add PDP_PMT_GRP_T.DISB_NBR, PDP_PMT_DTL_T.FDOC_TYP_CD, PDP_PMT_NTE_TXT_T.CUST_NTE_TXT, PDP_PMT_GRP_T.LST_UPDT_TS
We will have to create new Cognos packages for the "CTS Card Transaction Report" and "AP Group and Individual Performance Report" to go against the ODS (operational data store), due to the fact that it is using many KFS tables that are currently not included in the DS model.
Scripts to migrate open receivables from FS to data warehouse - Housing is currently reviewing the data that we converted for them.

Data Warehouse Support

DWH is operating well as usual, Grace is acting as primary DWH production support.

Payroll Certification -

Upgrade to Java 7 - testing in progress

Turnover for Employee.getSOMFacultyData query, new query for Academic Affairs

Next two week planned activities and deliverables

Continue making bug fixes to ETL scripts and testing
Continue report development for highest priority reports
Continue production roll-out planning

Production support trends in terms of tickets either in JIRA or Footprints.

DWH Production Support 10%, New development 90% (except Grace)

Staffing issues or personnel related matters

Currently interviewing for an additional report developer.

Public Documents