2018 KFS Org Hierarchy Changes

This wiki page will be used to document all of the work needed to test the KFS org hierarchy changes that will occur in September 2018.

ETL Analysis

Plans

We will use the dss_kfs database to test the org changes on lunar

Need to verify that the table definitions on dss_kfs match dss, update when necessary or drop/create

We will run the workflows as needed manually

The KFS_UCP environment is refreshed from prod every Monday. Keiko manually runs a script to update the orgs after the environment is refreshed.

Austin will manually change the source to KFS_UCP, and change the target to dss_kfs before running the workflows

Copy Cognos Packages, point them to dss_kfs

Copy reports to point to new packages

Modify reports per Matt's spreadsheet

Test all reports, fix problems as needed

How will we test the changes on MySQL and OLTP SQL Server (titania?)

JIRA Issues:

key	summary	type	created	updated	due	assignee	reporter	priority	status	resolution
Unable to locate Jira server for this macro. It may be due to Application Link configuration.