Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

DWH Team Status Report for 09/20/2013

DWH KFS Decision Support JIRA Tasks - Status Chart

Prior Two Week Activity

Kuali Financial System

Completed
  • Cognos Report Stats:
    • Number Cognos Reports to be developed for Phase I: 15
    • Number of Phase I Cognos Reports developed (pending testing): 11
    • Remaining Phase I Reports to be developed: 4
    • Total Reports to be developed (all phases): 38
  • 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
  • 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
  • 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

 


 

 

  • No labels