Author: admin

NEW

• We’ve added the concept of data table index “read methods”, which allows for the configuration of how data table rows are read. In this release, we’ve added the “Less Than or Equal” operator, which will match an index during calculation if the index is less than or equal to the value provided.

IMPROVEMENTS

• Drag handles have been added to the headers on tokens within the formula builder to make it more apparent that dragging is supported and to give an alternative to clicking and dragging on the main part of the formula.

• Self referencing variables’ self dependencies are now handled automatically when merging.

FIXES

• The link to input tables from the formula builder has been fixed.
• Empty groupings on the formula builder can no longer be “ungrouped”, creating an invalid formula.
• Fixed an interface issue where some items on the page were still able to be interacted with after activating a menu on the formula builder.
• Data tables are now appropriately updated when merging in input table column changes.
• Fixed a merging issue that caused some variables to have invalid references after merging a new portfolio/product into a model.
• Fixed a model copy error that occurred on some models.

Expanding on our last release, this release focuses on some improvements to the newly available array variables feature, as well as a few other improvements.

NEW

• A new formula type is available allowing users to reference an array index value directly.

• A new system variable is available which allows users to reference the current array index value being calculated during runtime.

IMPROVEMENTS

• Array values are now displayed as their own nodes in the relationship view for array variables, to better display the variable dependencies. Formulas for each index value can be viewed, as well as their dependencies.

• Formulas for array variables can now be copied to specific index values in addition to being able to be applied to all index values at once.

• Improved performance around saving array variable changes at the bottom of a large dependency chain.
• Performance around model import has been improved.
• Minor calculation engine performance improvements.

This release is all about Array Variables! We’ve been working hard to release this feature, which allows even more flexibility and ease of configuration, particularly for variable-type products.

NEW

• Arrays & Array Variables can now be configured and used! Array variables allow users to specify a different formula for different values of an array, and then reference the array variable from other variables. This effectively creates a chain of calculations that iterates on the array values, without having to configure each one throughout the chain. Array value results can also be aggregated or singled out for more complex/flexible calculations.
  
  See our help site documentation here for more detailed information.

IMPROVEMENTS

• We’ve added a bit more context to the error message when an IRR formula fails to calculate properly, so users can more easily troubleshoot any issues.

FIXES

• Fixed an issue when calculating deeply nested IRR formulas that project well beyond the end of the projection with a very specific and uncommon configuration that sometimes generated errors.

This release focuses on some smaller improvements and bug fixes while we work on some larger initiatives behind the scenes. Stay tuned for more soon!

IMPROVEMENTS

• Existing references to old scenario table versions can now be selected when updating projection settings. This allows the updating of settings without changing the scenario table to a new version.
• The ‘Share’ link on dashboards is now also available on dashboards without filters.
• We’ve updated the error message on a failed economic variable rate scenario file read in the calculation engine logs to include the name of the variable rate for easier diagnosis.

FIXES

• Fixed formula builder state issues with deeply nested time indexed variable references within goal seek seed formulas.
• Fixed an issue causing cell selection in the data table editor to require a refresh to work properly after removing rows from the table.
• Saving a variable while the variable list is filtered no longer clears out the filter.
• Fixed an issue where info icon tooltips were sometimes not displaying on formulas.

OPERATIONS

• We’ve upgraded some backend servers with the latest patches to keep performance and security up to date.

NEW

• A new formula that allows Rounding, Floor, and Ceiling calculations is available in the formula builder.

IMPROVEMENTS

• We’ve improved the user feedback in the Execute and Analyze modules when an old scenario file version is being referenced:

• Scenario file records that go beyond the start/end of the projection time are now supported. In addition, it is now possible to reference time periods beyond the end of the scenario (the last scenario record will be used, in this case).
• The model point allocation field on investment files is now validated when setting the file on the product set allocation, to prevent a validation error further downstream in the calculation engine.
• A link is now available when viewing data tables to take users back to the input table structure for that table.
• Product Output Groupings are now included when copying a product.
• IRR calculations will now log an error message if attempting to calculate beyond the terminal time.

FIXES

• Fixed an issue where scenario files could sometimes not be deleted when still referenced by a projection template.
• Fixed an overlay issue when scrolling on the formula builder.

NEW

• The formula builder can now be zoomed in and out using a slider and zoom buttons in the toolbar. This applies to both the edit screen and the relationship view, for ease of viewing longer formulas.

IMPROVEMENTS

• Users can now navigate back to the model details in model development or assumption management using the icon in the upper right, in addition to the existing icon which allows users to switch between development/assumptions.

• The “Welcome to SLOPE” e-mail that users first receive when added to the system has been overhauled with improved formatting and more information/direction about the system, where to find help resources, etc.

• We’ve improved the feedback users receive when hitting their concurrent scenario limit (for user licenses with a concurrent limit).
• Calculation engine performance has been improved.

FIXES

• Fixed a layout issue that sometimes occurred on delete confirmation dialogs.
• Fixed a state issue with the formula builder that sometimes occurred when creating groupings.
• Fixed file import worksheet selection during inline uploading for excel files within upload dialogs.

We are hard at work behind the scenes focusing on some larger initiatives, but in the meantime we hope you enjoy this week’s updates!

NEW

• Notes can now be added to files after they are uploaded in the file manager.

