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

DWH Team Status Report for 03/22/2013

DWH KFS Decision Support JIRA Tasks - Status Chart

 

 

Prior Two Week Activity

Kuali Financial System

Completed
  • Met with Purchasing to give a brief training session on Cognos and discuss their reporting needs
  • Met with focus group to discuss user experience in Decision Support and assign work to the team
  • Focus group will assist with re-naming all KFS Cognos query items (currently they are not very user friendly)
  • ETL development for all PURAP dimensions, encountered a problem loading the PURAP fact table (Ticket has been submitted to Talend support, marked high priority!)
  • Software installation for Cognos production servers
  • Clean-up of data model to fix any inconsistencies, remove unused columns and add new columns

 

In Progress
  • 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, fix any jobs that break as a result of the database changes
  • Code review of ETL jobs delivered from consultant for balances, and capital assets
  • Development for FS0150, FS0209 (for standard reconciliation) equivalent reports
  • Document a distinct list of Cognos reports to be developed for KFS with prioritization
  • Report Specs for capital asset module reports
  • ETL specifications for PURAP
  • Requirements gathering for Accounts Payable and PURAP modules
  • Development of scripts to migrate open receivables transactions from legacy DWH to KFS DWH
  • Talend server installation on UNIX - still waiting on installation, email has been sent to sys admin this morning asking for status

Data Warehouse Support

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

Next two week planned activities and deliverables

  • Schedule follow-up meetings with Purchasing users to finalize reporting requirements
  • 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
  • Finalize requirements for Purchasing department
  • Report specs approval for Capital Asset and PURAP
  • Continue report development for highest priority reports

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

We were approved to hire 2 additional students to assist with ETL work and report development. Interviews are in progress and we hope to make an offer by early next week.

Budget requests for any new software or hardware

Training requests

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

I have been getting a few requests from other developers on campus to implement queries for KFS data in the legacy data warehouse. They have told me that they do not have the expertise in-house to change their code to use our new web services. Many of these users call to data warehouse using the BO Toolkit which is very convenient. We may have to consider writing some legacy data warehouse queries for these users or allow them direct database access if we want them to make the July deadline to convert their systems.

 

 

  • No labels