DWH Team Status Report for 03/08/2013
DWH KFS Decision Support JIRA Tasks - Status Chart
Prior Two Week Activity
Kuali Financial System
Completed
- Consultant delivered KIM/Workflow data model - currently being reviewed
- Prototype of Decision Support SNAP channel
- First draft of the FS0100 equivalent report
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.
- Code review of ETL jobs delivered from consultant for balances, and capital assets
- Development for FS0150, FS0209 (for standard reconciliation) equivalent reports
Cognos framework model development for PURAP - Report prioritization
- Report Specs for capital asset module reports
- ETL development for PURAP
- 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
- Software installation for Cognos production servers
- Talend server installation on UNIX - final configuration needed
Reports to Be Developed with Prioritization:
| Undecided | AP | KFS | SC - System Constraint | 12/1/2012 | 1/1/2013 | 4/1/2013 | 7/1/2013 | 10/1/2013 | 12/1/2013 | 4/1/2014 | Grand Total | |
| ACCTSYS | 0 | 0 | ||||||||||
| AP | 0 | 1 | 1 | 3 | 3 | 2 | 10 | |||||
| AP GA | 0 | 0 | ||||||||||
| APMC | 0 | 1 | 1 | |||||||||
| APTRAV | 0 | 1 | 1 | 1 | 3 | |||||||
| BKSTORE | 0 | 1 | 1 | |||||||||
| BO | 1 | 2 | 3 | |||||||||
| BO GA | 1 | 1 | ||||||||||
| CAM | 0 | 1 | 1 | |||||||||
| CAM MC | 1 | 1 | ||||||||||
| CAMPUS | 2 | 2 | 4 | |||||||||
| CG | 0 | 1 | 1 | 1 | 3 | |||||||
| EH&S | 0 | 0 | ||||||||||
| FA | 0 | 0 | ||||||||||
| FA/FS | 1 | 1 | 2 | |||||||||
| FinAid | 0 | 0 | ||||||||||
| FINSERV | 1 | 1 | ||||||||||
| FS | 0 | 0 | ||||||||||
| GA | 5 | 1 | 0 | 7 | 10 | 12 | 1 | 6 | 42 | |||
| GA-TAX | 0 | 0 | 0 | |||||||||
| GRAD | 0 | 0 | ||||||||||
| MC | 0 | 0 | ||||||||||
| OIT | 0 | 1 | 1 | |||||||||
| OIT-OPS | 2 | 1 | 3 | |||||||||
| PUR | 0 | 0 | 1 | 0 | 1 | |||||||
| PURAP | 0 | 0 | ||||||||||
| Grand Total | 9 | 1 | 2 | 1 | 2 | 3 | 10 | 21 | 19 | 1 | 9 | 78 |
Undecided = Still needs to be prioritized
SC = System Constraint - not able to get report from KFS
KFS = Data can be retrieved from KFS for now
Payroll Certification
DHHS enhancement is now in production. Tammy will continue supporting this application and addressing any issues as needed.
Data Warehouse Support
DWH is operating well as usual, Grace is acting as primary DWH production support.
Next two week planned activities and deliverables
- Cognos model for PURAP
- Continue working on approval for high priority reports
- Plans for Cognos portal/user experience for Cognos (SNAP)
- 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
Due to a delay in approvals of report specifications, we are severely behind schedule for report development.
We will hire a student to assist with report development for the simpler reports. Charles Lowe will also assist with report development, along with developing prompt pages for all reports.
Budget requests for any new software or hardware
Training requests
Things learned, suggestions for improvements or anything else you think might be important
None at this time