Versions Compared

Version Old Version 4 New Version Current
Changes made by

vjones

vjones

Saved on

Key

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

DWH Team Status Report for 12/17/2012

DWH KFS Decision Support JIRA Tasks - Status Chart

 Image Added

 

Image Removed

Prior Two Week Activity

Kuali Financial System

Completed
Complete -
  • Finalization and Review of GL, COA, and CAM models
Complete -
  • Data Model delivered by consultant for PURAP - currently being reviewed
Complete -
  • Org Structure Assignment. Determine reprots to for eliminated orgs approx 400
Complete -
  • Write ETL Staging jobs for PUR_* tables
Complete -
  • Write ETL scripts for staging AR, AP, KREW tables
Complete -
  • Develop Talend job to load Document Details dimension
Complete -
  • Develop Talend job to load Doc Type dimension
Complete -
  • Develop Talend job to load Project dimension
Complete -
  • Develop Talend script to load origin dimension
Complete -
  • 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.
Complete -
  • Scripts to add KFS attributes to the Internal Directory (people database) for Administrative LDAP - currently being tested
In
progress -
Progress
  • Develop Talend job to load Time dimension (adding fiscal periods to existing time dimension)
In progress -
  • ETL specs for GL balances (mostly complete, final meeting with Accounting tomorrow)
In progress -
  • Development of ETL to load GL balance table (waiting on final specs, mostly complete)
In progress - Development
  • Development of ETL Staging jobs for all UCI_* tables
In progress -
  • Scripts to add KFS attributes to legacy data warehouse (employee, payroll). Coding is complete - currently testing each time COA is re-loaded.
In progress -
  • Create a business process document to address old and new procedure for ad hoc querying within KFS and ad hoc querying within DWH
In progress -
  • Prioritize All current FS reports according to definite time lines
In progress -
  • Requirements specification for the KFS equivalent of the FS0100 part 2 (Ledger Detail Report)
In progress -
  • Report Specs for capital asset module reports
In progress -
  • Began documenting 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

Still waiting on Accounting to complete functional testing of mandated changes of NIH (DHHS) salary cap calculation. Federal code needs to be populated in SPA database. Accounting is working with Sponsored Projects on this issue.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.

 

Data Warehouse Support

DWH is operating well as usual, Grace is acting as primary DWH production support
Complete -
Completed Tasks:
  • Query for Chancellor's Christmas Cards
Complete -
  • Changes to custom query to retrieve employees for the Library
Complete -
  • Changes to custom query to retrieve employees for EROS system
Non-DWH Support
Grace is still assisting with some PPS related projects (WebPan changes)

 

Next two week planned activities and deliverables

  • Development of ETL specs for Capital Asset tables
  • Development of ETL
job
  • jobs for Capital Asset staging and dimension tables
Begin documenting
  • Development of Capital Asset framework in Cognos
  • Final review of the PURAP data model
  • Finalize reporting requirements for Accounts Payable and PURAP modules
  • Meet with campus shadow systems group to finalize ledger reporting needs
    • Update DWH database schemas based on recent database 'clean-up' work done in KFS

     

    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

    1. None at this time
    Katherine Gallardo is returning to Engineering full-time, but will still lead the campus work group for KFS Decision Support
    Kevin 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

    None at this timePut 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