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

Completed

ETL bug fixes (ongoing)

Reports developed and currently in QA/approval process:
- Equipment Asset Extract
- Expense Accounts - Object Code Credit Balance Report (formerly Credit Balances C&G Only)
- Budget Adjustment Report
- C&G Income Object Code Summary Report
- Construction in Progress

In Progress

Report specs in development:
- DW-CAM-008 Summary of Equipment by Acquisition Code
Balance jobs are being updated per finalized specs from Maribeth
Testing of KSAMS Cognos package
Development of SBS Aging Cognos Package
Final production testing of Talend server
Production roll-out planning
Testing of all jobs
Kuali Budget Reporting - Consultant is currently working with the Budget Office to modify and finish development of phase 1 reports for KBM.
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 (Sushma) - Waiting on updated to the crosswalk tables in INT before running tests again.

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.