10/5/2015 - 10/16/2015
Completed
- Cognos security permissions review for Office of Research related reports.
- Office of Research data warehouse phase II discussion.
- Functional staff mentioned needing data around timing between proposal statuses and how long in each status.
- Reviewing KC database schema for data that will allow for capturing historical data to satisfy reporting.
- New KSAMS roles proposal for Informatica.
In Progress
- Aiding with troubleshooting/testing of Talend/Informatica conversion.
- Cognos 10.2.2 upgrade testing.
- Found an issue with outputting any reports other than html causing an error.
- KFS_F_GL_BALANCE table reconciliation between dss/dss_kfs.
- Currently, six columns do not match in the KFS_F_GL_BALANCE3 table
- GL_BEG_CURR_ASSETS_AMT, GL_BEG_FUND_BALANCE, GL_BEG_CUR_LI_AMT, GL_BEG_BAL_AS_LI_FB, GL_BEG_FUND_BAL_IN_ACCTS, GL_BEG_CASH_ASSETS_AMT
- Currently, six columns do not match in the KFS_F_GL_BALANCE3 table
Planned
- OR dimensional model design based on feedback from the functional teams.
9/21/2015 - 10/2/2015
Completed
...