/
2012-11-02_JonesValerie

2012-11-02_JonesValerie

Owned by vjones (Unlicensed)
Last updated: Nov 04, 2012

DWH Team Status Report for 11/02/2012

DWH KFS Decision Support JIRA Tasks

  1. Prior Two Week Activity

    1. Kuali Financial System
      1. Complete - Development of Cognos Framework for general ledger detail and balances
      2. Complete - Development of general ledger balances data models
      3. Complete - Scripts to load staging tables KRNS, GL, KR and CA tables
      4. On Hold - Development of jobs to load organization dimension - We encountered some problems with the organization table in KFS with missing hierarchies
      5. In Progress - Cognos load testing for capacity planning
      6. In progress - Specs for organization web service. This web service will flatten the KFS hierarchy, allowing ease of use for shadow and feeder system conversion.
      7. In progress - Specs for web service to retrieve all accounts by Org and all Org children. This will aide applications using KSR and KFS hierarchy for authorization.
      8. In progress - Specs for capital asset module reports
      9. In progress - ETL specs for GL Balances, currently working with Accounting to validate logic for calculating balances
      10. 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.
      11. In progress - Scripts to add KFS attributes to the Internal Directory (people database) for Administrative LDAP
      12. In progress - Scripts to load general ledger entries fact and document details dimension
      13. In progress - ETL scripts for AR, AP, KREW tables
    2. Payroll Certification
      1. 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.
    3. Data Warehouse Support
      1. DWH is operating well as usual, Grace is acting as primary DWH production support
    4. Non-DWH Support
      1. Grace was primary PPS support while Dave Carleton was out on vacation (10/16 - 10/28)
  2. Next two week planned activities and deliverables
    1. Finalize Cognos licensing needs
    2. ETL development for GL Balance fact table
    3. Capital Asset (CAM) data model
    4. Requirements finalization for Accounts Payable and PURAP modules
  3. Production support trends in terms of tickets either in JIRA or Footprints.  
    1. DWH Production Support 10%, New development 90% (except Grace)
  4. Staffing issues or personnel related matters
    1. None at this time
  5. Budget requests for any new software or hardware
    1. Cognos licensing - we will have results from testing this week
  6. Training requests
    1. None at this time
  7. Things learned, suggestions for improvements or anything else you think might be important
    1. None at this time