KFS Decision Support Technical Team Meetings

10/30/2017

Attendees:  Pramod, Eufemia, Anh, Ursula, Valerie

Issues and bugs:

• KFSDW-1718 and  KFSDW-1719 are on hold until KFS Upgrade is complete.

Anh: Working on Informatica DBA related tasks.  All Award tables ready for Test.

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.  KFSDW-1290 is ready to deploy. KFS Upgrade Day One.

Eufemia: Working on KBM JIRA's: KFSDW-1508 is Ready for Test. Working on KFS Upgrade activities.

Ursula: Working on KFS Upgrade activities.

10/23/2017

Attendees:  Pramod, Eufemia, Anh, Ursula

Issues and bugs:

• KFSDW-1718 and  KFSDW-1719 are on hold until KFS Upgrade is complete.

Anh: Working on Informatica DBA related tasks.  KFSDW-1671 is waiting for Pramod and Kevin.  All other Award tables ready for Test.

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.  KFSDW-1290 is ready to deploy. KFS Upgrade Day One.

Eufemia: Working on KBM JIRA's: KFSDW-1508 finishing report based on completed ETL. Working on KFS Upgrade activities.

Ursula: Working on KFS Upgrade activities.

10/17/2017

Attendees:  Pramod, Eufemia, Anh

Issues and bugs:

• KFSDW-1663 Ursula has set this Ready for Test.
• KFSDW-1640 Eufemia waiting on customer (should be closed)

Anh: Working on Informatica DBA related tasks.  KFSDW-1671 is waiting for Kevin.  All other Award tables ready for Test.

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.  KFSDW-1290 is ready for testing. KFS Upgrade Day One.

Eufemia: Working on KBM JIRA's: KFSDW-1508 creating new package.  KFSDW-1519, KFSDW-1624 JIRA's are now ON HOLD until after KFS Upgrade.  Working on KFS Upgrade activities. Documentation on Wiki for SIS/UCPath.  Create JIRA's to replicate ETL in dss_kfs7 for KFSDW-1702 and KFSDW-1619.

KFS Upgrade considerations:

• KFS reports modified in PROD need to be replicated/updated in Hidden - KFS Upgrade folder
• Modifications to ETL in dss SOLAR (recently requested by Budget Office, for example) will need to be replicated in dss_kfs7 in LUNAR.
• Continue testing dss_kfs7, email Allison/Pramod with any issues on db end if any.

10/09/2017

Attendees:  Pramod, Ursula, Anh

Issues and bugs:

• KFSDW-1663 Ursula has set this Ready for Test.
• KFSDW-1640 Eufemia waiting on customer (should be closed)

Anh: Working on Informatica DBA related tasks.  KFSDW-1671 is waiting for Kevin.  All other Award tables ready for Test. Working on KFSDW-1713

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.  KFSDW-1290 is ready for testing. KFS Upgrade Day One.

Ursula:  Working on KFSDW-1709 and KFSDW-1705.  Added the new Award Dimension to the DSS-PI model, in testing.  Working on KFS Upgrade activities.

KFS Upgrade considerations:

• KFS reports modified in PROD need to be replicated/updated in Hidden - KFS Upgrade folder
• Modifications to ETL in dss SOLAR (recently requested by Budget Office, for example) will need to be replicated in dss_kfs7 in LUNAR.
• Continue testing dss_kfs7, email Allison/Pramod with any issues on db end if any.

10/02/2017

Attendees:  Pramod, Ursula, Anh

Issues and bugs:

• KFSDW-1663 Ursula has set this Ready for Test.
• KFSDW-1640 Eufemia waiting on customer (should be closed)

Anh: Working on Informatica DBA related tasks.  KFSDW-1671 is waiting for Kevin.  All other Award tables ready for Test. Working on KFSDW-1712 and KFSDW-1713

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.  KFSDW-1290 is ready for testing. KFS Upgrade Day One.

Ursula:  Working on KFSDW-1709 and KFSDW-1705.  Added the new Award Dimension to the DSS-PI model, in testing.  Working on KFS Upgrade activities.

KFS Upgrade considerations:

• KFS reports modified in PROD need to be replicated/updated in Hidden - KFS Upgrade folder
• Modifications to ETL in dss SOLAR (recently requested by Budget Office, for example) will need to be replicated in dss_kfs7 in LUNAR.
• Continue testing dss_kfs7, email Allison/Pramod with any issues on db end if any.

09/25/2017

Attendees:  Anh, Pramod, Ursula, Eufemia

Issues and bugs:

• KFSDW-1663 Ursula in progress with this report, will release immediately after UAT.
• KFSDW-1698/KFSDW-1697 On hold until after KFS Upgrade.
• KFSDW-1640 Eufemia waiting on customer (should be closed)

Anh: KFSDW-1646 to be deployed this Friday.  Working on Informatica DBA related tasks.  KFSDW-1671 are in progress.  All other Award tables ready for Test.

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries - waiting on Award data.  Updated KFS_D_RAFG dimension in LUNAR KFSDW-1290.

Ursula:  Working on KFSDW-1709 and KFSDW-1705.  Added the new Award Dimension to the DSS-PI model, in testing.  Working on KFS Upgrade activities.

Eufemia: KFSDW-1503, KFSDW-1702, KFSDW-1703 and KFSDW-990 are deployed. Working on KBM JIRA's: KFSDW-1508 creating new package.  KFSDW-1519, KFSDW-1624 JIRA's are now ON HOLD until after KFS Upgrade.  Working on KFS Upgrade activities. Documentation on Wiki for SIS/UCPath.  Create JIRA's to replicate ETL in dss_kfs7 for KFSDW-1702 and KFSDW-1619.

KFS Upgrade considerations:

• KFS reports modified in PROD need to be replicated/updated in Hidden - KFS Upgrade folder
• Modifications to ETL in dss SOLAR (recently requested by Budget Office, for example) will need to be replicated dss_kfs7 in LUNAR.
• Continue testing dss_kfs7, email Allison/Pramod with any issues on db end if any.

09/18/2017

Attendees:  Anh, Pramod, Ursula, Eufemia

Issues and bugs:

• KFSDW-1698 Ursula to follow up with Kevin this week (related to KFSDW-1632).
• KFSDW-1640 Eufemia waiting on customer

Anh: KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks.  KFSDW-1656 and KFSDW-1671 are in progress.  All other Award tables ready for Test.

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries - waiting on Award data.  Updated KFS_D_RAFG dimension in LUNAR KFSDW-1290.

Ursula:  Working on KFSDW-1709 and KFSDW-1705.  Added the new Award Dimension to the DSS-PI model, in testing.  Working on KFS Upgrade activities.

Eufemia: Testing KFSDW-1290. KFSDW-1503, KFSDW-1702, KFSDW-1703 and KFSDW-990 are ready for Deploy. Working on KBM JIRA's: KFSDW-1508, KFSDW-1519, KFSDW-1624.  Working on KFS Upgrade activities. Documentation on Wiki for SIS/UCPath. Waiting for KFSDW-1691 to be deployed.

KFS Upgrade considerations:

• KFS reports modified in PROD need to be replicated/updated in Hidden - KFS Upgrade folder
• Modifications to ETL in dss SOLAR (recently requested by Budget Office, for example) will need to be replicated dss_kfs7 in LUNAR.
• Continue testing dss_kfs7, email Allison/Pramod with any issues on db end if any.

09/11/2017

Attendees:  Anh, Pramod, Ursula, Eufemia

Issues and bugs:

• KFSDW-1707 Anh starting work on this
• KFSDW-1684 Ursula working on this
• KFSDW-1698 Ursula to follow up with Kevin this week (related to KFSDW-1632).
• KFSDW-1690 to be deployed this week.

Anh: KFSDW-1496, KFSDW-1669, KFSDW-1670, KFSDW-1672 are in progress to apply Pramod's code review. KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks.  KFSDW-1656 and KFSDW-1671 are in progress.  KFSDW-1702 is ready for test.

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.  Updated KFS_D_RAFG dimension in LUNAR KFSDW-1290.

Ursula:  KFSDW-1679 is ready to deploy.  Added the new Award Dimension to the DSS-PI model, in testing.  Working on KFS Upgrade activities.

Eufemia: Testing KFSDW-1702, KFSDW-1290.  KFSDW-1503, KFSDW-1703 and KFSDW-990 are ready for test, just waiting to hear if Maria wants to repoint reports in PROD before deploying package (KFSDW-990).  Working on KBM JIRA's: KFSDW-1508, KFSDW-1519, KFSDW-1624.  Working on KFS Upgrade activities. Documentation on Wiki for SIS/UCPath. 

• waiting for data for KFSDW-1691

KFS Upgrade considerations:

• KFS reports modified in PROD need to be replicated/updated in Hidden - KFS Upgrade folder
• Modifications to ETL in dss SOLAR (recently requested by Budget Office, for example) will need to be replicated dss_kfs7 in LUNAR.
• Continue testing dss_kfs7, email Allison/Pramod with any issues on db end if any.

08/28/2017

Attendees:  Anh, Pramod, Ursula

Issues and bugs:

• KFSDW-1684 Ursula waiting for customer to respond.
• KFSDW-1698 Ursula to follow up with Kevin (related to KFSDW-1632).
• KFSDW-1690 Pramod to follow up with Kevin

Anh: KFSDW-1496, KFSDW-1669, KFSDW-1670, KFSDW-1672 are Ready to test, KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks. Working with Kevin on KFSDW-1656 and associated sub task: KFSDW-1671.  Kevin / Maria to provide updates on KFSDW-1702.

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.

Ursula:  Working on KFSDW-1679. Added the new Award Dimension to the DSS-PI model, in testing.  Working on KFS Upgrade activities.

Eufemia: Need to hear back on prioritizing KFSDW-1702.  Waiting to hear back on package about KFSDW-1503 and KFSDW-990.  Working on KBM JIRA's: KFSDW-1504, KFSDW-1624.  Working on KFS Upgrade activities. Documentation on Wiki for SIS

08/21/2017

Attendees:  Tammy, Anh, Eufemia, Pramod, Ursula

Issues and bugs:

• KFSDW-1684 Ursula waiting for customer to respond.
• KFSDW-1698 Ursula to follow up with Kevin (related to KFSDW-1632).
• KFSDW-1690 Pramod to follow up with Kevin

