...
KFSDW-980 - Ready for development. Specs approved
KFSDW-962 - Valerie will follow-up with SBS team
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.
...