Using ADB Incremental Calculations

The ADB Calculation process (GL_ADB_CALCX) supports these optimizing features:

• Incremental calculations to compute the average daily balance.

  This method leverages prior period aggregate and ending balances to calculate the requested period average. All adjustments are automatically applied to the average balances before calculation of the requested period averages.

• Nonshared tables to process temporary data, including the tree selector tables.

• Archiving ledger data.

  This includes the ADB ledger and the ADB target ledger which holds the calculated averages.

  Other ways that the ADB Calculation process supports system optimization is that it enables customers to:

• Filter transactions posted the ADB ledger to control the volume of data.

• Partition the calculated averages to different target ledgers.

The process also enables the customer to specify a calendar ID to the target ledger. For example, customers can specify a monthly calendar to store the MTD balances.