4/25/2016 - 5/6/2016
Completed
- Dimensions/Facts/ODS workflows load testing to dss and troubleshooting errors all completed and successful.
- Cognos training session for Barbara/Jonathan on using Workspace Advance.
- Investigating NULL values in PRELIM_REVIEW_DT from KC.
- Related to a KC workflow change that was deployed in Oct. 2015.
- Need to adjust ETL logic. Also affects other fields using the ROLE_NM and RSP_ID fields.
- KC proposal average workflow Cognos report completed per request by OR.
- Aiding in troubleshooting various Informatica ODS workflows issues/enhancements.
In Progress
- Adjust KC ODS Informatica mapping to add additional logic to account for KC proposal workflow change.
- Logic needs to be based on pre and post 10/21/2015 cutoff date groups.
- Proposal quarterly average trends Cognos report for Nancy/Bruce (will commence after above fix).
- SPA reports specification review/discussion with OR functional staff (on-going).
- Nancy/Barbara have mentioned that the award counts may need to be adjusted to reflect distinct awards.
- Investigating source of RPT_DEPT_CODE change in the awards over fiscal years.
- Informatica SRAQ.
- Completed network diagram/data flow diagram.
Planned
- Zena working session with Michael Story for automation of workflow failures (Currently waiting to meet with Michael Story).
- Defining relationships for all SPA system tables for the Cognos framework model (Currently waiting for documentation from Eric).
4/11/2016 - 4/22/2016
Completed
...