Eufemia:  Working on KBM JIRA's: KFSDW-1503, KFSDW-1702 - Getting issue details... STATUS , KFSDW-1703 - Getting issue details... STATUS , KFSDW-1624. Prioritizing KFSDW-990 for the Budget package.  Working on KFS Upgrade activities.  Test KFSDW-1691 to add columns to CSF tracker tables.  Adding new Position Dimension to Budget Package.

Anh: KFSDW-1496, KFSDW-1669, KFSDW-1672 is Ready to test, KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks. Working with Kevin on KFSDW-1656 and associated sub tasks:  KFSDW-1670, KFSDW-1671.  Eufemia to go over the KFSDW-1702 with Anh.

Tammy: helping Allison and Anthony with KFS Upgrade ETL work. (May need to ask team to clear out session cache on LUNAR, if/when jobs fails.)

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.

Ursula:  Added the new Award Dimension to the DSS-PI model, in testing.  Working on KFS Upgrade activities.

08/14/2017

Attendees:  Tammy, Anh, Eufemia, Pramod

Issues and bugs:

• KFSDW-1684 Ursula waiting for customer to respond.
• KFSDW-1698 assign to Ursula (related to KFSDW-1632)
• KFSDW-1690 Pramod to start work on

Eufemia:  KFSDW-1699 - Getting issue details... STATUS , KFSDW-1696 - Getting issue details... STATUS , KFSDW-1695 - Getting issue details... STATUS were DEPLOYED.  Working on KFSDW-1503, KFSDW-1703 - Getting issue details... STATUS , KFSDW-1624. Working on KFS Upgrade activities.  Test KFSDW-1691 to add columns to CSF tracker tables.  Adding new Position Dimension to Budget Package.

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks. Working on KFSDW-1656 and associated sub tasks: KFSDW-1669,  KFSDW-1670, KFSDW-1671, KFSDW-1672.

      Waiting for:

• Pramod to fix column type on KFSDW-1656. 
• Kevin to give remaining requirements on KFSDW-1669, KFSDW-1670, and KFSDW-1671
• Pramod to set the identity of a table to 'ON' for KFSDW-1672.

Tammy: helping Allison and Anthony with KFS Upgrade ETL work.

Pramod: Working on KFS Upgrade activities.  Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.

08/07/2017

Attendees:  Tammy, Anh, Eufemia, Ursula

Issues and bugs:

• KFSDW-1695 Eufemia working on making Recharge report run faster.
• KFSDW-1684 Ursula waiting for customer to respond.

Eufemia:  KFSDW-696 - Getting issue details... STATUS , KFSDW-1693 - Getting issue details... STATUS , KFSDW-1692 - Getting issue details... STATUS were deployed.  KFSDW-1094 is READY FOR TEST. Working on KFSDW-1503, KFSDW-1703 - Getting issue details... STATUS , KFSDW-1624. Working on KFS Upgrade activities.  Test KFSDW-1691 - Getting issue details... STATUS to add columns to CSF tracker tables. 

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks. Working on KFSDW-1656 and associated sub tasks: KFSDW-1669,  KFSDW-1670, KFSDW-1671, KFSDW-1672.

Ursula: KFSDW-1679, KFSDW-1563 READY FOR TEST.  Working on KFS Upgrade activities. 

Tammy: helping Allison and Anthony with KFS Upgrade ETL work.

07/31/2017

Attendees:  Tammy, Anh, Eufemia, Ursula

Issues and bugs:

• KFSDW-1684 Ursula waiting for customer to respond.
• KFSDW-1640  KFSDW-1640 - Getting issue details... STATUS Eufemia is waiting on budget office

Eufemia:  KFSDW-696 - Getting issue details... STATUS , KFSDW-1674 - Getting issue details... STATUS ,  KFSDW-1504 - Getting issue details... STATUS were deployed.  KFSDW-1094 is READY FOR TEST. Working on KFSDW-1503, KFSDW-1624. Working on KFS Upgrade activities.  Create new JIRA for Valerie/Bryce to add columns to CSF_TRACKER, CSF_TRACKER_SNAPSHOT and the CSFTRCKR_OVRD tables (this is in preparation for the new Position report).  Send email to Tammy, Allison and Anthony with list of impacted VIEWS.  Create a parent JIRA for all ETL changes to VIEWs and create child JIRAs as we complete our analysis. 

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks. Working on KFSDW-1656 and associated sub tasks: KFSDW-1669,  KFSDW-1670, KFSDW-1671, KFSDW-1672.

Ursula: KFSDW-1679, KFSDW-1563 READY FOR TEST.  Working on KFS Upgrade activities. 

Tammy: helping Allison and Anthony with KFS Upgrade ETL work.

07/17/2017

Attendees:  Ursula, Anh, Eufemia

Issues and bugs:

• KFSDW-1640 Eufemia is waiting on budget office
• KFSDW-1681 Ursula has it READY FOR TEST.
• KFSDW-1682 Ursula is working on 

Ursula: PREQ, Disbursement, TEM, PO, and Disbursement Voucher are in UAT, Credit Memo. Working on KFS Upgrade activities.

Eufemia: Maria to test KFSDW-1604 over the next two months to test position history on Staffing List Report.  KFSDW-696 - Getting issue details... STATUS , KFSDW-1094 is READY FOR TEST. Working on KFSDW-1503, KFSDW-1674 - Getting issue details... STATUS ,  KFSDW-1504 - Getting issue details... STATUS , KFSDW-1624 - Getting issue details... STATUS . Working on KFS Upgrade activities.

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks. Working on KFSDW-1656 and associated sub tasks: KFSDW-1669,  KFSDW-1670, KFSDW-1671, KFSDW-1672.

07/10/2017

Attendees:  Ursula, Pramod, Anh, Eufemia

Issues and bugs:

• KFSDW-1640 Eufemia waiting on budget office

Ursula: PREQ, Disbursement, TEM, PO, and Disbursement Voucher are in UAT, working on Credit Memo. Working on KFS Upgrade activities.

Pramod:  Working on KFS Upgrade activities. KFSDW-1630 is Ready for test.  KFSDW-1404 is Ready for deploy. Add Award_SID to all PURAP accounting fact tables and GL Balance and Ledger entries.

Eufemia: Maria to test KFSDW-1604 over the next two months to test position history on Staffing List Report.  KFSDW-696 is being shown to other departments for further feedback. Working on KFSDW-1094, KFSDW-1503,KFSDW-1504, KFSDW-1624, KFSDW-1674. Working on KFS Upgrade activities.

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks. Working on KFSDW-1656 and associated sub tasks.

06/26/2017

Attendees:  Ursula, Pramod, Anh, Eufemia

Issues and bugs:

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1640 Eufemia waiting on budget office

Ursula: PREQ, Disbursement, TEM, PO, and Disbursement Voucher are in UAT, working on Credit Memo. KFSDW-1663 and is Ready for test.

Pramod:  Working on KFS Upgrade activities. KFSDW-1630 is Ready for test.  KFSDW-1404 is Ready for test.

Eufemia: Maria to test KFSDW-1604 over the next two months to test position history on Staffing List Report.  KFSDW-696 is being shown to other departments for further feedback. Working on KFSDW-1094, KFSDW-1503,KFSDW-1504, KFSDW-1624. Analyzing impact of KFS Upgrade.

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 and KFSDW-1646 are Ready to deploy.  Working on Informatica DBA related tasks. Working on KFSDW-1656

06/19/2017

Attendees:  Ursula, Pramod, Anh, (Eufemia)

Issues and bugs:

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1640 Eufemia waiting on budget office

Ursula: PREQ, Disbursement, TEM and PO are in UAT, working on Disbursement voucher. KFSDW-1663 is Ready for test.

Pramod:  Working on KFS Upgrade activities. KFSDW-1630 is Ready for test.  KFSDW-1404 is Ready for test.

Eufemia: Maria to test KFSDW-1604 over the next two months to test position history on Staffing List Report.  KFSDW-696 is being shown to other departments for further feedback. Working on KFSDW-1094, KFSDW-1503,KFSDW-1504, KFSDW-1624.

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 is ready to deploy. KFSDW-1646 is Ready to deploy.  Working on Informatica DBA related tasks. Working on KFSDW-1656

06/12/2017

Attendees:  Eufemia, Ursula, Pramod, Anh

Issues and bugs:

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1640 Eufemia waiting on budget office

Ursula: PREQ, Disbursement, TEM and PO are in UAT, working on Disbursement voucher. Working on KFSDW-1663.

Pramod:  Working on KFS Upgrade activities. KFSDW-1630 is Ready for test.  KFSDW-1404 is Ready for test.

Eufemia: Maria to test KFSDW-1604 over the next two months to test position history on Staffing List Report.  KFSDW-696 is being shown to other departments for further feedback. Working on KFSDW-1094, KFSDW-1503,KFSDW-1504, KFSDW-1624.

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 is ready to deploy. KFSDW-1646 is Ready to deploy.  Working on Informatica DBA related tasks. Researching nightly OLTP load failure

06/05/2017

Attendees:  Eufemia, Ursula, Pramod

Issues and bugs:

• KFSDW-1631 Ready for deploy

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1640 Eufemia waiting on budget office
• KFSDW-1643 Closed

Ursula: PREQ, Disbursement, TEM and PO are in UAT, working on Credit memo. KFSDW-1399 ready for test.

Pramod:  Working on KFS Upgrade activities. KFSDW-1630 is Ready for test.  KFSDW-1404 is Ready for test, .

Eufemia: Maria to test KFSDW-1604 over the next two months to test position history on Staffing List Report.  KFSDW-696 is being shown to other departments for further feedback. Working on KFSDW-1094, KFSDW-1503,KFSDW-1504, KFSDW-1624.

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 is ready to deploy. KFSDW-1646 is ready for test. Working on Informatica DBA related tasks.

05/22/2017

Attendees:  Ursula, Pramod, Anh

Issues and bugs:

• KFSDW-1644 Ready to deploy. 

• KFSDW-1631 Ursula to check report dependencies now that JIRA has passed UAT.

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1640 Matt will be unable to complete this report.  Eufemia to contact Budget Office to present options and then proceed from there.
• KFSDW-1643 Ursula waiting for customer. 

