Author: admin

We hope everyone is having a fantastic start to 2020 (and that your end-of-year work is going smoothly!). If one of your new year’s resolutions is to save some time, then we have some updates that just might help!

Check out these features and fixes we’ve rolled out to the SLOPE platform in January! We hope you enjoy them, stay tuned for more soon.

NEW

• Introducing the Option Price Formula! This formula allows users to perform option pricing using the Black-Scholes model and is available under the Utility Functions menu within the Formula Builder.

IMPROVEMENTS

• Compute Environments have been simplified to a dropdown representing the number of CPU cores for each scenario. This should make things easier to understand and directly correlates with how run times are tracked in “core-hours”.

• When duplicating a projection, the default option is now to delete the old results, helping keep the Execution and Results areas of the application clean of old, unneeded results. This option can simply be unchecked to allow retention of the old results.

• Performance has been improved when selecting worksheets within larger excel files.
• Empty strings are now considered valid when importing a model point file.
• An informational icon now explains the purpose of the ‘Number of Points’ input on the Rolling Value calculation.
• Snapshots, Model Copies, and Imports now show the Created By user as the user who performed the action, instead of the original creator of the model.

FIXES

• We fixed some quirks in the interface that sometimes made things hard to click or resulted in an unintuitive state.
• Fixed a navigation bug in Internet Explorer

OPERATIONS

• We’ve made large architectural changes to the underlying data storage components in the reporting module, allowing for better performance, scalability, stability, and security.

New year; new features! This is the last release with features from 2019. We’re looking forward to continuing to roll out great features for our users during 2020. Going forward, we’ll start only sending out these updates monthly to reduce the number of emails you get!

NEW

• Introducing file-only data tables! This feature allows users to add tables beyond the 100,000-row limit by creating a table that reads from a file during calculation engine runtime. The records are only loaded into memory during execution of the projection.

IMPROVEMENTS

• Column read methods are now maintained when importing from a file over top of an existing data table.

FIXES

• Fixed an intermittent error during loading of larger data tables during calculation engine execution.
• Files with a ‘.xlsm’ extension now allow for worksheet selection within the excel workbook.
• Fixed an issue where changes appeared in Change Management for scenario tables between models that had not actually been changed.
• Fixed an intermittent error that occurred when using the Goal Seek function on larger machine sizes.

This release is focused on improving the user experience and system performance around large amounts of data, because no one likes waiting for things to load!

NEW

The file manager and related file upload functionality has been completely overhauled. This change results in faster upload times, an increased file size limit, and new features such as drag & drop, pausing, resuming, and retrying.

IMPROVEMENTS

• Improved data table import performance.
• Data tables up to 100,000 rows can now be imported.
• Significant performance improvements around loading long projection run logs, particularly if a large number of errors were logged.
• The data table editor is now limited to editing the first 1000 rows, to improve the speed of the editor. Users can edit more rows by exporting the table, editing, and re-importing over top of the existing table.

IMPROVEMENTS

• We’ve upgraded some underlying technologies in the calculation engine resulting in some minor performance improvements, increased security, and improved stability.
• When copying a model, the various settings on projection templates are now maintained.

FIXES

• Fixed an issue in the formula builder where certain actions caused multiple formulas to be active at one time, resulting in difficulty interacting with other elements in the formula.
• Fixed an issue causing certain projections to use more memory than necessary when executing within the calculation engine.

Introducing… nested data tables! Now, you can create tables that reference other tables (similar to how nested mortality tables work). This allows for drastically simplified management of certain information.

NEW

Nested Data Tables

• First, a new column type of “Data Table” is available when configuring table structure columns.

• These columns can then be configured to point to individual data tables within the assumption management module using the table editor.

• Now, a new type of variable (product, portfolio, and company) return type is available. Specify a variable with a return type of “Data Table” to make use of a nested table structure. Within this variable, you can return the column value you created in the previous step.

• The last step is to specify the data table variable within a table reference inside the formula builder (the default option will still use the projection table mapping). This allows the calculation engine to determine the data table at run time using the configured nested data tables.

Reporting Module

• The default table visualization has been updated. The original table visualization is still available as “Table (Legacy)”. This feature will be available as of Nov 21st.

IMPROVEMENTS

• Security is of utmost importance here at Slope. As such, we’ve rolled out several back-end changes this release for even further increased security.
• Display precision on variables at all levels is now only shown if the variable is of type ‘Decimal’.
• Models are now sorted by name in the Compare Models and Merge Models interfaces.

We’ve rolled out our rebranded look to the SLOPE platform! We hope you enjoy this modernization to our brand.

As part of our ongoing effort to better support our clients, we’ve also rolled out a live chat feature on the help page. Users can navigate to this page from the User menu in the upper right-hand corner, or by going straight to help.slopesoftware.com. The icon pictured below will appear in the lower right-hand corner and allow users to chat with a SLOPE representative in real-time.

The MetLife Digital Accelerator is still keeping us very busy, but keep your eyes out for more feature releases towards the end of the program. That being said, here are a few fixes for bugs that were brought to our attention recently. We hope these make your lives easier!

FIXES

• Fixed a display issue with the “Variable Tags” field on projections and projection templates causing tags that were no longer on variables to be hidden from view, but the tag was still filtering variables during execution.
• Mortality table dropdown selection now works properly in Firefox when editing data tables.
• Fixed errors caused downstream by changing a table column type from mortality table to something else (such as decimal, integer, etc).

We’ve been hard at work at the MetLife Digital Accelerator, but in the meantime here are a few features and bug fixes that have been actively requested.

NEW

• Variables within an array variable calculation chain can now be changed to have a formula per array value. This allows more flexibility and different logic in different parts of the dependency chain.

FIXES

• Fixed an issue where formulas were sometimes duplicated when moved via drag & drop outside of a grouping.
• Fixed an issue with nested array formulas that sometimes caused unintuitive behavior around which array value was used during calculation.

NEW

• Individual products can now be selected during copy and export of a model to give users more fine grained control of what is copied or exported.
• Arrays and array values can now be merged between models.

IMPROVEMENTS

• Portfolio cash references (before/after investment) are now marked with “t-1” to make it clear that the value referenced is from the end of the previous time period.

FIXES

• Fixed an issue where if a product variable was set as an array variable the product always ran in dynamic calculation mode even if it could have been run in static mode, therefore hurting performance.
• Fixed some issues around copying, merging, and importing models containing array variables.

IMPROVEMENTS

• The current array value is now logged in calculation engine error messages, when calculating array variables.
• Performance has been improved when calculating goal seek functions within array variables.
• Models are now sorted by name across the site.
• Minor performance improvements during page load in the Analyze module.

FIXES

• Input table formulas within aggregate formulas now properly show validation messages when indexes are missing.
• Fixed an error that sometimes occurred after merging a variable with an input table formula referenced within an aggregate formula.