DWH Team Status Report for 09/20/2013

DWH KFS Decision Support JIRA Tasks - Status Chart

Prior Two Week Activity

Kuali Financial System

Completed

New Cognos Package (v4) has been published with updated data item labels (per user group's request)
Updated user interfaces on all reports
Updated Decision Support channel on snaptest - added FS200 E/R equivalent reports
Initial ODS built for Kuali Budget Reporting, more tables will probably be needed as new report requirements are developed
Indexed tables to help improve report performance

In Progress

Kuali Budget Reporting - Consultant started building Cognos framework package (rSmart)
Consultant is also reviewing all developed KFS reports (rSmart)
Adding drill-through capability to summary reports
Scheduling all jobs to run weekly (Sunday nights)
Working with focus group to come up with Cognos packages with a subset of most commonly used attributes for adhoc query usage
Training materials are in development (Kevin)
Adding KFS fields to DWH queries, Employee and Ledger Detail (student)
Prototyping of prompt pages for Cognos reports (student)
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)
Development of scripts to migrate open receivables transactions from legacy DWH to KFS DWH (Anh)

Data Warehouse Support

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

Upgrade to Java 7 - testing in progress

Payroll Certification - Data extraction, pulling documentation together to provide to NSF/HHS for the HHS audit. HHS IT auditors are in OIT for 2 weeks (9/16 - 9/27)

Next two week planned activities and deliverables

KBM reporting consultant on-site on Tuesday 9/24, we will meet with the Budget Office for additional reporting requirements
Load CFS balances for June, July, and August into KFS tables for balance reconciliation
Continue making bug fixes to ETL scripts and testing
Continue report development for highest priority reports
Build data warehouse tables in production server for KFS, move Cognos reports to point to production database
Code Review for enhancement to DWH BOToolkit to allow calls to new KFS web services

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

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