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
- Assigned look-up reports for COA fields (Account, Object Code, etc.) to student developers
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
- Students will continue to develop KFS look-up reports in Cognos
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 departmentMeet with users from Purchasing to finalize reporting needs
- 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
...