/
2013_02_22_JonesValerie
2013_02_22_JonesValerie
- vjones (Unlicensed)
Owned by vjones (Unlicensed)
DWH Team Status Report for 02/22/2013
DWH KFS Decision Support JIRA Tasks - Status Chart
Prior Two Week Activity
Kuali Financial System
Completed
- Code review of all chart of accounts and ledger jobs
- Specs for highest priority reports delivered to General Accounting for sign off
- All data for chart of accounts and ledger details transactions has loaded successfully
- Hardware setup for Cognos production servers
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, FS0100, FS0209 (for standard reconciliation) equivalent reports
- Data Model for Workflow and Security
- 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:
| Legacy System | Undecided | KFS | SC | 12/1/2012 | 1/1/2013 | 4/1/2013 | 7/1/2013 | 10/1/2013 | 12/1/2013 | 4/1/2014 | Grand Total |
| DRS | 1 | 1 | |||||||||
| EQS | 1 | 1 | 1 | 3 | |||||||
| FS | 3 | 1 | 2 | 9 | 16 | 14 | 1 | 6 | 52 | ||
| PAL | 0 | 0 | 1 | 1 | 0 | 2 | |||||
| PPP | 1 | 1 | |||||||||
| UCAP | 4 | 1 | 1 | 1 | 4 | 4 | 1 | 16 | |||
| UCFS | 0 | 0 | |||||||||
| UCOP | 1 | 1 | |||||||||
| UCPO | 1 | 0 | 1 | 2 | |||||||
| Grand Total | 8 | 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
Code changes completed for DHHS enhancement and has been handed to Contracts and Grants Accounting for functional testing.
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
- Data Model for Authorization/Workflow module (KIM)
- Plans for Cognos portal/user experience for Cognos (SNAP)
- Finalize requirements for Purchasing department
- Report specs approval for Capital Asset and PURAP
- Report development for highest priority reports
- Talend Server load testing (Windows vs. UNIX)
- Report design guide document
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. As a result, Durendal will assist with Cognos report development.
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