2014_07_18_JonesValerie

DWH Team Status Report for 07/18/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	Grand Total
Critical	26		1	3	33
Major	6	2	4	5	17
Minor	3	2		14	20
Grand Total	35	4	5	22	70

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)
Multiple AP reports have been developed
Turnover of ETL and reports to production
Scripts to add KFS fields to legacy DWH has been turned over

In Progress

Ongoing meetings with Focus group
KBM Cognos package and report development
Legacy DWH fiscal year end
Preparation of turnover of DWH queries with added KFS fields (Employee, Payroll, FS)
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)
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.

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