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-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.
KFSDW-962 - Still waiting on SBS team
KFSDW-586 - In progress
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
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?