IMPROVEMENTS

• The table editors now support Ctrl + Arrow Key functionality, allowing users to quickly move to the beginning or the end of a row or column within a table.
• Scenario tables can now be included during Model Export and Model Copy.
• “0” and “1” are now valid values for booleans when importing files.
• Assumption Sets are now visible on the Inputs Used tab on the model results page.
• On the model validation details page, items that contain only one child entity are now collapsed to save space.
• Input table structure list is now refreshed after editing a table’s name.

FIXES

• Fixed an issue in some browsers where a login screen was sometimes appearing when duplicating a browser tab in the Results module.
• Fixed an inaccurate validation error message when uploading a new scenario file inline that had the same file name as the existing file.

In this release, we’ve focused on a significant number of “quality of life” improvements that we’ve received as feedback or have noticed internally. We hope you enjoy!

NEW

• Projections can now be deleted in bulk in both the Execute and Analyze areas.

• Specific dashboard results can now be shared via a new button that copies a URL to the clipboard. The link will take a user to the exact dashboard result, including any filters that have been applied.

• A runtime counter now displays during model execution and after completion.

IMPROVEMENTS

• Relationship View improvements:
  • A new link has been added to load the variable editor for a selected variable.
  • Double-clicking a node now loads the relationship view for that variable.
• Variable editor improvements:
  • When filtering variable lists, a filter indicator will now show up showing that a filter is applied. Clicking on the icon will clear any filters.
  • Last modified information is now displayed on variable details.
  • Input table column names are now sorted in the formula builder.
• Projections can now be deleted from their details page.
• Keyboard navigation is now supported within dropdowns in the table editors.
• The Input Tables section in model development has been renamed Table Structures and simplified to focus on table definition editing to enable faster editing while also helping with the conceptual separation of model code vs model assumptions.
• Newly uploaded files in the file manager will now display an “Uploaded On” timestamp as well as the user that uploaded the file.
• Panels in the diff view in Change Management displaying a change to an entity are now collapsible.
• We’ve improved the messaging around goal seek formulas that do not converge.
• Data table descriptions can now be edited.
• Model tags are now copied when copying a model.
• A more appropriate error message is now displayed when a file type cannot be determined during file selection.
• The Model Copy and Model Export views are now sorted.
• Performance improvements have been made in the calculation engine.
• The Initial Premium system model point field has been removed.

FIXES

• Fixed problems that sometimes occurred while parsing delimited flat files during data table import. Column headers are now also case insensitive.
• Fixed an error during projection comparison.
• Switching between a report with filters to one without now properly clears the filters section.

NEW

• Formulas can now be ungrouped in the formula builder via a new icon at the top of any grouping.

• A new “Rolling Value” formula type is available on all variables, which allows users to calculate a moving value (average, min, max, median, sum) of a time indexed variable over time.

• A new option is available on templates/projections that allows users to run variables with no tags in addition to the selected variable tags, if any are applied.

IMPROVEMENTS

• “Sparsely” populated scenario files are now supported, allowing users to carry values forward over time and only specify time indexes where there is a change in value.
• In preparation for future model governance features, Projection Templates have been moved to the Assumption Management module to more easily distinguish model code from model assumptions.
• “Economic Scenarios” section in the Development module has been renamed “Economic Scenario Structure” for clarity of intent.
• File names are now included in the deletion confirmation in the file manager, to help users be sure they selected the right file to delete.
• Dashboard filters are now expanded by default in the reporting module.
• Product aggregation options can now be set during creation in addition to editing.
• Performance improvements have been made around model point file validation.

FIXES

• Pressing the “Return”/”Enter” key while editing constants in the formula builder will now “commit” the changes without removing the formula.
• Fixed a slight flicker when loading pages with tag filter controls.
• Fixed issues with less common file delimiters during parsing in the calculation engine.
• Error messages when parsing investment files in the calculation engine are now propagated to the run logs appropriately so users can more easily troubleshoot.
• Fixed an issue causing company calculations to error inappropriately when relying on a non-output portfolio variable aggregation.

NEW

• Groupings can now be created from existing formulas in the formula builder by selecting the formulas and selecting the grouping icon.

• Variable lists at all levels can now be filtered by tag in addition to name, and the filter control remains fixed at the top of list for ease of use.

IMPROVEMENTS

• Validation errors are now shown properly for “root” level formulas. For example, the date field in the Date Part formula.

• An icon now displays next to variables that are tagged, showing all tags on hover of the icon.

• A new “Re-run” button is available on completed projections which allows users to re-run and replace the results of an existing projection, preventing the need to delete the results later when they are no longer needed.
• Minor interface improvements have been made to the formula builder for ease of use.
• Performance improvements have been made to the interactions with filters and dashboards in the Model Results module.
• Yield curve points and currencies can now be merged in the Change Management module, as well as changes to existing input tables.
• Entities in the merge preview are now sorted within each section by name.
• Scenario files can now be downloaded from the Model Results module on the details view.

FIXES

• Whitespace is now trimmed on either side of data table values on save to prevent parsing issues downstream.
• Fixed an issue where post projection calculations were sometimes not being calculated in dynamic mode if a model point was terminated during processing.

OPERATIONS

• We’ve upgraded versions of some backend technologies we use in order to keep up to date with the latest in performance and security.