September 2020: New File Management, Nested Dynamic Aggregates, and Performance Enhancements!

NEW

New File Management

Greater flexibility. More control. The new file manager allows you to organize your files however you want. Much like a local file system, you can now create folders and sub-folders, and move files and folders wherever you’d like.

Oh my.

Not only does the new interface look slick, it also provides all the existing features as well as drag & drop and search functionality!

File options menu
Folder options menu
New file selection with search and inline file uploads directly into folders.

Present Value – Yield Curve Time

An input for ‘Yield Curve Time’ is now available on Present Value formulas, allowing calculations using the yield curve at times other than the current time.

Dynamic Aggregates

Dynamic aggregates now allow users to specify index names, which enables referencing different indexes from within a nested aggregate.

We don’t know what ‘i’ or ‘j’ are, but by god we’re going to multiply them together and perform an aggregate on the results.

IMPROVEMENTS

Product Output Groupings

To help with performance and clarity, product output groupings will no longer automatically perform a power set of the variables included in the output grouping. Now, each variable must be explicitly defined in the grouping and included in the configuration. To keep existing models/projections unchanged, we have created each permutation of each output grouping that already existed. For example, an output grouping of “Issue Year, Gender” would now be represented by 3 groupings, “Issue Year, Gender”, “Issue Year”, and “Gender”. Multiple groupings can be selected on each product on the projection/template, and unneeded permutations can be left off for performance. In the reporting module, these groupings can be selected to properly filter the results. Please ask your account rep for further information, if necessary.

Tons of Performance Improvements!

We don’t like to wait for things. And neither should you. With that in mind, we’ve made tons of performance improvements this month to make things faster, smoother, and generally ‘snappier’. Some areas we’ve made everyone’s lives better:

  • Model Execution/Model Results: We’ve made some large underlying infrastructure changes that affect both of these modules. What does that mean for you? Well, one day you woke up and your runs were faster and your reports loaded in less time. Sweet. This has a particularly large impact on stochastic/multi-scenario runs and loading reports at the model point level.
  • Calculation Engine: We’ve also improved the processing of product aggregates with and without groupings, in static and dynamic modes, helping performance to a varying degree for nearly all runs.
  • Projections now validate and queue a bit faster.
  • Data table loading performance has also been improved.

Other Improvements

  • Navigating to the model validation details page now forces an update of any validation counts to make sure users have the latest and greatest information.

FIXES

  • Fixed the error message on Cash Before Investment portfolio variable to accurately state that it must be time-indexed.
  • Removed references to ‘Calculate All Variables’ setting which no longer exists.
  • Attempting to run a projection that has already been queued now shows an error.
  • Fixed display issue where filters were sometimes showing up on reports that did not use them.
  • Renaming a projection now updates the reports for that projection.
  • Updated error message when an Annuity Factor formula results in a negative duration to inform the user how to troubleshoot.
  • Fixed an issue with the “apply formula to” feature on array formulas that caused shallow copies of some data to be created, and other data to get out of sync.
  • More complex time formulas within Single Value Formula array aggregates no longer cause errors while processing.