Back-fill History for a New Field

You may add fields to any Data Mart model at any time.   When you do, you will likely want to build data values for past dates (back-fill history).  You build values for back-fill history using Selective Fields.

Before the introduction of Selective Fields in the Eagle solution, any time you built data for a given table, fund and date, you had to build all fields in each row.  This might be a relatively time-consuming process if there were many fields in the model’s table and possible extensions.  Also, rebuilding data for past periods might run counter to your preferences to preserve or “rule off” data values already reported to clients for past periods.

Using Selective Fields, you may choose to build as few as a single field in a model.  This may be a new field or an overwrite of an existing field.  You can completely bypass model extensions that do not contain any fields you want to build, which saves time.  There is complete flexibility with respect to field selection.

Regardless of your release, to back-fill data you should use the manual or ad hoc submission process that you access with the Submit link in Manage Mart and take advantage of the date-range approach to specifying a series of effective dates covering the time interval for back-filling.