2014_03_28_JonesValerie

DWH Team Status Report for 03/28/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	Critical	Before Go-Live	After Go Live	To Be Determined	Grand Total
Complete	13	1			14
In Development	1				1
In Progress	3		2		5
In QA			1		1
Not Started	4	7	4	18	33
Grand Total	21	8	7	18	54

Completed

Develop Talend job to copy TEM tables to KFS ODS (CTS card tables due to reporting requirements)
Cognos bug fixed with IBM (user with apostrophe in name was unable to run reports)
ETL bug fixes (ongoing)
Training for DS Basics has commenced
New Report Specs Completed for:
- DW-AP-017 Yearly County Personal Property Tax (Replacement of UCPO*PEJ)
- DW-AP-004 Use Tax Payment Detail Report (Replacement of UCAP*MUT)
- DW-AP-016 Separated Employees with Corp Card (Replacement of UCAP*VES)
- DW-AP-003 MC EFT Approved Vendor Monthly Summary (Replacement of UCAP*EFM)
- DW-PL-002 Annual Listing of Plant Assets (Replacement of FS0873)
- DW-AP-015 Outstanding Credit Memos (Replacement of UCAP*402 and UCAP*420SA)
- DW-AP-014 Payments to Overseas Vendors (Replacement of UCAP*OSP)
- DW-AP-013 Vendor Payments Totaling Over $100,000
- DW-AP-012 Disbursement Registry Summary (Replacement of UCAP*40S)
- DW-AP-011 Invoice Exception Report (Replacement of UCAP*DDT)

Total reports developed and published on zotportal staging as of 3/28/2014

Reports developed and currently in QA/approval process:
- Construction in Progress
- Total Fund Overdraft Expenditures for C&G

In Progress

Kuali Budget Reporting - Consultant is developing Sub 0 report, Staffing Report by Account or Organizational Hierarchy.
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)
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) - Users are currently reviewing first sampling of translated data.

Data Warehouse Support

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

Payroll Certification - Code changes to update executive level 2 salary caps completed.

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.

Anh (ETL developer) is out on vacation for 2 weeks.

Public Documents