Ursula: KFSDW-1399 ready for test. Continue working on PURAP model (KFSDW-1605), includes new requirements for Disbursement model (KFSDW-1422).

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 is ready to deploy. Working on KFSDW-1646.  Working on Informatica DBA related tasks.

Pramod:  Working on KFS Upgrade activities. KFSDW-1630 is Ready for test. Working on KFSDW-1404.

05/15/2017

Attendees:  Ursula, Eufemia, Anh

Issues and bugs:

• KFSDW-1644 Eufemia to contact Victor this week to test. 

• KFSDW-1631 Ursula to check report dependencies now that JIRA has passed UAT.

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1640 Matt will be unable to complete this report.  Eufemia to contact Budget Office to present options and then proceed from there.
• KFSDW-1643 Ursula waiting for customer. 

Ursula: KFSDW-1399 ready for test. Continue working on PURAP model, includes new requirements for Disbursement model (KFSDW-1422).

Eufemia: Maria to test KFSDW-1604 over the next two months to test position history on Staffing List Report.  She is also asking to test the Budget Ledger Detail with the new position dimension (ETL change may be needed for this).  KFSDW-696 is being shown to other departments for further feedback.

Anh: KFSDW-1496 is Ready to test, KFSDW-1638 is ready for test for LD_LDGR_ENTR_PI_T. Working on KFSDW-1646.  Working on Informatica DBA related tasks.

05/08/2017

Attendees:  Ursula, Pramod, Anh, Eufemia

Issues and bugs:

• KFSDW-1631 Ready for deploy

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1640 Matt working on this one

Ursula: KFSDW-1399 ready for test. Continue working on PURAP model. and DSS_PI model.

Pramod:  Working on KFS Upgrade activities. KFSDW-1630 is Ready for test. Working on KFSDW-1404.

Eufemia: Waiting to put KFSDW-1604 in UAT.  Continue working with Maria on KBM reports.  KFSDW-696 is under technical testing.  Working on KFSDW-1084, KFSDW-1519, KFSDW-1518.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Anh: KFSDW-1496 is Ready to test, Working on KFSDW-1638. Working on Informatica DBA related tasks.

05/01/2017

Attendees:  Ursula, Eufemia, Pramod, Anh

Issues and bugs:

• KFSDW-1631 Ready for test

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1640 Matt working on this one

Ursula: KFSDW-1399 ready for test. Continue working on PURAP model. and DSS_PI model.

Pramod:  Working on KFS Upgrade activities. KFSDW-1630 is Ready for test. Working on KFSDW-1404.

Eufemia: Continue working with Maria on KBM reports.  KFSDW-696 is under technical testing. KFSDW-1094, KFSDW-1383 is ready for test.  Working on KFSDW-1084, KFSDW-1519, KFSDW-1518.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Anh: KFSDW-1496is Ready to test, Working on KFSDW-1638

04/24/2017

Attendees:  Ursula, Eufemia, Pramod

Issues and bugs:

• KFSDW-1631 Ready for test

• KFSDW-1635 Matt Levin working on this, waiting for customer

• KFSDW-1639 Ursula working on this

Ursula: KFSDW-1399 ready for test. Continue working on PURAP model. 

Pramod:  Credit memo ETL is deployed. Working on KFS Upgrade activities. KFSDW-1630 is Ready for test. Working on KFSDW-1404.

Eufemia: Testing KFSDW-1604. Continue working with Maria on KBM reports.   KFSDW-696 is under technical testing. KFSDW-1094, KFSDW-1383 is ready for test.  Working on KFSDW-1084, KFSDW-1519, KFSDW-1518.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

04/17/2017

Attendees:  Ursula, Pramod, Anh

Issues and bugs:

• KFSDW-1631 Ready for test

• KFSDW-1635 Matt Levin working on this, waiting for customer

Ursula: KFSDW-1399 ready for test. Working on KFSDW-1399 Continue working on PURAP model. 

Anh: Working on KFSDW-1496. Deployed to production: KFSDW-1617 and KFSDW-1634

Pramod:  Credit memo scheduled to deploy. Working on KFS Upgrade activities. Working on KFSDW-1630

04/10/2017

Attendees:  Ursula, Eufemia, Pramod, Anh

Issues and bugs:

• KFSDW-1631 Ursula working on.  Kevin on vacation. Ursula to meet with Tammy.

• KFSDW-1635 Matt Levin working on this

Ursula: KFSDW-1399 ready for test.  Continue working on PURAP model. 

Eufemia:  Testing KFSDW-1604. Continue working with Maria on KBM reports.  KFSDW-696 is under technical testing. KFSDW-1094, KFSDW-1383 is ready for test.  Working on KFSDW-1084, KFSDW-1519, KFSDW-1518. Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Anh: Working on KFSDW-1617 , KFSDW-1496,  and  KFSDW-1634. KFS, month-end related activities.

Pramod:  Working on testing / coding PURAP Credit memo, and KFS Upgrade activities. Working on KFSDW-1630

04/03/2017

Attendees:  Ursula, Eufemia, Pramod, Anh

Issues and bugs:

• KFSDW-1633: deployed by Pramod

• KFSDW-1631 Ursula working on.  Kevin on vacation. We will talk to Valerie about how the PRCRMNT Acct ITm table joing to the KFS_F_LEDGER_ENTRIES, etc.

• KFSDW-1635 Matt Levin working on

Ursula: KFSDW-1399 ready for test.  KFSDW-1602 deployed.  Continue working on PURAP model. 

Eufemia:  Testing KFSDW-1604. Continue working with Maria on KBM reports.  KFSDW-696 is under technical testing. KFSDW-1094, KFSDW-1383 is ready for test.  Working on KFSDW-1084, KFSDW-1519, KFSDW-1518.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Anh: Working on "https://services.adcom.uci.edu/jira/browse/KFSDW-1429" KFSDW-1617 , "https://services.adcom.uci.edu/jira/browse/KFSDW-1429" KFSDW-1496, and "https://uci.atlassian.net/browse/KFSDW-1634" KFSDW-1634, should be available for test today in DEV. KFS, month-end related activities.

Pramod:  Working on testing / coding PURAP Credit memo, and KFS Upgrade activities. Working on KFSDW-1630

03/27/2017

Attendees:  Ursula, Eufemia, Pramod, Anh

Issues and bugs:

• KFSDW-1635: Matt reviewing this one
• KFSDW-1631: Ursula working on this one

Ursula: Continue working on KFSDW-1507, KFSDW-1399 (Year-end) ;  READY for TEST: KFSDW-1429, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAP packages (PREQ).

Eufemia:  Testing KFSDW-1604. Continue working with Maria on KBM reports.  KFSDW-1519 are READY FOR TEST. Working on  KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540, KFSDW-1007, KFSDW-1094, KFSDW-696, KFSDW-1084.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Anh: Working on KFSDW-1617 , KFSDW-1496, and KFSDW-1634. KFS related activities.

Pramod:  Working on testing / coding PURAP Credit memo, and KFS Upgrade activities. Working on KFSDW-1630

03/20/2017

Attendees:  Ursula, Eufemia, Pramod, Anh

Issues and bugs:

• KFSDW-1627: Eufemia reviewing this one
• KFSDW-1631: Ursula working on this one

Tasks:

Ursula: Continue working on KFSDW-1507, KFSDW-1602, KFSDW-1399 (Year-end) ;  READY for TEST: KFSDW-1429, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAP packages (PREQ).

Eufemia:  Testing KFSDW-1604. Continue working with Maria on KBM reports.  KFSDW-1519 are READY FOR TEST. Working on  KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540, KFSDW-1007, KFSDW-1094, KFSDW-696, KFSDW-1084.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Pramod:  Working on testing / coding PURAP Credit memo, and Requisition ETL and KFS Upgrade activities. Working on KFSDW-1630

Anh: Working on KFSDW-1617 and  KFSDW-1496

03/13/2017

Attendees:  Ursula, Eufemia, Pramod, Matt, Anh

Issues and bugs:

None

Tasks:

Ursula: Continue working on KFSDW-1507, KFSDW-1602;  READY for TEST: KFSDW-1429, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAP packages (PREQ).

Eufemia:  Testing KFSDW-1604. Continue working with Maria on KBM reports.  KFSDW-1519 are READY FOR TEST. Working on  KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540, KFSDW-1007, KFSDW-1094, KFSDW-696, KFSDW-1084.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Pramod:  Working on testing / coding PURAP Credit memo, and Requisition ETL and KFS Upgrade activities.

Matt: Working on upgrade to Fund summary report.

Anh: Working on KFSDW-1625 and KFSDW-1626 and KFSDW-1617 and  KFSDW-1496

03/06/2017

Attendees:  Ursula, Eufemia, Pramod

Issues and bugs:

KFSDW-1555 ready for deploy

Tasks:

Ursula: Continue working on KFSDW-1507, KFSDW-1602;  READY for TEST: KFSDW-1429, KFSDW-1384, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAP packages (PREQ).

Eufemia:  Testing KFSDW-1604. Continue working with Maria on KBM reports.  KFSDW-1519 - Getting issue details... STATUS are READY FOR TEST. Working on  KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540, KFSDW-1007, KFSDW-1094, KFSDW-696, KFSDW-1084.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Pramod:  Working on testing / coding PURAP Credit memo, and Requisition ETL and KFS Upgrade activities.

02/27/2017

Attendees:  Ursula, Eufemia, Matt, Anh, Pramod

Issues and bugs:

KFSDW-1555 ready for test

KFSDW-1593 Matt is reviewing

Tasks:

Ursula: Continue working on KFSDW-1507, KFSDW-1602;  READY for TEST: KFSDW-1429, KFSDW-1384, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAP packages (PO_ITEM & PO_ITEM_ACCTG & Disbursement & TEM).

Eufemia:  Testing KFSDW-1604. Continue working with Maria on KBM reports.  KFSDW-1519 - Getting issue details... STATUS are READY FOR TEST. Working on  KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540, KFSDW-1007, KFSDW-1094, KFSDW-696, KFSDW-1084.  Also working with Pramod to get requirements for KBM Data Mart from Maria. Working on list of ODS tables for KFS Upgrade.

Anh: Waiting on Pramod's confirmation on JIRA:KFSDW-1496. KFSDW-1496 is ready to Test.

Pramod:  Working on testing / coding PURAP DV ETL and KFS Upgrade activities. 

