/
2014_08_01_JonesValerie

2014_08_01_JonesValerie

 

DWH Team Status Report for 08/01/2014

DWH KFS Decision Support JIRA Tasks - Status Chart

Prior Two Week Activity

Kuali Financial System

Report List

 

Report Development StatusCanceledCompleteIn ProgressIncompleteGrand Total
Critical3262233
Major 82717
Minor13 1519
Grand Total43742469

 

Most 'Incomplete' reports are either 'Minor' priority, need specs or are KBM reports.
  • ETL bug fixes (ongoing)
  • Report bug fixes (ongoing)
  • Recent reports added/modified:
    • Account Transaction
    • Control Account Summary (more changes in progress)
    •  Account GL Detail Adhoc
    • Construction in Progress
    • Income, Asset, Liability Transaction Report
    • Expense Account Summary
    • Encumbrance Report
    • Object Summary (AS LI)
    • Account Summary by Object Report
    • Account Log by Fiscal Officer for Reconciliation
    • PDP Check Report
    • Account Lookup
    • Crosswalk Object Lookup
    • Object Code Lookup
  • Open receivables transactions migrated on 8/1 to KFS DWH
  • Changes to Legacy DWH to create new fiscal year for Payroll queries only
  • Scripts to add KFS attributes to legacy data warehouse (employee, payroll)
  • Turnover of DWH queries with added KFS fields (Employee, Payroll)
In Progress
  • Ongoing meetings with Focus group
  • KBM Cognos package and report development
  • Legacy DWH fiscal year end

Data Warehouse Support

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

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

 

 

Budget requests for any new software or hardware

Training requests

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