DWH Team Status Report for 03/14/2014

DWH KFS Decision Support JIRA Tasks - Status Chart

The Jira server didn't understand your search query. If you entered JQL, please ensure that it's correctly formed. If you entered an issue key, ensure that it exists and you have permission to view it.

Prior Two Week Activity

Kuali Financial System

Report List

Status/Priority	1-Critical	2-Before Go-live	3-After Go-live	TBD	Grand Total
Completed	16	1			17
In Progress	4		3		7
In QA			1		1
Incomplete	5	10	4	11	30
Grand Total	25	11	8	11	55

Completed

Added a current indicator to Fiscal Period dimension to reflect current open period in KFS
ETL bug fixes (ongoing)
Script to load SBS aging data (in KFS format) into DWH
Develop SMS Cognos package for Medical Center
Training materials for DS Basics class (Kevin)
New Report Specs Completed for:
- DW-AP-008 AP Group and Individual Performance Report (Replacement of AP*GIP)
- DW-AP-010 CTS Card Transaction Report (Replacement of PAL317-APL)
- DW-AP-001 Stale Dated Check Report (Replacement of PAL214)
- DW-AP-009 Daily Disbursement Register (Replacement of UCAP*40D)
- DW-AP-007 US Bank Control Report (Replacement of PAL317-USBANK)
- DW-CAM-007 Equipment Asset Extract
Total reports developed and published on zotportal staging as of 3/17/2014

Reports developed and currently in QA/approval process:
- Construction in Progress
- Total Fund Overdraft Expenditures for C&G
- Lookup report for KFS Accounts
Budget office is currently reviewing Staffing Report

In Progress

Kuali Budget Reporting - Consultant is developing Sub 0 report, Staffing Report by Account or Organizational Hierarchy. One of the calculations in the Sub 0 report specs is incorrect, waiting on the Budget Office to update the specs with and updated formula.
Working with IBM support on Cognos bug (Tammy, Durendal)
Report spec developing for CAM and PURAP
Ongoing meetings with Focus group
Build data warehouse tables in production server for KFS, move Cognos reports to point to production database (Anh)
Testing of Talend jobs on UNIX server, configuration changes as needed. (Valerie, Anh)
Planning for production Talend server architecture (Brian)
Planning for production Cognos architecture (Durendal, Mat)
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)
Code Review and 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. The "CTS Card Transaction Report" includes CTS card data, which was not originally in the scope of the KFS decision support project.
Scripts to migrate open receivables from FS to data warehouse (Sushma)

Data Warehouse Support

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

Upgrade to Java 7 - testing in progress

Next two week planned activities and deliverables

Continue making bug fixes to ETL scripts and testing
Continue report development for highest priority reports

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.

Budget requests for any new software or hardware

Training requests

Things learned, suggestions for improvements or anything else you think might be important

Browser not supported