Backfilling cubes from archive

By default, the reload action clears all cube data and reloads only active records. The backfill action is used to load archived data into cubes automatically during reloads or manually when needed. This action only needs to be run after a reload or when new data is added to the archive.

The backfill action is enabled by default, but you can disable it by setting the configuration parameter with these details:
  • Component: Analytics
  • Parameter name: EnableCubeBackfill
  • Value: False
Note: To run the backfill action, ensure that EnableArchiving and EnableArchivable parameters are enabled.
  1. In the Administration Console, select Analytics.
  2. To configure a cube to enable the backfill action:
    1. Double-click the cube to update.
    2. Select the Enable Backfill check box.
  3. To configure a cube to automatically backfill from the archive data each time a cube reload runs:
    1. Double-click the cube to update.
    2. Select the Auto Backfill check box.
  4. To manually run backfill only when needed:
    1. Right-click the cube to update.
    2. Select Backfill.
    Note: To protect cube integrity, the system prevents reload, refresh, and backfill actions from running simultaneously on the same cube.