Versions Compared

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 -
  • Complete -
  • Complete -
  • Complete -
  • In progress -
    • 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.
    In progress -
    • 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 specs for GL balances
    and chart of account dimensionsIn progress -
    • (mostly complete, final meeting with Accounting tomorrow)
    • Development of ETL to load GL balance table
    In progress - 
    • (waiting on final specs, mostly complete)
    • Development of ETL Staging jobs for all UCI_* tables
    In progress -
    • Scripts to add KFS attributes to legacy data warehouse (employee, payroll).
    Currently analyzing how many accounts are missing after each account conversion load by the KFS team.
  • In progress - Scripts to add KFS attributes to the Internal Directory (people database) for Administrative LDAP
  • In progress - ETL scripts for AR, AP, KREW tables
  • In progress -
    • 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
    • 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
    (awaiting final approval from stakeholders)
  • In progress - Prioritization of report development by business analysts
  • 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
    Non-DWH Support
    Grace is still assisting with some PPS related projects (WebPan changes)
    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 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