1. Cash Flow Engine Reference Guide
  2. Consolidation of Results
  3. Create a new ALM Process Rule for your Consolidated Results
  4. Consolidate Results Data
  5. Detail Results Tables (Cash Flow and Gap Results)

4.2.2.1 Detail Results Tables (Cash Flow and Gap Results)

  • All ALM Processing Runs have an associated table for the storage of detailed results. A few key characteristics of these tables which are important to understand when consolidating results:
  • There are 240 columns used to store forecast information BUCKET_001... BUCKET_240.
  • The meaning in any of the BUCKET columns is determined by the dimension columns (listed as follows). In other words, the same column is used to store any type of financial information - you must interpret the key columns to determine what the value represents.
  • All information can be consolidated by simply summing up the Bucket columns. The numbers are stored so that for weighted average purposes you need only to sum up the values and group by the relevant key columns.