Copy of 2013_10_18_JonesValerie

DWH Team Status Report for 10/18/2013

Report	Equivalent Legacy Reports	Number of Targets	Status	Comments
Control Account Summary Report	FS0150 (Fund Summary)	4	In Development	Need to build a departmental version
Account Transaction Report	FS0100 (multiple), FS0213		Completed
Object Summary Report	FS0100, FS0200	2	Completed
Object Summary (AS LI IN)	FS0200B	2	Completed
Chart of Accounts Listings/Lookups	too many to list		Completed
Organizational Hierarchy	n/a		Completed
Object Code Transaction Report	FS0200 reports		Completed
Pivot Object Code Transaction Report	FS0105/106 (Source/Reference control Ledger reports)		Completed
Campus Report	FS0400 series (401-407)		In Development	Final touch-ups needed
Trend Analysis Report	new		In Development	Based off Paige's report in Excel
Designated Object Summary for Central Office	FS0218 (specific object code ranges only)		Incomplete	This will be completed by 11/1/2013
Object Trans Code Report	FS0212 reports (STIP)		Incomplete	Waiting on feeds with trans code objects
Letter of Credit Report	FS0209 series		Incomplete
Encumbrance Report	FS0109 series		Incomplete
Budget Adjustment Document Report	FS0BUD Reports, FS0FJ10		Incomplete	allows users to pick by document type and breaks on document number
Purchase Order Status			Incomplete
Organizational User Access Report			Incomplete
Asset Inventory List			Incomplete

Added drill-through capability to summary reports (3 way drilling - Fund, Object and Detail)
Scheduled ledger detail jobs to run daily
Created a departmental Cognos package with a subset of most commonly used attributes for adhoc query usage (Focus Group is reviewing)
Added KFS fields to DWH queries, Employee and Ledger Detail (student)
Added expand/collapse columns functionality to Campus Report, allows users to move from higher aggregates to low aggregates without drilling
Added show/hide columns to the Account Transaction Report
Migrated the first of the Cognos packages to development server in preparation for Cognos upgrade testing
Tested bursting functionality

Kuali Budget Reporting - Consultant started building Cognos framework package (rSmart)
Install new version of Cognos Framework Manager for Consultant
Ongoing meetings with Focus group
Development of Trend Analysis Report per Paige's request (Jason)
Plans for bursting Cognos reports
Migrating KFS DS channel to ZotPortal
Development of Report Templates
Replace report views with shortcuts, which will allow users the ability to save their prompt selections
Upgrade planning for Cognos version 10.2.1.1, all reports and packages will need to be migrated to development and tested on new version
Build data warehouse tables in production server for KFS, move Cognos reports to point to production database
Configuration of TalenD on UNIX server in new version 5.3
Consultant is also reviewing all developed KFS reports (rSmart)
Training materials are in development (Kevin)
Prototyping of prompt pages for Cognos reports (student)
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)
Development of scripts to migrate open receivables transactions from legacy DWH to KFS DWH (Anh)

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

Upgrade to Java 7 - testing in progress

Payroll Certification - Data extraction, pulling documentation together to provide to NSF/HHS for the HHS audit.

DWH Production Support 10%, New development 90% (except Grace)