02/06/2017

Attendees:  Ursula, Eufemia, Anh

Issues and bugs:

KFSDW-914 is READY FOR DEPLOY.

KFSDW-1564, KFSDW-1541 and KFSDW-1555 ready for test.

Tasks:

Ursula: Continue working on KFSDW-1507;  READY for TEST: KFSDW-1429, KFSDW-1384, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG & Disbursement & TEM).

Eufemia:  Changing SQL to StaffingbyAcctorOrg_T_NEW ETL to include new Position Dimension, will create new JIRA.  Continue working with Maria on KBM reports.  KFSDW-1519 - Getting issue details... STATUS are READY FOR TEST. Working on  KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540, KFSDW-1007, KFSDW-1094, KFSDW-696, KFSDW-1084.  Also working with Pramod to get requirements for KBM Data Mart from Maria.

Anh: Working on JIRA:KFSDW-1496

01/30/2017

Attendees:  Ursula, Pramod, Eufemia, Matt, Anh

Issues and bugs:

KFSDW-914, KFSDW-1564, KFSDW-1541 and KFSDW-1555 ready for test.

Tasks:

Ursula: Continue working on KFSDW-1507;  READY for TEST: KFSDW-1429, KFSDW-1384, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG & Disbursement).

Pramod:  Working on testing / coding PURAP ETL and KFS Upgrade activities. Fixing NULL dimensional attributes for PURAP.

Eufemia: Continue working with Maria on KBM reports. KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS are READY FOR TEST. Working on  KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540, KFSDW-1007, KFSDW-1094, KFSDW-696.

Change pictures to links.

Matt: Non-KFS related.

Anh: Working on JIRA:KFSDW-1496

01/23/2017

Attendees:  Ursula, Pramod, Eufemia, Matt, Anh

Issues and bugs:

Eufemia working on KFSDW-914 from Kevin. Ursula working on KFSDW-1555 and KFSDW-1564.

Tasks:

Ursula: Continue working on KFSDW-1507.  READY for TEST, KFSDW-1429, KFSDW-1384, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG & Disbursement).

Pramod:  Working on testing / coding PURAP ETL and KFS Upgrade activities. Researching NULL dimensional attributes for PURAP.

Eufemia: Continue working with Maria on KBM reports. KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS are READY FOR TEST. Working on  KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540, KFSDW-1007, KFSDW-1094.

Matt: Non-KFS related.

Anh: Working on SBS, Outbound post-migration. Working on incident 139850.

01/09/2017

Attendees:  Ursula, Pramod, Eufemia, Matt, Anh, Tammy

Issues and bugs:

Ursula working on KFSDW-1560.  Eufemia working on KFSDW-914 from Kevin.

Tasks:

Ursula: Continue working on KFSDW-1507.  READY for TEST, KFSDW-1429, KFSDW-1384, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG & Disbursement).

Pramod:  Working on testing PURAP ETL and KFS Upgrade activities.

Anh: Working on SBS, and Outbound month-end processing. JIRAs to migrate these jobs to production.

Eufemia:  Continue working with Maria on KBM reports , KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS , are READY FOR TEST.   KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540 continue working on. 

Matt: New package for Award balance overview report (JIRA 1553)

12/19/2016

Attendees:  Ursula, Pramod, Tammy

Issues and bugs:

Ursula working on KFSDW-1555.  Waiting to hear back on KFSDW-914 from Kevin (and whether KFSDW-1323 is needed still).

Tasks:

Ursula: Continue working on KFSDW-1507.  READY for TEST, KFSDW-1429, KFSDW-1384, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG & Disbursement).

Tammy: Tammy waiting for more updated spec on KFSDW-944.

Pramod:  Working on TEM bridge table, testing PURAP ETL and KFS Upgrade activities.

12/12/2016

Attendees:  Eufemia, Ursula, Pramod, Tammy

Issues and bugs:

Ursula working on KFSDW-1555.  Waiting to hear back on KFSDW-914 from Kevin (and whether KFSDW-1323 is needed still).

Tasks:

Ursula:  Continue working on KFSDW-1507.  READY for TEST, KFSDW-1429, KFSDW-1384, KFSDW-1546. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG).

Eufemia:  Continue working with Maria on KBM reports , KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS , are READY FOR TEST.   KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540 continue working on. 

Tammy: Tammy waiting for more updated spec on KFSDW-944.

Pramod:  Working on TEM bridge table and KFS Upgrade activities.

12/05/2016

Attendees:  Eufemia, Matt, Ursula, Pramod, Tammy, Anh

Issues and bugs:

Pramod to start work on KFSDW-1545.

Tasks:

Ursula:  Continue working on KFSDW-1507.  READY for TEST, KFSDW-1429, KFSDW-1384. Continue to work on expediting JIRAs (KFSDW-1546) Has question for Susan. Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG).

Eufemia:  Continue working with Maria on KBM reports , KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS , are READY FOR TEST.   KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS , KFSDW-1540 continue working on.  Waiting to hear back on KFSDW-914 from Kevin (and whether KFSDW-1323 is needed still).

Matt: Currently working on KFSDW-906.

Tammy: Tammy waiting for more updated spec on KFSDW-944.

Anh:  Analytics ETL undergoing UAT.  Working on KFS related tasks. Currently working on KFSDW-1496.

Pramod:  Working on KFS Upgrade activities. 

11/28/2016

Attendees:  Eufemia, Matt, Ursula, Anh

Issues and bugs:

Usrula to confirm with Austin that progress has started with KFSDW-1545.

Tasks:

Anh:  Analytics ETL undergoing UAT.  Working on KFS related tasks.

Ursula:  Working on KFSDW-1429, KFSDW-1507.  READY for TEST, KFSDW-1384. Continue to work on expediting JIRAs (KFSDW-1546). Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG).

Eufemia:  Continue working with Maria on KBM reports , KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS  are READY FOR TEST.   KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS  continue working on.  Waiting to hear back on KFSDW-914 from Kevin.

Matt: Currently working on KFSDW-906.

11/21/2016

Attendees:  Eufemia, Matt, Ursula, Anh, Tammy

Issues and bugs:

Eufemia finishing up KFSDW-914.

Ursula waiting for ETL team to fix/clean up KFSDW-1545.

Tasks:

Anh:  Analytics ETL undergoing UAT.  Migrating KFSDW-1537 to Production.  Working on KFS related tasks.

Tammy: Tammy waiting for more updated spec on KFSDW-944.

Ursula:  Working on KFSDW-1429.  READY for TEST, KFSDW-1384. Continue to work on expediting JIRAs. Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG).

Eufemia:  Continue working with Maria on KBM reports , KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS  are READY FOR TEST.   KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS  continue working on. 

Matt: Currently working on KFSDW-906.

11/13/2016

Attendees:  Eufemia, Matt, Ursula, Anh

Issues and bugs:

Ursula working on KFSDW-1544.  Rest of bugs either on hold or ready for test.

Tasks:

Anh:  Analytics ETL undergoing UAT. 

Ursula:  Working on KFSDW-1429.  READY for TEST, KFSDW-1384. Continue to work on expediting JIRAs. Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG).

Eufemia:  Continue working with Maria on KBM reports , KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS  are READY FOR TEST.   KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS  continue working on.  Continue working on KFSDW-914.

Matt: non-KFS items.

11/07/2016

Attendees:  Eufemia, Tammy, Matt, Ursula, Anh

Issues and bugs:

Non urgent JIRA waiting for Pramod: KFSDW-1516 was changed to improvement.  Will be worked on when Pramod gets back.

Ursula will be working on or assigning out KFSDW-1541, KFSDW-1542.

Tasks:

Tammy: Tammy waiting for more updated spec on KFSDW-944.

Anh:  Month end outbound and SBS tasks.  Analytics ETL undergoing UAT.  Work on KFS tasks.

Matt: non-KFS tasks

Ursula:  soon to be READY for TEST, KFSDW-1384. Continue to work on expediting JIRAs. Continue to work on building PURAPP packages (PO_ITEM & PO_ITEM_ACCTG).

Eufemia:  Continue working with Maria on KBM reports , KFSDW-1517 - Getting issue details... STATUS ,  KFSDW-1519 - Getting issue details... STATUS  are READY FOR TEST.   KFSDW-1518 - Getting issue details... STATUS , KFSDW-1503 - Getting issue details... STATUS  continue working on.  Will look into outputting balances for KFSDW-1007 . 

10/31/2016

Attendees:  Eufemia, Anh, Tammy

Issues and bugs:

Non urgent JIRA waiting for Pramod: KFSDW-1516

Tasks:

Tammy: Tammy waiting for more updated spec on KFSDW-944

Anh:  Analytics ETL undergoing UAT.  Work on KFS tasks.

Eufemia:  Continue working with Maria on KBM reports KFSDW-1503 - Getting issue details... STATUS , KFSDW-1517 - Getting issue details... STATUS , KFSDW-1518 - Getting issue details... STATUS , KFSDW-1519 - Getting issue details... STATUS .   Will look into outputting balances for KFSDW-1007 . 

10/24/2016

Attendees:  Eufemia, Matt, Anh, Tammy, Ursula

Issues and bugs:

KFSDW-1533: Eufemia will work with Maria on this.

Tammy waiting for more updated spec on KFSDW-944

Tasks:

Tammy: non-KFS tasks

Matt:  non-KFS tasks

Eufemia:  Continue working with Maria on KBM reports KFSDW-1503 - Getting issue details... STATUS .   Will look into outputting balances for KFSDW-1007 .

Anh:  Analytics ETL undergoing UAT.  Work on KFS tasks.

Ursula:  PO_ITEM, PO_ITM_ACCT, Disbursement_Item, and Disbursement_Item_Accounting Packages are in UAT.  In iterative development.

10/17/2016

Attendees:  Eufemia, Matt, Anh

Issues and bugs:

KFSDW-914: Eufemia continue to work on this.

KFSDW-1513:  Matt is looking into this JIRA.

Anh is looking into KFSDW-1530 JIRA. 

Tasks:

Matt:  non-KFS tasks

Eufemia: Maria signed off on MEDCOM changes in ETL.  Continue working with Maria on KBM reports KFSDW-1503 - Getting issue details... STATUS .   Will look into outputting balances for KFSDW-1007 .

Anh:  Analytics ETL undergoing UAT.

