Arrays are a way of representing a list of values that can later be referenced by variables and also used to create array variables that iterate their calculation for each value in the array. The arrays page within model development is where arrays can be added, edited, and deleted.
Array List View. Click “Create” to make a new array or click an existing array to edit it.
There are two types of arrays available, Static and Dynamic.
Static Arrays contain a discrete list of possible values. When creating an using static arrays, only the values defined on the Array configuration screen will be available for use within the array formulas.
Edit Array Dialog Box
Dynamic formulas do not use a pre-defined list of array values. Instead, a dynamic array is defined using a Product Output Grouping. During run time, array indexes will be dynamically determined based on the index values from that specified product output grouping. Thus, the number of array values can change from one run to another based on the underlying data being processed. Because of this, dynamic array formulas can only be defined at the Portfolio and Company levels.