10/24/2016 - 11/4/2016
Completed
- SPA award count logic adjustment to exclude administration cycles and add two additional measures.
- Award table loaded with new measures.
- SPA monthly report conversion (stored procedure to Cognos report) complete.
- ETL adjustments complete.
- Informatica Analyst overview and usage presentation.
- Banner ODS training.
- Informatica LDAP connector purchase request approved by the Acquisition Review Team.
In Progress
- SPA award count logic adjustment to exclude administration cycles and add two additional measures.
- Award history table.
- SPA quarterly report design with new award count logic and additional measures.
- Zena Agent install on etl-dev.
- Waiting on firewall exceptions to be completed by the security team.
- Troubleshooting ETL performance issues from etl0 to solar.
- Continuing to experience semaphore timeouts from Solar.
Planned
- Informatica SRAQ.
- Need to schedule meetings with security team.
10/10/2016 - 10/21/2016
Completed
- Troubleshooting/fixing new development by Analytix for KFS data mart additions.
- PO
- Disbursement
- KFS PO subject area loading merged with daily loading workflow and deployed to production.
- Sponsor category code reconciliation for SPA reports.
- KC Negotiations module dimensional model Cognos Framework design.
- Sample Cognos reports design as POC for OR functional staff.
- Informatica PowerExchange for LDAP price quote request and purchase justification.
- Re-negotiated original price from $36k down to $21.6k
- D_DATE dimension holiday column update process completed using staff holiday list compiled by Allison.
- JIRA issues completed:
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1467 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1515 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1257 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1528 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1527 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1534
In Progress
- SPA award count logic adjustment to exclude administration cycles and add two additional measures.
- Administrative cycle count
- Award cycle count.
- SPA monthly/quarterly reports design.
- Based on review of the sprocs, ETL adjustments are required for the daily OR loading.
- New Cognos reports need to be designed.
- Zena Agent install on etl-dev.
- Waiting on firewall exceptions to be completed by the security team.
- Troubleshooting ETL performance issues from etl0 to solar.
- Continuing to experience semaphore timeouts from Solar.
...