10/10/2016

Attendees:  Eufemia, Matt, Ursula

Issues and bugs:

KFSDW-914: Eufemia continue to work on this.

Bursting had problems running this weekend.

Ursula will be checking production PURAPP/PO facts and dimensions today.  There was an issue with tables being empty which Austin has resolved.

Tasks:

Ursula: continue working on getting bursted reports pointed to latest versions, and ready for testing.   Also continue working on PO package and having users test.  Also developing new Disbursement model JIRA KFSDW-1422.

Matt:  working on getting bursted reports updated and help test.

Eufemia:  will be deploying JIRAs KFSDW-1091 - Getting issue details... STATUS KFSDW-869 - Getting issue details... STATUS KFSDW-1506 - Getting issue details... STATUS this Wednesday at 5pm.   Continue working with Maria on KBM reports KFSDW-1503 - Getting issue details... STATUS .   Continue working on Training material.

10/03/2016

Attendees:  Eufemia, Matt, Ursula, Tammy

Issues and bugs:

KFSDW-914: Eufemia continue to work on this.

Ursula is waiting for Production data on Solar on New PURAPP dimensions from ETL.  JIRA has been opened for ETL team and continue to work with them.

Tasks:

Ursula: KFSDW-1507 - Getting issue details... STATUS titles have been changed, but still need to update bursted reports to latest version. 

Modeling PO stars in Framework are READY FOR TEST JIRA KFSDW-1422.  Currently developing new Disbursement model JIRA KFSDW-1422.

Matt:  Only non-KFS reports.

Eufemia:  JIRAs ready for test, KFSDW-1091 - Getting issue details... STATUS KFSDW-869 - Getting issue details... STATUS KFSDW-1506 - Getting issue details... STATUS .   Continue working with Maria on KBM reports KFSDW-1503 - Getting issue details... STATUS .   Continue working on Training material.

Tammy:  Continue working on KFSDW-944 - Getting issue details... STATUS . 

9/26/2016

Attendees: Eufemia, Matt, Ursula, Anh, Tammy

Issues and bugs:

KFSDW-914: Eufemia continue to work on this.

Anh: SBS aging month-end on 9/12 is duplicating due to triggers firing twice within 1 minute.  Anh removed duplicates, but cause is yet to be resolved.  Continue to monitor until 18th of October.

Tasks:

Anh: Continue to work on the SBS aging month end.

Ursula: KFSDW-1432 - Getting issue details... STATUS is ready for test.  Modeling PO stars in Framework are READY FOR TEST JIRA KFSDW-1422.  Currently developing new Disbursement model JIRA KFSDW-1422.

Matt:  Only non-KFS reports.

Eufemia:  JIRAs ready for test, KFSDW-1091 - Getting issue details... STATUS KFSDW-869 - Getting issue details... STATUS KFSDW-1506 - Getting issue details... STATUS .   Continue working with Maria on KBM reports KFSDW-1503 - Getting issue details... STATUS .   KFSDW-1467 - Getting issue details... STATUS has been assigned to Valerie to give to Austin.  Continue working on Training material.

Tammy:  Continue working on KFSDW-944 - Getting issue details... STATUS . 

9/19/2016

Attendees: Eufemia, Matt, Ursula, Anh

Issues and bugs:

KFSDW-914: Eufemia is working on this.

Anh: SBS aging month-end on 9/12 is duplicating due to triggers firing twice within 1 minute.  Anh removed duplicates, but cause is yet to be resolved.  Continue to monitor.

Tasks:

Anh: Continue to work on the SBS aging month end.

Ursula:  KFSDW-1245 - Getting issue details... STATUS will be working on this. Also working on KFSDW-1432 - Getting issue details... STATUS , working with Matt on this.  Modeling PO stars in Framework

.   

Matt:  Working on KFSDW-1432 - Getting issue details... STATUS with Ursula.  Other non-KFS reports.

Eufemia:  Working on Training material. Continue working Maria on KBM reports, KFSDW-1091 - Getting issue details... STATUS KFSDW-869 - Getting issue details... STATUS .  Report Spec for removing MEDCOM accounts KFSDW-1467 - Getting issue details... STATUS .

9/12/2016

Attendees: Eufemia, Matt, Ursula, Anh

Issues and bugs:

KFSDW-1485: Eufemia is working on this.

Tasks:

Anh:  Month end CAFT, CFS BAL.  Informatica SBS aging month-end on 9/12;  Analytix's ready-to-test jiras, UAT docs.  Annual data warehouse password change on Production this Friday 9/16 5 pm.

Ursula:  KFSDW-1245 - Getting issue details... STATUS will be working on this. Also working on KFSDW-1432 - Getting issue details... STATUS , working with Matt on this.  Modeling PO stars in Framework, JIRA KFSDW-1422

.   

Matt:  Working on KFSDW-1432 - Getting issue details... STATUS with Ursula.  Other non-KFS reports.

Eufemia:  KFSDW-914: Eufemia is working on this.  Working on Training material. Continue working Maria on KBM reports.  Report Spec for removing MEDCOM accounts.

9/6/2016

Attendees: Eufemia, Matt, Pramod, Tammy

Issues and bugs:

KFSDW-914: Eufemia is working on this.

Tasks:

Pramod: Working with Analytix on PURAP ETL; Testing of POSITION SCD ETL code; Data model for TRS (timesheet reporting system).

Matt: Non-Krking with Analytix on PURAP ETL; Testing of POSITION SCD ETL code; Data model for TRS (timesheet reporting system).

Matt: Non-KFS

Tammy: Non-KFS

Eufemia: JIRA KFSDW-914; KBM reports; Fixing some reports for Katherine.

Anh:  KFSDW-1460 - Getting issue details... STATUS to reverse changes; Informatica SBS aging month-end on 9/8;  Analytix's ready-to-test jiras, UAT docs.

8/29/2016

Attendees: Eufemia, Matt, Ursula, Pramod, Anh

Issues and bugs:

KFSDW-914: Eufemia is working on this.

Tasks:

Anh: Reverse AC balance type changes for KBM(KFSDW-1460); Post ODS deployment activities; UAT for PURAP ETL

Eufemia: JIRA KFSDW-914; Putting together training material for advanced report studio.

