Data Table Arrays allow users to create dynamic arrays that are indexed by unique values from a data table which can be specified at runtime or using a variable. There are many applications for using Data Table Arrays but a common use case is to pull an array index made up of the reinsurers for a product type or plan code.
Data Table arrays use a Data Table variable as their source. The Data Table array source variable must meet the following criteria:
- Be a product level variable (at this time)
- Has ‘Data Table’ selected as the Data Type in the variable properties
- The Table Structure selected on the variable properties has a single index column
- Is not Time Indexed
Here is an example of a variable that is going to return a Reinsurance Table based upon the Plan Code for a given model point. We are using this variable as the source for our array.
Looking at the Plan Code table, we see that different reinsurance tables are applied to different Plan Codes.
Reviewing the projection results by looking at the model point details, shows that different model points have different array values based upon the plan code specified on the model point.
In this example, Model Point #1 with Plan Code X is pulling the Reinsurance Array values from the 2020 Reinsurers table.
Shown below, Model Point #2 with Plan Code Z is pulling the Reinsurance Array values from the 2021 Reinsurers table.
Aggregating Array Values at the Portfolio and Company Level
To aggregate the array values at the Portfolio or Company level you must first select a Model Point Aggregation Method on a product variable that is referencing the array.
In our example we set an aggregation method of Sum on the Reinsurance Amount multiplied by the Market Value.
We can now reference this product variable within the formula of a portfolio variable to aggregate the Reinsurance Amount across the reinsurers at the portfolio level.
Looking at the Portfolio Variable results we see the reinsurance amounts summed across the different array values across the products included within the portfolio.