Restoring Aging Snapshot Data in Finance Analytics

Whenever a Full load is executed, all target tables are truncated and reloaded. This can result in missing historical data in Aggregate or Snapshot tables. Once erased, such historical data cannot easily be replaced.

In order to preserve Account Payables (AP) and Account Receivables (AR) Snapshot data from aging invoice tables W_AP_AGING_INVOICE_A and W_AR_AGING_INVOICE_A, OOTB mappings have been created that will copy data to temporary tables at the beginning of a Full load and then restore copied data back into the Snapshot tables once Full load is completed. These mappings will only execute during a Full load.

To enable copy and restore process, the associated parameter RESTORE_AGING_IN_FULL must be set to Y. If you do NOT wish to copy and restore data from the AP or AR invoice Snapshot tables during a Full load, then set the value for this parameter to N (or any value other than Y).

Process to set value of RESTORE_AGING_IN_FULL parameter:

Login to http://<hostname>:9704/biacm and click on manage load plans under tasks

The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

Click on Load Plan

After selecting the load plan click on Data load Parameters tab below

Scroll down in the data load parameters to find parameter RESTORE_AGING_IN_FULL option

Select RESTORE_AGING_IN_FULL parameter assigned to Group Name AP Transaction and click on pencil icon to edit.

Change value to ‘Y’ to enable copy and restore process or ‘N’ to disable.

Similarly change RESTORE_AGING_IN_FULL parameter assigned to Group Name AR Transaction.