Page Comparison

12/3013/2017 - 2/1024/2017

Completed

• New awards by purpose Cognos report complete.
• Code review for all PURAP TEM objects for production deployment.
• UCLA Informatica object import for UCPath. Shared Additional fact table for KC Negotiation star completed.
• Informatica workflow updated.
• Cognos framework package updated with new star schema grouping updated.
• OR data warehouse related tables migrated to Solar for OIR to access.
• Common award dimension feasibility analysis. 
  • SPA/KFS GAP analysis.
  • Accounting will have Janine create a separate award dimension.
  • Will revisit at a later date.
• Aiding the Middleware team in configuring/troubleshooting Informatica LDAP loading workflows.
  • Connectivity issue to ldap-dev resolved.  Issue related to TLS setting in addition to port setting on the Informatica connection object.
• JIRA's 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-1611

• Service-now incidents completed:
• INC0146378
  

In Progress

• SPA awards dimensional model design
  • Dimensional modeling
  • Informatica mapping design
  • Cognos Framework model design.
• Informatica session statistics auditing capability survey for COMPASS workflows.
  • Designing POCs for several different design approaches. 
• KC proposal dimension daily loading mapping design.
• Clinical trials Cognos report for OR (On hold) 
  • Need additional fields in the proposal ODS table.
  • ETL and Cognos framework package needs to be adjusted.
• New OR dev and prod database migration.
• All Informatica/Cognos connections need to be changed.
• Firewall rules for production.
• Connectivity testing for production. 
• Zena Agent install on etl-dev.
  • Waiting on firewall exceptions to be completed by the security team.

Planned

• Informatica SRAQ.

1/30/2017 - 2/10/2017

Completed

• New awards by purpose Cognos report complete.
• Code review for all PURAP TEM objects for production deployment.
• UCLA Informatica object import for UCPath. 
  • Shared folders created for all source, target, and transformations. 
• Informatica developer training prep work complete.
  • Confirmed for 3/6-3/9 @AIRB1020
• Presentation slides prep work for OIR DW information session.
• JIRA's 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-1596

• Service-now incidents completed:
• INC0141357
•  INC0145432
• REQ0012856
• REQ0012926

In Progress

• Additional fact table creation for KC Negotiation star.
• Aiding the Middleware team in configuring/troubleshooting Informatica LDAP loading workflows.
  • Also migrating/testing connectivity to new ldap-dev server.
• Clinical trials Cognos report for OR (On hold) 
  • Need additional fields in the proposal ODS table.
  • ETL and Cognos framework package needs to be adjusted.
• New OR dev and prod database migration.
• All Informatica/Cognos connections need to be changed.
• Firewall rules for production.
• Connectivity testing for production. 
• Zena Agent install on etl-dev.
  • Waiting on firewall exceptions to be completed by the security team.

...

• UCLC Training
  • Sexual Harassment Prevention
  • Cyber Security Awareness
• Awards by purpose Cognos report for 2015-2017 fiscal years
• Awards by sponsor by school Cognos report for Q1 2017.
• Code Review for OIR Compass ETL.
• Daily GL dev nightly loading changed back to KFSDAY2.
• ETL data flow overview meeting for OIR reporting team.
• SISDEV connectivity from Informatica.
  • stunnel setup complete.
  • ODBC source setup and testing complete on etl-dev.
• JIRA's 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-1573

• 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-1579

• 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-1580

• 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-1587

• Service-now incidents completed:
• INC0139201
• INC0139206
• INC0140907
• INC0140906
• INC0140557
• INC0142722

In Progress

• UCLA Informatica object import UCPath.
  • Need to create shared folders. 
• Informatica developer training proposal prep work.
  • AIRB training room requested for (3/6-3/9)
  • Received adjusted price quote for Level 1 Developer course.
  • Received customization confirmation from Informatica University.
• Clinical trials Cognos report for OR (On hold) 
  • Need additional fields in the proposal ODS table.
  • ETL and Cognos framework package needs to be adjusted.
• New OR dev and prod database migration.
• All Informatica/Cognos connections need to be changed.
• Firewall rules for production.
• Connectivity testing for production. 
• TEM data mart development code review and deployment prep work.
• Zena Agent install on etl-dev.
  • Waiting on firewall exceptions to be completed by the security team.

...