Increment Summary Version

OVERVIEW:

  • Generate Summary Tables – “Production Version”

PROCESS:

  1. Insert a new ‘fm.Summary_Version’ entry with ‘is_live’ = True 
    insert into fm.summary_version (version, Last_updated, is_live, Note) values ('',getdate(), 1, '');
  2. Update config ‘fm.summary.DbVersion’. 
     update config set value = '', note = '', updated = getdate() where component = 'fm.summary';
  3. Generate Summary Tables 
     exec fm.usp_update_Summary_Historical_All;

NOTES:

Updating the GSI is not needed since it will happen in a forthcoming step soon.

History

Leave a Reply