DWH Team Status Report for 02/28/2014

DWH KFS Decision Support JIRA Tasks - Status Chart

The Jira server didn't understand your search query. If you entered JQL, please ensure that it's correctly formed. If you entered an issue key, ensure that it exists and you have permission to view it.

Prior Two Week Activity

Kuali Financial System

Report List

Status/Priority	1-Critical	2-Before Go-live	3-After Go-live	TBD	Grand Total
Completed	15	1			16
In Progress	2		2		4
In QA			1		1
Incomplete	5	11	4	2	22
On Hold			1		1
Grand Total	22	12	8	2	44

Completed

Presented first draft of the Workflow Cognos model to the Workflow lead analyst (Caryn Bender). Caryn and Kevin Chung will test this model and send Valerie any additional requirements.
Added C&G Fields to Account Dimension per report requirements
Added Purchase Order Number, fund information, and UC location code to Asset Dimension per report requirements
Create a copy of the GL_ENTRY_T table from KFSCNV on nebula for transactional systems requiring access to the CNV data for testing
Misc bug fixes to ETL scripts
Met with IBM to discuss Cognos sizing and address performance concerns
New Report Specs Completed for:
- DW-CAM-007 Equipment Asset Extract
- KBM RAFG Report
Total reports developed and published on zotportal staging as of 2/28/2014:
Reports developed and currently in QA/approval process:
- C&G INCOME Object Code Summary Report
- Expense Account Summary
- Designated Object Summary for Central Office
- Construction in Progress
- Credit Balances C&G Only
- Total Fund Overdraft Expenditures for C&G

In Progress

Kuali Budget Reporting - Consultant is developing Sub 0 report, Staffing Report by Account or Organizational Hierarchy. One of the calculations in the Sub 0 report specs is incorrect, waiting on the Budget Office to update the specs with and updated formula.
Develop SMS Cognos package for Medical Center
Develop scripts to load new SBS Aging files into DWH
Lookup report for KFS Accounts
Report spec developing for CAM and PURAP
Ongoing meetings with Focus group
Build data warehouse tables in production server for KFS, move Cognos reports to point to production database
Training materials are in development (Kevin)
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)

Data Warehouse Support

DWH is operating well as usual, Grace is acting as primary DWH production support.

Upgrade to Java 7 - testing in progress

Next two week planned activities and deliverables

Continue making bug fixes to ETL scripts and testing
Continue report development for highest priority reports
Publish SMS Cognos Package
Meet with Financial Services to finalize requirements

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

Budget requests for any new software or hardware

Training requests

Things learned, suggestions for improvements or anything else you think might be important

UCOP has contacted us regarding Phase 2 of the Spend Analytics project. We will need some additional resources to work on this project next year.

Browser not supported