April 2024: Performance Improvements, Two-Dimensional Array Enhancement and Fixes

Enhancements

Performance Improvements

  • A behind the scenes update to data tables was made to improve performance loading data tables, copying models with data tables and running projections with data tables.
  • Product Aggregate performance improvements have been made to High Performance Mode (HPM) projections to help further reduce runtimes.
  • Improved performance of Core projections with very large arrays.

Two-Dimensional Array Enhancement

Two-dimensional arrays can now be created with a product level data table array and a product output grouping array.

Fixes

  • The ‘Always Calculate’ setting is now staying enabled when the ‘Global’ variable setting is enabled.
  • Switching the static array used in a two-dimensional array is now updating the array value tabs for a formula using the array and set to ‘formula per array value’.
  • When a variable directly references a two-dimensional array there will no longer be an erroneous ‘Invalid Array Aggregation Type’ error message.
  • Using a product data table array in a two-dimensional array will no longer result in a projection error.
  • The Governance module is now detecting different dimensions for two-dimensional arrays.
  • When the result of a complex array lookup cannot be determined in the debug view, we are again showing ‘??????’.