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 channelFirst draft of the FS0100 equivalent report
- The base reports (FS0100 Balance Sheet, Expenditure and Object Summary) reports have been created in Decision Support. They are accurately reflecting all data that has been feed into KFS-INT. Also, drill-through to transactional detail has been implemented.
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
...