...
DWH Team Status Report for 06/13/2014
DWH KFS Decision Support JIRA Tasks - Status Chart
Prior Two Week Activity
Kuali Financial System
Report List
| Report Development Status | Complete | Data Model Changes Needed | In Progress | Incomplete | On Hold | Grand Total |
|---|---|---|---|---|---|---|
| Critical | 21 | 2 | 3 | 2 | 28 | |
| Major | 4 | 2 | 4 | 6 | 1 | 17 |
| Minor | 2 | 2 | 14 | 18 | ||
| TBD | 1 | 1 | ||||
| Grand Total | 27 | 4 | 6 | 24 | 3 | 64 |
| All of the Critical Reports labeled as "Incomplete" or "In Progress" were recently bumped up in priority and are for Accounts Payable, except for the Campus Report (400 Report). |
| Specs are still needed on the "TBD" |
Completed
- ETL bug fixes (ongoing)
Reports developed and currently in QA/approval process:
- Equipment Asset Extract
Expense Accounts - Object Code Credit Balance Report (formerly Credit Balances C&G Only)
Budget Adjustment Report
C&G Income Object Code Summary Report
Construction in Progress
In Progress
- Report specs in development:
DW-CAM-008 Summary of Equipment by Acquisition Code
- Trained Purchasing department on Cognos, showed them their data
- Met with Linda Sizemore to finalize production turnover process, fine tune the reports used by Financial Services
- Balance jobs are now complete with Maribeth's changes, testing is still in progress
- Development of SBS Aging Cognos Package
- Added PDP fields to Cognos package directly from KFS tables in the data warehouse ODS. We will add these to the data model at a later time.
- Met with Housing to review the conversion of their open receivables.
In Progress
Balance jobs are being updated per finalized specs from Maribeth
- Testing of KSAMS Cognos packageDevelopment of SBS Aging Cognos Package
- Final production testing of Talend server
- Production roll-out planning
- Testing of all jobsKuali Budget Reporting - Consultant is currently working with the Budget Office to modify and finish development of phase 1 reports for KBM.
- Ongoing meetings with Focus group
- Build data warehouse tables in production server for KFS, move Cognos reports to point to production database
- Scripts to add KFS attributes to legacy data warehouse (employee, payroll, fs). Coding is complete - currently testing every night for pps daily and every pps month-end. (Grace)
- Conversion of KFS data into legacy tables for use by Payroll Certification and legacy DWH (Grace)
- Testing of new BOToolkit that points to KFS Webservices
- Model and ETL changes needed due to new reporting requirements:
- PURAP - add PDP_PMT_GRP_T.DISB_NBR, PDP_PMT_DTL_T.FDOC_TYP_CD, PDP_PMT_NTE_TXT_T.CUST_NTE_TXT, PDP_PMT_GRP_T.LST_UPDT_TS
- We will have to create new Cognos packages for the "CTS Card Transaction Report" and "AP Group and Individual Performance Report" to go against the ODS (operational data store), due to the fact that it is using many KFS tables that are currently not included in the DS model.
- Scripts to migrate open receivables from FS to data warehouse (Sushma) - Waiting on updated to the crosswalk tables in INT before running tests again- Housing is currently reviewing the data that we converted for them.
Data Warehouse Support
DWH is operating well as usual, Grace is acting as primary DWH production support.
Payroll Certification -
Upgrade to Java 7 - testing in progress
Turnover for Employee.getSOMFacultyData query, new query for Academic Affairs
Next two week planned activities and deliverables
- Continue making bug fixes to ETL scripts and testing
- Continue report development for highest priority reports
- Continue production roll-out planning
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
Currently interviewing for an additional report developer.
...