1. Cash Flow Engine Reference Guide
  2. Consolidation of Results
  3. Two Approaches to Consolidating Results
  4. Columns in the Result Detail Table

4.3.1 Columns in the Result Detail Table

There are three categories of columns in the Result Detail table:

  • Dimension Columns: Always include these columns in your group-by statement.
  • Result Columns: These columns should always be summed.
  • Other Columns: These columns are irrelevant to the results, but must be included in the consolidation table or view for reporting to function properly.

If you want to use a more efficient method for physically consolidating data, create a SQL Statement that groups by the Dimension columns, sums the Result columns, and Defaults the other columns. This approach saves space over the simple approach of appending the results from all detailed ALM Processing Rules.