Month: July 2021

Posted on

July 2021: Is Empty Formula, NY7 Integrated Scenario Generation + More

NEW

New Formula: Is Empty

A new formula is available in the formula builder, which allows users to check for an empty/blank value. The formula returns a boolean true/false value.

The new option is available in the Utility Functions sub-menu.
Example usage to detect if a model point’s plan code is empty. Use this within a condition block to perform different behaviors given the existence of a value.

New York 7 Scenario Generator

Users can now generate NY7 scenarios directly within the SLOPE application!

New “Generate” option available in the Scenario Tables area within Assumption Management.
Generator inputs. The result of the generation will be a full scenario table with an associated file.

Scenario Files – Support for Yield Curve Spot Rates

We’ve added support for users to supply Spot Rates in their scenario files. This new option is available under the “Rate Type” control on the economic scenario structure configuration within Model Development.

Application Programming Interface (API)

We’ve improved granularity and control over file management within the API.

IMPROVEMENTS

  • Projection validation now runs asynchronously, which allows the page to load more quickly and users to track the validation process.
  • Nested data tables now contain links in the latest version of the table in addition to historical versions of the table.
  • Performance improvements around backend validation processes.
  • Improvements have been made around caching of front-end code for performance and stability.

FIXES

  • Fixed an issue where product aggregate level results were sometimes unavailable for statically run products.
  • Deleting a column now properly updates newly versioned tables that were versioned as a result of the change.
  • Fixed ability to add new rows in the table editor to tables that contained nested mortality tables.
  • Missing model point files on allocations are now caught by projection validation.
  • Changing the product when editing a projection product no longer results in an error.
  • Fixed downstream issues caused by converting Sell steps to Buy steps and not clearing the rule filters.
  • Array variables can now be referenced from withing the ‘Default Value’ formula configured within IRR calculations without causing errors.
  • Range Arrays can now be properly merged via the UI.