Versions Compared

Version Old Version 1 New Version Current
Changes made by

vjones (Unlicensed)

vjones (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DWH Team Status Report for 01/25/2013

DWH KFS Decision Support JIRA Tasks - Status Chart

Image RemovedImage Added

 

Prior Two Week ActivityPrior Two Week Activity

Kuali Financial System

Completed
  • Finalization and Review of PURAP models
  • Org Structure Assignment. Determine reprots to for eliminated orgs approx 400
  • Write ETL Staging jobs for PUR_* tables
  • Write ETL scripts for staging AR, AP, KREW tables
  • Develop Talend job to load Document Details dimension
  • Develop Talend job to load Doc Type dimension
  • Develop Talend job to load Project dimension
  • Develop Talend script to load origin dimension
  • Development for web service to retrieve all accounts by Org and all Org children. This will aide applications using KSR and KFS hierarchy for authorization.
  • Scripts to add KFS attributes to the Internal Directory (people database) for Administrative LDAP - currently being tested
In Progress
  • Develop Talend job to load Time dimension (adding fiscal periods to existing time dimension)
  • ETL model
  • ETL specs for GL balances (mostly complete, final meeting with Accounting tomorrowpending testing once data is available)
  • Development of ETL to load GL balance table (waiting on final specs, mostly complete)
  • Development of ETL Staging jobs for all UCI_* tables
  • Create a business process document to address old and new procedure for ad hoc querying within KFS and ad hoc querying within DWH
  • Started focus group and assigned work to each member
  • Development of ETL jobs for Capital Asset staging and dimension tables
  • Update DWH database schemas based on recent database 'clean-up' work done in KFS
  • Development of Capital Asset framework in Cognos
  • Configured Cognos for report archiving
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.Create a business process document to address old and new procedure for ad hoc querying within KFS and ad hoc querying within DWH
  • Code review of ETL jobs delivered from consultant
  • Prioritize All current FS reports according to definite time lines
  • Requirements specification for the KFS equivalent of the FS0100 part 2 (Ledger Detail Report)
  • Report Specs for capital asset module reports
  • Began documenting requirements ETL specs for Capital Asset tables
  • Requirements for Accounts Payable and PURAP modules
  • Set up logic to determine eliminated reports to orgs with new budget office org structure worksheet. Jason is currently working on this for Accounting.

 

Payroll Certification

Accounting just sent the results from the first round of testing this morning. Tammy will follow up on this and make any necessary modifications or bug fixes.

 

  • Develop feeder system validation report
  • Hardware setup for Cognos production servers

Payroll Certification

We ran into problems with the data needed for the DHHS enhancement. Accounting is in the process of determining an alternative solution which should be decided next week.

Data Warehouse Support

DWH is operating well as usual, Grace is acting as primary DWH production support
Completed Tasks:
  • Query for Chancellor's Christmas Cards
  • Changes to custom query to retrieve employees for the Library
  • Changes to custom query to retrieve employees for EROS system

 

.

Next two week planned activities and deliverables

  • Development Final approval of ETL specs for Capital Asset tables
  • Development of ETL jobs for Capital Asset staging and dimension tables
  • Development of Capital Asset framework in Cognos
  • Final review of the PURAP data model
  • Finalize reporting requirements for Accounts Payable and PURAP modules
  • Update DWH database schemas based on recent database 'clean-up' work done in KFSthe highest priority reports
  • Feeder system validation report
  • Report design guide document
  • ETL specifications for PURAP
  • ETL development for PURAP
  • Data Model for Authorization module (KIM)
  • Report development begins once specs are approved

 

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

Katherine Gallardo is returning to Engineering full-time, but will still lead the campus work group for KFS Decision SupportKevin Chung has joined the KFS Decision Support team as a business analyst/trainer. He will assist Jason Jensen with report development and requirements gathering.


 

Budget requests for any new software or hardware

Put in a request for DB solo licenses which was approved


 

Training requests

None at this time

 

 

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

None at this time