Pramod: Working with Analytix on PURAP ETL; Testing of POSITION SCD ETL code; Data model for TRS (timesheet reporting system.

Ursula: Validating data post Informatica ODS deployment ; Working on A/R report; PURAP PO Cognos design; KFSDW-1364; Cognos deployment.

Matt: Non_KFS activities

Tammy: Review KFS JIRAs

8/22/2016

Attendees: Eufemia, Tammy, Ursula, Pramod, Anh

Issues and bugs:

Cognos package for US Bank transaction V2 may have incorrect tables.

Tasks:

Ursula: Validating data post Informatica ODS deployment ; Working on A/R report; PURAP PO Cognos design; KFSDW-1364

Eufemia: Validating data post Informatica ODS deployment ; RAFG report for G/L; KFSDW-1438; Documenting Cognos packages; KFSDW-1401

Tammy: Post ODs deployment; Review KFS JIRAs

Anh: ETL development for additional requirements in KBM to remove AC from LD_LDGR_BAL_V02_T,LD_LDGR_ENTR_V02_T to migrate to production after all ODS jobs to production (KFSDW-1460); Post ODS deployment activities; UAT for PURAP ETL

Pramod: Working with Analytix on Requisition ETL; Code changes for POSITION SCD; Data model for TRS (timesheet reporting system, changes to PURAP PO data model.

Matt: PO encumbrance report

8/15/2016

Attendees: Eufemia, Tammy, Ursula, Pramod, Matt

Issues and bugs:

ODS INFA Deployment: Issue with sub_acct_nbr and sub_obj_code being NULL instead of '-'

Tasks:

Ursula: Validating data post Informatica ODS deployment ; Working on A/R report; PURAP PO analysis

Eufemia: Validating data post Informatica ODS deployment ; RAFG report for G/L

Matt: PO encumbrance report

Tammy: Post ODs deployment; Review KFS JIRAs

Anh: Working on CAFP and CFBAL Feed month-end,  ETL development for additional requirements in KBM to remove AC from LD_LDGR_BAL_V02_T,LD_LDGR_ENTR_V02_T to migrate to production after all ODS jobs to production; Post ODS deployment activities. Changing annual passwords.

Pramod: Working with Analytix on TEM; Code changes for POSITION SCD.

8/8/2016

Attendees: Eufemia, Tammy, Ursula, Pramod, Matt

Issues and bugs:

KFSDW-1431: Ursula working on this

ODS Informatica jobs deployment: Waiting for Maria to sign off on RAFG summary report. Eufemia to follow up

RAFG G/L report performance - Eufemia to work with Pramod

AR report: Ursula to work with Eufemia

Tasks:

Pramod: Budget position dimension SCD design. Analytix data model hand-over for ETL

Ursula: Modeling PO data in Cognos FM, JIRA 1431

Eufemia: Finishing KBM report testing for ODS, RAFG report for G/L, JIRA 1164

Matt: JIRA 1006 (PO encumbrance report)

Tammy: ODS deployment 

Anh:  Working on SMS Feed month-end,  ETL development for additional requirements in KBM to remove AC from LD_LDGR_BAL_V02_T,LD_LDGR_ENTR_V02_T to migrate to production after all ODS jobs to production, preparing ODS migration to production this Friday.

8/1/2016

Attendees: Eufemia, Tammy, Ursula, Pramod, Matt

Issues and bugs:

 KFSDW-1354 : Will be deployed August 17th

ODS Informatica jobs ready to de deployed August 12th

RAFG G/L report performance - Eufemia to work with Pramod

Tasks:

Eufemia: Finishing up budget reports. Working on Asset type code JIRA

Ursula: AR report, PURAP PO package

Anh: JIRA 1403

Pramod: Re-design budget tables using new Position dimension

Tammy: Non-KFS activities

Matt: JIRA 1006

7/25/2016

Attendees: Eufemia, Tammy, Ursula, Pramod

Bugs: Anh working on KFSDW-1403 - Getting issue details... STATUS

Issues: Anh will need to 'fix' SBS Aging Talend jobs every month until the ODS Informatica jobs go LIVE, because they overwrite the fixes. 

Eufemia tested KBM reports on LUNAR - DEV and they look good.  Asking Maria to double check Staffing reports. 

ETA for rolling out ODS Informatica jobs August 12th.  Informatica jobs are running every day on LUNAR.

Tasks: Anh - working KBM, outbound, testing JIRAs.  Anh needs to fix the Talend job for the SBS Aging ETL by next fiscal close.

Eufemia: Finishing budget reports, transitioning Matt's KFS JIRAs, Helping Pramod with KBM model questions.

Ursula: AR report, Cross-training on KFS.  Looking at PURAP/PO model in order to begin creating package.

Tammy: non-KFS work, watching nightly jobs

Pramod: working on position dimension, finding interim solutions for Maria, will meet with Eufemia this week.  Add Ursula to watchlist on PURAP models.

7/18/2016

Attendees: Eufemia, Tammy, Pramod, Ursula

Issues:

Budget RAFG report timing out

Tasks:

Pramod: Budget data model. Disbursement ETL transition to Analytix

Tammy: Non-KFS tasks

Eufemia: Finishing budget reports, transitioning Matt's KFS JIRAs

Ursula: AR report, Cross-training on KFS

7/11/2016

Attendees: Eufemia, Matt, Tammy, Pramod, Ursula

Issues:

KFSDW-864 : Eufemia will make sure the June staffing report is ready to deploy. Maria confirmed that the data looks good.

Tasks

Pramod: Budget data model. PREQ ETL transition to Analytix.

Matt: Any changes or fixes for reports "Ready For Test" will be worked on with Ursula.  Non-KFS (UC Path) tasks.

Tammy: Helping out with ODS conversion.

Ursula: Working on AR report, training with Eufemia and Matt on KFS

Eufemia: JIRA 864. RAFG report. Budget reports

6/27/2016

Attendees: Anh, Matt, Tammy, Pramod

Bug Review

KFSDW-1365: Assigned to Eufemia

Issues:

KFSDW-1349: AR Recon: Ready for test

Tasks

Pramod: Balance job re-design. Budget data model. FYE JIRAs

Matt: Working on documentation for KFS reports.  Any changes or fixes for reports "Ready For Test" will be worked on with Ursula.  Trouble shoot PCS report. Non-KFS (UC Path) tasks.

Anh: Deploying ODS KSAMS to Production

Tammy: Helping out with ODS conversion.

6/20/2016

Bug Review

KFSDW-1314 will be deployed on 06/22

Issues

Pramod and Eufemia will be working on speeding up the RAFG Detail report.

AR re-con table: Inconsistency between Oracle and SQL Server (reported by Ursula)

Cognos package for PURAP: New package or add to existing? Schedule meeting with Melissa, Durendal.

Tasks

Eufemia: Create a JIRA for a new cognos package for end-user training (CAFE - Cognos analytics for excel). RAFG report. Documenting report development workflow.

Pramod: Balance job re-design, hand-over Disbursement (PDP) ETL to Analytix. Budget data model.

Matt: working on documentation for KFS reports.  Any changes or fixes for reports "Ready For Test" will be worked on with Ursula.  Working on how to join the PO View to GL Entries.

Ursula:Training with Matt on KFS reports (ready for test),

Anh: Changing KFS database passwords for annual password change (incl. Secret Server). Working on ODS and testing Analytix ETL.

Tammy: Helping out with ODS conversion.

6/13/2016

Bug Review

KFSDW-1314 is still waiting for test

Issues

Talend ODS job needs to be rerun today due to Oracle server move (affect Account Transactions and PDP Check reports).

Pramod and Eufemia will be working on speeding up the RAFG Detail report.

Need to reconfig connection Oracle database due to server move (change config files).

Tasks

Matt - working on documentation for KFS reports.  Any changes or fixes for reports "Ready For Test" will be worked on with Ursula.  Working on how to join the PO View to GL Entries.

Anh - Talend ODS jobs to have new connection for the Oracle Server move.  Changing KFS database passwords for annual password change (incl. Secret Server). 

Tammy - working on non KFS, LDAP people jobs, etc.

Eufemia - documenting KFS Report Development Workflow, getting RAFG report ready for test (working on performance), finish testing for ODS tables.

Ursula - Training with Matt on KFS reports (ready for test), meeting with Melissa regarding AR Report.

Pramod - deploying KFSDW-1289 on Friday, possible deploy KFS_D_RAFG as well (datatype for dimension), working with Analytics for PURAPP model.

6/6/2016

Bug Review

KFSDW-1313 was put on hold by Accounting. We will work on it after fiscal year end.

KFSDW-1314 - Asked Kevin with help with prioritization. Assigned to Matt but the rest will help out too.

Issues

KFSDW-1245 - KFS Team is still making changes to the AR tables, but this shouldn't prevent us from moving forward with development

There were KFS schema changes over the weekend, which shouldn't affect us but just in case Valerie will forward the email to everyone.

KFSDW-1293 - Waiting to hear back from Kevin

Bug in staging workflow, causing problems with KFSDW-1042. There was a table missing in the staging workflow, which then impacted ODS. Tammy is working with Bryce to fix the problem, and the ETL change will go into prod tonight. Eufemia will test the package tomorrow.

KFSDW-1015 - Needs a package change so that Katherine can test the new balance column. Eufemia will make the change and let us know when its ready for testing.

5/23/2016

Bug Review

KFSDW-914 - Needs a due date. Will discuss with Kevin this afternoon.

Issues

There was no data in the AR reconciliation tables in prod. Valerie asked Bryce to investigate this.

KFSDW-1067 - There was some confusion about separated dates, Valerie commented on JIRA to Karen.

RAFG report (KFSDW-1084) - Matt has some questions for Maria, needs an update due date, and RAFG codes do not appear to be assigned correctly in ETL. Pramod will investigate ETL issue.

5/16/2016

Bug Review

KFSDW-1244 - This is now an enhancement/bug. Matt will take care of this

KFSDW-1172 & KFSDW-1181 - Valerie will follow-up with Andrew

KFSDW-962 - Might need to cancel this one. Valerie will investigate

Issues

We have 17 reports ready for test, still waiting on responses from users.

Matt has 9 reports that are ready for test. Eufemia and Matt will work with Ursula on cross-training for some of these JIRAs

Eufemia is on vacation from 5/20 - 5/31

ODS Testing - Eufemia will give Valerie a list of tables that don't appear to match prod, and Valerie will contact Warren regarding the KFSDAY2 refresh schedule and if those tables are not being copied from prod nightly.

KFSDW-1195 - Is this ready for prod? Durendal added a collate to a few more columns. Matt will send the details on what Durendal did to Pramod.

KFSDW-1015 - This is a new column to the balance table that will need to be added to the package. Once Kevin is done with his testing Pramod will put the change into the table on dev, so that package development can be done. Pramod will create a sub-task for the package change once the table is ready on dev.

No deployments this week (yet).

Eufemia is working on RAFG report, and encountering problems with performance. She sent SQL on Friday, so we can review that. Pramod will get back to Eufemia after looking at her SQL.

5/9/2016

Bug Review

All bugs are ready for test, ready for deploy or on hold.

Issues

Cognos team is going to a Cognos user group meeting on Wednesday, so all report turnovers will be done on Tuesday instead.

Discussion about deployment groups, versions in JIRA

Cognos team is analyzing the work that is needed to test the ODS changes, creating development packages for this testing

KFSDW-1274 - Maribeth is working with John Douglas on this requirement, and we may not need to develop a report after all.

Tasks

Anh - Still working on SBS job triggers with Jarrod. Still working on UAT for Analytix work for Account and Object Dim.

Ursula - Testing reports for new ODS changes. AP non-active employees report.

Matt - Testing for ODS, working with Durendal on Saved Query option. We finally got DDODS data for UCPath. Still waiting on transition to UCPath project.

Tammy - Catching up from vacation. Working on ldap_people job.

Eufemia - Finish up testing for ODS changes including KBM and changes to SBS tables. Working on RAFG report (KFSDW-1084)

Pramod - Working on new addition to balance table, modification of ETL for ITD balances. Design for AP data mart.

5/2/2016

Bug Review

 KFSDW-1115 - Eufemia talked to Mat Wilson about FP4, they are trying to include it with security updates in Cognos. The BI team is still evaluating how to test the update.

KFSDW-1244 - Waiting for Accounting to test

All others are ready to deploy or on hold

Issues

KFSDW-1195 - Doc details action taken code - fix is in DB but Matt doesn't see it fixed on the FM package on dev. Matt will try to test this in the framework project directly instead of in the report.

KFSDW-974 - Report devs still need to test ODS tables. We have about 157 reports that will need to be tested. Eufemia will create a JIRA for testing.

KFSDW-1007 - Specs need to be updated. Valerie will discuss in our meeting with Accounting.

Tasks

Anh - SBS job triggers. Fixed the data types in the database. Framework package will need to be updated for SBS Aging data. Valerie will create a JIRA for FM package & update to report. Account & Object SCD changes to dimensions, will not go into prod until after fiscal year end. This will require framework and report modifications.

Eufemia - Waiting for response from Diane on KFSDW-979. Waiting for Kitty on KFSDW-345

Pramod - Award dimension specs. Modifications to balances that will impact the fund summary report.

 04/25/2016

Bug Review

KFSDW-1244 - This report is looking at the Award Lookup package. Matt will investigate. Waiting for user approval

KFSDW-914 - Drill through by balance type. Depends on KFSDW-1202   and KFSDW-806. Placed on hold

KFSDW-1242 - Jarrod working on this

KFSDW-1243 - Anh doing final testing

All others are on hold or waiting for deploy

Issues

None to report

Tasks

Pramod - KFSDW-1195 Matt needs help connecting to the databases. PO subject area ETL

Eufemia - KFSDW-974 Testing, Working on KFSDW-345 and KFSDW-979

Ursula - Finishing up SMS feed report

Matt - Testing KFSDW-1175. Working with Durendal on Javascript

Anh - KFSDW-974 will work with Eufemia to fix any issues. Month-end jobs, problem solving issue with duplicate records. Working on KFSDW-1243 and KFSDW-1242

Tammy - Non KFS-related

04/18/2016

Bug Review

KFSDW-1244 - This report is looking at the Award Lookup package. Matt will investigate

KFSDW-914 - Drill through by balance type. Depends on KFSDW-1202   and KFSDW-806

All others are in progress, on hold or waiting for deploy

Issues

AR reconciliation tables. New package and reports will need to be developed by FYEC

Eufemia will work on documenting packages, which reports are pointing to them, and the usage for each package (subject area, etc)

PO was approved for PURAP model work

Tasks

Pramod - KFSDW-1195 Matt needs help connecting to the databases. PO subject area ETL

Eufemia - KFSDW-974 Testing, Working on KFSDW-345 and KFSDW-979

04/11/2016

Bug Review

Everything is ready to deploy, on  hold, or waiting for the Cognos patch

Issues

KFSDW-345 - We will make the fiscal period prompt a single select, and return YTD balances instead. They also want the Excel format output to show in three different tabs when users picks all three lists, and two if user picks two lists, and so on.. Can we do one list with no groupings? We need to follow-up with Kevin at our weekly meeting with Accounting.

Eufemia - KFSDW-1232 Karen tested and March data doesn't look good.

Tasks

Eufemia - Currently working on KFSDW-345, KFSDW-882, KFSDW-974 for testing of reports

Ursula - KFSDW-1021 She can't find name in the ldap_people table. Eufemia will help Ursula find this info.

Matt - KFSDW-1006, KFSDW-497 is being tested, KFSDW-1175

Pramod - RAFG fact tables with Analytix. Spec'ing ETL for type 2 changes to Account and Object dimensions.

Anh - KFSDW-974 will work with Eufemia to fix any issues. Month-end jobs, problem solving issue with duplicate records. Fixing data types for SBS aging detail.

04/04/2016

Bug Review

• KFSDW-1115 - Waiting for Cognos Fix Pack

Issues

Credit Memo, KFSDW-1194 - Karen tested, found an issue, Eufemia will get back to Karen.

Canceled checks - KFSDW-937 - Eufemia to confirm with Karen if she needs to see special handling indicator

Tasks

Pramod - Pending entries fact table design. Create PO subject area tables on dev. Source to target for PREQ & Credit memo. Deployment standards.

Eufemia - JIRAs 937, 1175, 1190, 1200. Developing new reports 882 and 345.

Ursula - Getting up to speed, working on Origin code (JIRA 1021), 1175 (working with Eufemia)

Tammy - Mostly non-KFS work this week

Anh - Reviewing ODS jobs in preparation for migration to production. Working with Durendal on getting approval to enhance fund name from dash to non-dash values when there is no fund name from the source

Matt - JIRAs 880, 1202, 1203

03/28/2016

Bug Review

• KFSDW-1203 - Eufemia will take a look
• KFSDW-1115 - Waiting for Cognos Fix Pack

Issues

Action Code - Pramod is close to being done on fixing the values in the ETL code. Eufemia will look at the data in report studio once this is done to see if that fixes the problem.

Credit Memo - Amount in main table does not reconcile with the sum of the line item amounts. Eufemia made changes to the package and report to use this table, and the users are now testing. Keiko told Valerie that this 'design' occurs in all AP related modules so that we will need to evaluate other AP related reports. Eufemia will create a  JIRA to do this.

We had some issues with the tem_* ODS tables. Anh fixed this and it should run fine tonight.

Tasks

Pramod - Pending entries fact table design. Type 2 discussions for Account/Object. Create PO subject area tables on dev.

Eufemia - Cross training Ursula. PO payment report - needs to discuss more with Heidi and Melissa to clarify requirements.

Tammy - Mostly non-KFS work this week

Anh - Deploying JIRA for Account Dim changes, reviewing ODS jobs in preparation for migration to production. Updating GEC tables on dev.

03/21/2016

Bug Review

• KFSDW-1115 - Waiting for Cognos Fix Pack
• KFSDW-1183 - Anh is working on it
• KFSDW-1181 - Andrew is working on it, should be able to push this change out this Wednesday
• KFSDW-1193 - Pramod will see if the table has data, and if there is data will assign to Eufemia. There is a problem with this table on dev, put prod should be fine.
• KFSDW-1185 - Valerie will follow-up with Kevin.
• KFSDW-1164 - Asked Susan if we should fix the stored proc, if not we need to take the links down from ZotPortal.

Issues

Action Code/Description - ETL code only handles upper case values, and the descriptions are hard-coded in the ETL. We will need to update the dimensions and the fact tables to fix this problem. The source staging and target tables are not matching, so Pramod will follow-up with Austin and Pramod. Pramod will send email to Warren asking for all the action descriptions for each action code. Valerie will create  JIRA for this problem.

Tasks

Eufemia - Fixing reports, mainly reports in testing. Testing of the ODS KBM tables. KFWDW-882 & 345

Pramod - Source to target for PREQ & Requisition. Generating DDLs for PO. Deploy ETL into production for RAFG, Account Dim

Tammy - ETL for UCPath EROS roll-out. Will keep an eye on the employee_change table in prod.

Ursula starts next week!

03/07/2016

We did not formally meet since most of the team was out. Eufemia and Tammy had a quick chat about pointing the Chart of Accounts lookups that were going against Oracle to KFSDAY2 as per Valerie's instructions. Eufemia will follow up on creating a new connection in Cognos so that it can be used in the framework package. Durendal can assist with the setup and Austin can assist with the server name/username info or any other firewall rules that may be needed.

02/29/2016

KFSDW-1153 - Tammy will have Bryce build a temporary mapping to load this table. She will load the table in prod today so that the user can see the data.

No other updates for this week.

02/22/2016

Bug Review

KFSDW-1115 - IBM thinks that fix pack 4 will fix this problem. We have not scheduled this fix pack installation yet.

KFSDW-951 - Out for testing

Issues

Eufemia will test GL dimension POC soon.

KBM ODS ETL in Informatica is done on dev and ready for report testing. KBM Override ETL development is in progress.

Tasks for the week

Matt - KFSDW-1094 (needs to look at SQL), KFSDW-965 having difficulty adding the subtotals by Rollup Org. KFSDW-880 ready for test.

Eufemia - KFSDW-345 almost ready for test, will work on KFSDW-882 next. These are due next week

Tammy - Finishing BLISS query, adding fields. Modifying metadata attribute names from Cognos to BLISS. KFSDW-879 - Kevin will provide Karen with an extract for now, and wait until the Workflow data model is done. LDAP project.

Bryce - KFSDW-945 ETL complete and ready for deploy, Tammy is doing code review. KFSDW-1117 is ready for deploy, Tammy to do code review and schedule both turnovers.

Pramod - KFSDW-927 deployed this friday. KFSDW-1116 - give to Analytix. KFSDW-1089 - give to Analytix. Data Modeling - PO review is complete. Working on requisition.

Anh - Informatica conversion main KFS ODS job (big one). KBM override tables.

02/16/2016

Bug Review

KFSDW-1115 - We aren't sure if this is fixed. Commented asking Kevin if this is fixed.

KFSDW-767 - We need to discuss with Accounting on how to proceed. Valerie will ask to have this added to the agenda.

KFSDW-951 - Alignment is off when report does not show encumbrances. Waiting for Kevin's response on if we should go ahead and roll out as-is or fix first.

Issues

Still need to test the proposed COA changes (KFSDW-970), to see how this impacts reports. Eufemia will work on building the package. Pramod will provide Eufemia with the table names.

Tasks for the week

Matt - KFSDW-951, 1098, 965, 806, 1094

Eufemia - 345, 882, COA changes

Tammy - PO Encumbrance (waiting for Kevin's extract), review specs for KFSDW-879, changes to BLISS (testing to end this week)
Pramod - working PO model, Analytix work

Anh - KBM ODS jobs, main KFS ODS jobs

02/09/2016 

Bug Review

KFSDW-1115 - Eufemia will work to lock down query items in package.

Issues

ETL Turnovers  Wednesday - Bank reconciliation jobs, KSAMS KBM access

Tasks for the week

Eufemia - KFSDW-345 still has some questions for Maribeth

02/01/2016

Bug Review

All bugs are either waiting for customer, waiting for test, on hold or ready to deploy.

Issues or Requests

Kevin's tree prompt request - KFSDW-1076 - How do we want to deal with requests like these? This requires us to build a new DMR package. 

Tasks for the week

Eufemia - 4-5 new reports that need tech spec reviewed. 2 due in a month.

01/25/2016

Bug Review

All bugs are being tested or are ready for roll-out except KFSDW-962

Issues

Today is Monday

• KFSDW-881 - The report is showing POs that did have tax, even though the report should not. Eufemia will take a look at the data and work with Matt to fix the report.
• KFSDW-1042 - Problems with data missing when running reports from the package, but the data exits in the DB. Eufemia will take a look with Matt.
• KFSDW-927 - New rows will be created for the manual postings in the balance table. Eufemia will investigate and do some testing to make sure this doesn't impact reports. Pramod will update the balance table on dev so that she can test.

Tasks for this week

Eufemia - 345, 882 tech spec review. 945 - cognos framework. Working w/Matt on 2 issues above. 1084, 873 for budget office. all in progress reports.

Matt -  1042 (workflow), bliss migration is ready for test, 906, 806 are in progress. 497 & 392, 881, 934, 998 are ready to test.

Scott - 308 - waiting for answer from Kevin. 979 is ready for development, formatting of ledger recon is in test, balance sheet report 1007 is in progress. expense revenue report is in progress. 1039 is ready for test.

Tammy - BLISS KFS adhoc query (940). Bryce's JIRAS 489 and 1045 ready for deploy this Friday.

Anh - KFS ODS jobs and KBM ODS jobs. Anh will work with Eufemia to test the data.

Pramod - PO and PREQ models. Deploy 927 this Friday for manual entries in the balance table.

01/11/2016

Bug Review

KFSDW-951 - We need to re-evaluate this report, and come up with a new solution. We will follow-up with Kevin on Thursday.

KFSDW-962 - December data is fixed. Valerie will ask Linda how far back the SBS team needs to go to fix the historical data.

KFSDW-1061 - When user selects 2015, no data is returned in report. Eufemia will investigate.

KFSDW-872 - Done in dev. Production roll-out needs to be scheduled.

Issues

Meeting with Heidi is scheduled to go over report security. Valerie will forward invites to Eufemia.

KFSDW-943 - We think this is ready for test. Eufemia will follow-up with Scott.

We have report deployments on Tuesday and Wednesday.

We have 4 ETL (ledger entries and balance changes) deployments this Friday.

KFSDW-1049 - need to discuss this on Thursday with the functional team. We would like to know more about the background on this one.

Tasks for This Week

Matt - BLISS Migration is almost complete (package is done, currently developing reports), KFSDW-1042 ready for development, KFSDW-906 in development, KFSDW-1049 - lower priority

Eufemia - Budget report. She is reviewing the list of current reports to see who will do what. Testing the changes to dimensions.

Tammy - Working with student to copy metadata to the legacy meta data database on MySQL. ETL for TEM tables, tables need to be added to a package. Investigating data problems in the credit memo table. She is testing the job to see if the data is loading correctly.

Anh - Continue work on converting the ODS jobs to Informatica.

Pramod - Getting code ready for deployment (the 4 JIRAs). Started work on the PO data model. Working with ErWin support to get it connected to Oracle.

01/04/2016

Bug Review

KFSDW-872 - Fix is in progress

Most others are ready for test

KFSDW-962 - Still waiting on a response from SBS team

KFSDW-767 - Do we still need to do this? We will discuss with Kevin on Thursday

Open Issues or Concerns

KFSDW-943 - Ask Melissa about this on Thursday. Should we still meet with Heidi?

New Requests:

KFSDW-1041 - Scott will work on this one

KFSDW-1039 - Tammy will review

KFSDW-1038 - Valerie will discuss with Durendal on best approach

KFSDW-1021 - Needs table in ODS first. Was waiting on KFS release on 12/19. Anh will develop ETL to copy table.

Tasks for the week:

Scott - KFSDW-1041, waiting on meeting for Purchase Order Report. KFSDW-553 - Report roll-out next week after ETL production roll-out on Friday. Finishing Invoice Due date out of range report.

Matt - BLISS migration, building framework against legacy DW. KFSDW-1042

Tammy - Helping student with Informatica development. Cross-training new employee on existing reports. KFSDW-1039. Copying KFS metadata to legacy MetaData database for BLISS query usage.

Pramod - KFSDW-927, new field in GL balance fact table for hand postings, also adding a flag for this. KFSDW-699 going into production Friday. Waiting on testing for other balances. Working with ErWin support.

12/14/2015

Bug Review

Open Issues or Concerns

Tasks for the Week

Matt - Is stuck on the adhoc report, prompts are showing as default. He will work with Scott to try to troubleshoot this. In the meantime, he will try to connect to MySQL from framework manager.

Eufemia is going on vacation until Jan 8th and is leaving us here to handle things on our own! She will be telecommuting on Thursday and Friday and will call into the meeting on Thursday.

Scott - Testing POC for sub object, org and award dims. Eufemia will give Scott the rundown on what needs to be done. PLSQL output validation KFSDW-699. PO Report - has questions for Heidi. Should we set up a meeting? Invoice due date out of range report improvements, really needs a re-write.

Valerie - Set up meeting to discuss reporting security requirements.

Anh - ODS jobs KFSDW-974 and KBM ODS jobs KFSDW-999 bug fix.

Pramod - 1004 ready for test, 453 - specs changed. Need a new JIRA to fix GL Beginning Base Budget Amount. 980 is in progress. Will talk to Durendal about 927. Trying to fix Oracle connection in ErWin.

Tammy - GL AdHoc BLISS query. Talk to Durendal about KFS metadata. Kevin is currently reviewing the query. Bank reconciliation job - schedule in production.

12/7/2015

Bug Review

KFSDW-994

KFSDW-980 - Ready for development. Specs approved

KFSDW-962 - Valerie will follow-up with SBS team

KFSDW-967

KFSDW-872

Open issues or concerns

New v4 DQM package. The old package will still work for now. Users have developed reports using the old package and will need to switch over to the new package before the data model changes go into production. 

BI Team will work on creating an email list for all ad-hoc report developers. Anyone that has access to the KSAMS role will get an email. They will work to switch out the package that each report is using and coordinate testing.

Tasks for the week

Anh - KFSDW-974 (ODS jobs)

Tammy - Bank Reconciliation ETL, KFSDW-24 developing an ETL script to load a table (Does Faye not need this report anymore due to enhancements to KFS?), KFS BLISS AdHoc Query

Pramod - Columns added to balance fact. Pramod will assign JIRAs to Eufemia to add columns to cognos package. KFSDW-699 - will try to source from stage_kfs in sql server instead of oracle due to peformance issues in oracle. KFSDW-890 - will assign to kevin for testing. Will start looking at KFSDW-927 and KFSDW-980

Eufemia - PO report, made package changes and are testing. Waiting for questions to be answered from Heidi. KBM reports, user guide. New KBM data requirement - will discuss with Valerie this week. Testing the COA dimension redesign for the prompts.

Scott - Reviewing package changes and will develop PO report. Post audit disbursement voucher report based on PLSQL, we will have to ask Keiko how we can validate the data in this report.

Matt - KFSDW-830 needs to confirm with Kevin on what the requirements are. KFSDW-947 - waiting on confirmation from Kevin. KFSDW-891 - should we just show the header and a message that no transactions are found for this period? We can discuss in friday's meeting with Accounting. Eufemia will work with Durendal to give Matt a list of all the query criteria being used in the KFS AdHoc Report.

11/30/2015

Bug Review

KFSDW-951 - Scott is working on this. Will use balances instead of ledger entries. We may need to create additional balance buckets in the balance table. Eufemia will document this and let us know.

KFSDW-962 - Still waiting on SBS team

KFSDW-586 - In progress

KFSDW-872

Tasks for the week:

Matt - Kevin asked for KFSDW-906 to posted on staging, working on KFSDW-891, Waiting to hear back from Kevin on KFSDW-947. Matt needs more work. Possibly the PO report. Updating report security wiki page. Valerie will follow-up on MySQL connection in Cognos.

Tammy - Prototype for KFS BLISS GL AdHoc. She's waiting for a list of attributes from Kevin. We also need to load in metadata tables. Needs finishing touches. Tammy will work with Accounting on this. KFSDW-984 ready for roll-out.

Anh - Bug 586 - almost ready for roll-out. Finishing development of ODS jobs (KFSDW-974).

Scott - Ledger Recon bug. Will update package once Tammy's view is rolled-out. LOC report - still waiting for an answer from Alice.

Pramod - Currently working on 857 and 453. On 699, he is trying to use KFSDAY to pull data but the tables are empty for

FP_DV_PAYEE_DTL_T & FP_DV_DOC_T. Kevin is testing KFSDW-890. Finished prototype of dimension split (KFSDW-970), Eufemia will test.

Eufemia - Call Faye regarding KFSDW-24. Finishing PO report spec with Heidi and Keiko. Budget reports to be done this week. Testing the dimension split prototype. Document any additional balance buckets that are needed in the balance table.

Valerie - Set up meeting with Matt to go over report security wiki plus data warehouse log files. Still need to investigate KFSDW-959 - using PURAP fact table.

11/23/2015

Bug Review

KFSDW-951 - Eufemia will set up a meeting w/Durendal

KFSDW-357 - Data is currently not being used.

KFSDW-975 - Anh will work on this soon

KFSDW-586 - Valerie and Anh will discuss tomorrow

KFSDW-967 - Scott is currently testing

KFSDW-965 - Eufemia will follow-up with Melissa. We think Melissa is going to write up a spec for this one.

KFSDW-962 - Waiting on a response from SBS team, to see if they can add sub-object in for past transactions.

KFSDW-872 - Tammy will work with Bryce on this

Tasks for the week:

Valerie - Talk to Austin and Mat about turning on version control in dev. Take away access from Analytix devs. Set up a meeting with Faye, Tammy, Eufemia and Keiko to discuss KFSDW-24

Matt - KFS Report security wiki page: /wiki/spaces/UCIKFS/pages/23298280 PCS lookup JIRA KFSDW-981

Anh - KFSDW-586, KFSDW-975

Scott - KFSDW-967, Lease expenses report KFSDW-978, Testing ETL changes

Pramod - KFSDW-699, KFSDW-857, KFSDW-453, KFSDW-970 POC for COA bridge table (dimension split)

Eufemia - KFSDW-951, Testing ETL changes, Send test extract to FAYE for KFSDW-24

11/16/2015

Bug Review

KFSDW-890 - done in dev, needs testing

KFSDW-951 - eufemia will follow-up

KFSDW-357 - Valerie will follow-up with Keiko

KFSDW-825 - Pramod will work on this. Eufemia will test.

KFSDW-586 - Will follow-up with anh

KFSDW-872 - Will address after Informatica jobs are on the production server

KFSDW-429 - valerie will follow-up

KFSDW-607 - Tammy

KFSDW-959 - Not a bug, switched to improvement

KFSDW-962 - Valerie will send email to Tu and James, CBSO transactions do not have sub-objects in the source files

KFSDW-965  - Will review at reporting meeting on thursday with functional team

KFSDW-966 - Not a bug

KFSDW-967 - Scott will look at this one

Tasks for the week

Review KFS Reporting Agenda items

Pramod (453, 699, 856, create a JIRA for POC table for prompt testing)

Eufemia is working on Cognos upgrade, finishing testing. Any remaining reports will be fixed after the upgrade. There are 3 reports that have failed testing, which Eufemia will address this week with Melissa. Any tasks waiting for informatica. Will follow up with Melissa Lee on testing for KFSDW-934

Matt - KFSDW-943, he's waiting for clarification on specs from Melissa. Matt needs work. KFSDW-881 - Matt will look at generated SQL to see if it is joining Fiscal period dim to GL or CAM facts. Eufemia will assign any reports that have failed Cognos testing. Take schedule C report link off of ZotPortal. Update report security Wiki Page.

Scott will create a JIRA to enhance KFS-GL-033-Lease Expenses report to add ICR rate. Transparency Report.

Tammy - Doc details SID bug. Building the KFS GL detail adhoc query in BLISS.

Task blockers:

KFSDW-699 - Pramod needs data in tables so that he can test. He will work with Warren.

There are quite a few reports waiting for testing.

KFSDW-943, Matt is waiting for clarification on specs from Melissa

Matt is waiting for MySQL connection to be set up in Cognos

Non-KFS related tasks:

Cognos upgrade is this weekend 11/21, no new report deployments this week

All new deployments will need to be tested on new version of Cognos 10.2.2

Issues or questions?