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 6 Next »

 

DWH Team Status Report for 02/14/2014

DWH KFS Decision Support JIRA Tasks - Status Chart

Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Prior Two Week Activity

Kuali Financial System

 

Report List

 


 

 

 

Completed
  • Worked with consultant to install Talend on Solaris
  • Configuration of TalenD on Solaris in new version 5.3
  • Migration of Talend jobs to new version 5.3
  • Cognos framework development for KSAMS (in testing)
  • Review security options for Cognos reports with stakeholders
  • Complete testing of TalenD install on UNIX
  • Turnover of scripts to add KFS chart of accounts to people tables and Administrative LDAP

In Progress
  • Kuali Budget Reporting - Consultant is developing Sub 0 report
  • Develop SMS and Workflow Cognos packages
  • 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
  • Training materials are in development (Kevin)
  • 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)

Data Warehouse Support

DWH is operating well as usual, Grace is acting as primary DWH production support. 
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
  • Present Sub 0 report to budget office
  • Meet with Financial Services to finalize requirements

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

UCOP has contacted us regarding Phase 2 of the Spend Analytics project. We will need some additional resources to work on this project next year.

 


 

 

  • No labels