7/18/2016 - 7/22/2016
Completed
- OR Cognos reports demo/training sessions preparation
- Reviewing functionality of Workspace Advanced
- Demo reports creation per VC or Research email on data request.
- Fixed ODS session - s_m_LOAD_UCI_L
- Loading error related to KFS production deployment for table - UCI_LD_A21_PC_JOB_CD_T
- Reviewing loading error on UCI_SMS_FEED_DETAIL.
- Need to adjust mapping remove duplicate records from key columns that make up the clustered index.
In Progress
- Update all ODS worklets to check sessions status = Succeeded.
- SPA COR system reports conversion
- Currently reviewing the stored procs to convert into an ETL process.
- Cognos report design.
- Legacy data warehouse query for Research Administration missing data issue.
- Glenn has implemented a fix to the spa_dwh extract ETL.
- Still missing 4 records (spa: 2096 vs. spa_dwh: 2092)
- Delayed Informatica dev nightly loading schedule to accommodate ODS data validation.
- Schedule needs to be restored and connections changed back to KFSDAY2 once complete.
- Informatica SRAQ.
- Need to schedule meetings with security team.
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).
7/5/2016 - 7/15/2016
Completed
- Annual password change for Informatica - Phase 2
- Cognos Author Active Reports training
- Daily_ODS workflow adjusted to add in an artificial delay for the ldap_people and employee_basic loading.
- DWH UNIX jobs needs to complete before the Informatica process can run.
- SPA reports bug fixed reported by Glenn. Scholarship records were not being included in totals in the SPA stored proc.
- Awards by purpose by campus area
- Awards by purpose by funding source
- Informatica mapping ETL logic adjusted to pre calculate report grouping description.
- All KC Cognos reports adjusted per OR user request. Added in user prompts to filter proposal creation dates.
- Informatica working session with Josh Jackson for COBOL file processing.
In Progress
- OR Cognos reports demo/training sessions preparation
- Reviewing functionality of Workspace Advanced
- Demo reports creation per VC or Research email on data request.
- SPA COR system reports conversion
- Currently reviewing the stored procs to convert into an ETL process.
- Cognos report design.
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-864 - Legacy data warehouse query for Research Administration missing data issue.
- Glenn has implemented a fix to the spa_dwh extract ETL.
- Still missing 4 records (spa: 2096 vs. spa_dwh: 2092)
- Delayed Informatica dev nightly loading schedule to accommodate ODS data validation.
- Schedule needs to be restored and connections changed back to KFSDAY2 once complete.
- SIS developer applicants review.
- Informatica SRAQ.
- Need to schedule meetings with security team.
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).
6/20/2016 - 7/1/2016
Completed
...
- New and Renewal Awards by Funding Agency
- Proposals by Funding Agency
- New and Renewal Proposals by Funding Agency
- Award Totals for Last 10 Years