Versions Compared

Version Old Version 1 New Version Current
Changes made by

vjones

vjones

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DWH Team Status Report for 04/26/2013

DWH KFS Decision Support JIRA Tasks - Status Chart

 Image Added

Prior Two Week Activity

Kuali Financial System

Completed
  • Updated SNAP KFS Decision Support Channel to include new reports
  • Hired two students for report development and java development related to KFS data warehouse
  • Clean up of ETL scripts for asset, project, object, fiscal period, org, chart, doc details, doc type dimensions based on recently updated schema
  • Talend Production Server is up and running on bert (UNIX)
In Progress
  • Training new student hires
  • Updating Cognos framework that points directly to KFS - adding crosswalk tables and other tables needed to develop look-up reports
  • Scripts to add KFS attributes to legacy data warehouse (employee, payroll, fs). Coding is complete - currently testing each time COA is re-loaded.
  • Implement the changes to the data model on the database, fixing any jobs that break as a result of the database changesContinue updating up the account dimension job per recent schema changes in data warehouse tables
  • Fixing incorrect balance specs
  • Returned balance ETL jobs to consultant for bug fixes
  • Upgrading TalenD jobs to newer version on the production server
  • Development for FS0150, FS0209 (for standard reconciliation) equivalent reports
  • Document a distinct list of Cognos reports to be developed for KFS with prioritization
  • Script to load the PPS title table into KFS - all KFS schemas loaded except for two
  • ETL specifications for PURAPScheduling of all completed ETL jobs on Talend Server
  • Development of scripts to migrate open receivables transactions from legacy DWH to KFS DWH Talend server installation on UNIX - still waiting on installation- Linda reported back last week with her requirements, which will be very helpful.
  • Students will continue to develop KFS look-up reports in Cognos
  • Document and provide data warehouse team the list of fund groups needed to add to the database for FS0150 style reports

Data Warehouse Support

DWH is operating well as usual, Grace is acting as primary DWH production support.Payroll Certification - Tammy had to make a change to the DOS code list and re-load the executive level code table for the DHHS per request from C&G accounting. This was turned over last week.

Next two week planned activities and deliverables

Schedule follow-up meetings with Purchasing users to finalize reporting requirements

  • Continue making bug fixes to ETL scripts and testing
  • Continue working on approval for high priority reports
  • Plans for Cognos portal/user experience for Cognos (SNAP) - will work with focus group on this project
    Report specs approval for Capital Asset and PURAPContinue report development for highest priority reports
  • Student to begin enhancement of BOToolkit, to allow queries against KFS web services
    Complete hiring process for student employees and begin training

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

Students will need systems to work on.

Training requests

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