Author: Ashley Faherty

New

Export Variable Properties and Formulas for Model Documentation

Users can now extract a list of their variables with the properties, tags, documentation, formula, last modified date and user to provide model documentation for audits, regulators, internal review and troubleshooting. Learn more here.

Multi-Factor Authentication

Slope users can now setup multi-factor authentication (MFA) without having to be on Single Sign On. To configure MFA, click the user menu in the top right of the application > Administration > Privacy and Security tab.

New API Endpoints

• Copy Projection Endpoint: Allows users to copy an existing projection ID instead of having to create a projection template.
• Get Decrement Table Endpoint: Allows users to get the decrement tables on their model including the ID, name, type, improvement year and select period frequency.

Read more about the available Slope API Endpoints here.

Enhancements

Use Annual Effective Rate for Short-Term Interpolation on Scenario Tables

Users can now specify how the short-term spot rates (durations 0-5 months) on scenario tables are calculated. In the past, the short term interpolation method was always from zero. Now users can select to interpolate from zero or use the annual effective rate.

All existing scenario tables will remain set to ‘from zero’ but newly created tables will have ‘Use annual effective rate’ selected by default.

NOTE: This parameter will be added to the Post and Patch Scenario Table endpoints on the API in the future. In the interim, the API will default to using the annual effective rate for the short term interpolation method.

Additional Enhancements

• A model copy performance improvement was made to reduce the time users need to wait for their model to finish copying.
• Only the headers and elements with errors on the validation details screen will show in red to prevent users from thinking there are errors on objects that do not have any errors.
• The model point default value will be used when the column does not exist in the model point file and the field is not required on the model point file definition.

Fixes

• API users will no longer get a 500 error when uploading the same model point filter on two products at once.
• Resolved a ‘No data table found’ error on some projections with long running static products.
• Resolved a ‘Failed to start’ error on projections when the scenario structure does not have any yield curve points on it.
• Resolved a model copy issue that was resulting in the copy hanging when projection templates were included.
• Data table headers are no longer case sensitive on import.
• Extra columns in a file are again being ignored when uploading a data table.

New

High Performance Mode Available for Projections with New Business

High Performance Mode (HPM) now supports projections that include New Business so that users can dynamically issue new sales (model points) in their projection when running in HPM. For more information on High Performance Mode and which projections are supported, visit our support article here.

Enhancements

Variable List Now Shows Error Count

Users will now see an error counter at the top of the variable list to indicate the number of variables that have errors on them.

API Update: GET Projection Endpoint Additions

API users will now be able to get the following portfolio and product information from the GET Projections endpoint:

API Update: GET Data Tables/List Endpoint

API users will now be able to get a list of data tables either for a specific table structure or model ID. Learn more on our API documentation page.

Reporting: Repeat Row Labels

Users can now format pivot tables with multiple pivot rows to repeat row labels within their workbook element.

Reporting: Placeholder Text in Control Elements

Users can now customize the placeholder text for any input-based control elements (List Values, Text Input, Number Input, Date, and Date range) to provide context about the expected input.

Merge Differences in Tags on Variables

The model governance module will now show tag differences between two variables (with the same name) and allow the user to merge the tag to the target variable.

Fixes

• Debug view is now updating the formula with a different formula per array value for the second dimension of 2 dimensional arrays.
• Reduced Failed to Start Errors resulting from AWS request denials.
• Improved run log and debug tab loading performance.
• Again showing ‘Out of Memory’ message when a projection runs out of memory while finishing the inserting of results.
• Model point filters will apply the correct filter field when duplicating a projection and filtering on a field that is not the first field.
• Variables only referenced by a sales allocation variable will again display in the output.
• Now showing the correct result for projections run in Cores when forward projecting a company array variable with a Single Value (formula) aggregate that relies on a two dimensional aggregate variable.

New

Re-Run a Projection with a Different Model

You can now re-run a projection using a new model. This is often done to try and reproduce or compare results after making updates to a model copy. When switching a model, Slope will attempt to map the settings, scenario table, variable scoping controls, portfolios, sales allocations, investment strategies, products and data tables using the name. Learn more here.

Enhancements

Mass Merge Decrement Tables

The governance module now allows users to select multiple or all decrement tables from one model and merge them into another mode.

Miscellaneous

• The target model in the governance module will now show the full name upon hover.

Fixes

• Assumption sets will again allow the user to view and change the table selected in the assumption set.
• Debug view will no longer erroneously show ‘No Result Available’ when a result is available.
• Corrected an issue in which an error message was not providing the correct error source for a Calculated Range where the start and end values were matching.
• Debug view is now showing products that are not directly configured on a portfolio (e.g. investment products)

Enhancements

Performance Improvements

• A behind the scenes update to data tables was made to improve performance loading data tables, copying models with data tables and running projections with data tables.
• Product Aggregate performance improvements have been made to High Performance Mode (HPM) projections to help further reduce runtimes.
• Improved performance of Core projections with very large arrays.

Two-Dimensional Array Enhancement

Two-dimensional arrays can now be created with a product level data table array and a product output grouping array.

Fixes

• The ‘Always Calculate’ setting is now staying enabled when the ‘Global’ variable setting is enabled.
• Switching the static array used in a two-dimensional array is now updating the array value tabs for a formula using the array and set to ‘formula per array value’.
• When a variable directly references a two-dimensional array there will no longer be an erroneous ‘Invalid Array Aggregation Type’ error message.
• Using a product data table array in a two-dimensional array will no longer result in a projection error.
• The Governance module is now detecting different dimensions for two-dimensional arrays.
• When the result of a complex array lookup cannot be determined in the debug view, we are again showing ‘??????’.

New Features

Two-Dimensional Arrays

Two-dimensional arrays allow users to reference values from two different arrays within a single formula. This allows for the use of a single formula to calculate complex logic that varies by two different dimensions. Two-dimensional arrays help reduce the need for duplicated model logic and maintenance.

To learn how to setup and utilize two-dimensional arrays in your model, please review our support documentation here.

Portfolio Level Calculated Range Array Indexes

Calculated Range Array indexes can now be set using portfolio level variables to allow for more flexibility and minimize the need for extra array variables at the model point level.

Enhancements

Validation Updates

The following validation has been added in order to help our customers build and maintain more accurate models. Validation is added to prevent and alert our customers to invalid setups or configuration that could give incorrect or unexpected results.

• Variables that contain the ‘Projection Time Index’ system variable must have the ‘Force Recalc’ setting enabled.
• Cross level variables contained in a formula cannot reference different arrays (e.g. Product Variable formula references another product variable that uses one array as well as another portfolio variable that uses a different array).
• A standard variable cannot reference a post projection variable at another level.
• A non-time indexed variable cannot reference a time-indexed variable at another level.

Fixes

• Projection list loading times have been improved
• When uploading a new version of a file that is being used by an allocation, an error will no longer display.
• Output is now being written when an investment strategy errors after trying to sell more assets than are available.
• Now showing a descriptive error response on the Post Reports API endpoint when a workbook or element is not found

New

Merge New Investment Strategies and Asset Allocations

Slope will now show Asset Allocation and Investment Strategy adds, changes and deletes and will allow clients to merge new Asset Allocations and Investment Strategies from one model to another. This is done using Compare & Merge Models found in the Governance Module.

Surfacing Relevant Support Documentation on Model Development Pages

When you are in the Models module and click the Resource Center (question mark found in the lower right corner of the application) and select the ‘Help Center’ section, you will now find relevant support documentation surfaced. In the next couple of weeks, you will see relevant support content surfaced for all pages of the support application.

Enhancements

Creating a New Table Structure Now Loads the Data Table on Screen

Now when users create a new table structure, give it a name and click save, they will see the table structure loaded on screen so they can immediately beginning editing and adding columns.

Fixes

• The default value rows when a data table is used as a data table array are now being excluded so that the debug view shows the expected result.
• Resolved an issue in which the second instance of a dynamic product was being processed statically.
• Terminated model points are now being filtered from target value match and pro rata investment strategy rules.
• Filtered pro-rata investment strategies will no longer fail when there is a backup sales step.
• The copy model page should now consistently load without requiring a page refresh.
• Images from support documentation are now loading properly within the Resource Center found in the lower right corner of the application.
• Validation will no longer incorrectly force variables referencing non-time indexed variables to be set as time-indexed.
• High Performance Mode post projection variables will no longer fail due to an incorrect missng array value.

New

Mass Merge Product, Portfolio and Company Variables

The Governance module now allows users to merge multiple variables at once so that each variable does not have to be individually merged one at a time. Users can merge select or all variables at the same level (product, portfolio or company). All dependent variables included in the mass merge will be automatically mapped for a more efficient experience.

Model Links in Compare & Merge Models Module

Users can now open the source and target models in a new tab from with the Compare & Merge Models module so they can easily review the details of those models on another tab.

Input Tables on Workbooks

Input tables allow users to incorporate supplemental data into their reports. They allow users to integrate new data points into their analysis and augment existing data to facilitate rapid prototyping, advanced modeling, forecasting, what-if analysis, and more—without overwriting source data or having to incorporate input data into Slope models. 

For more information on incorporating Input Tables in your workbooks, visit our support article here.

Enhancements

• HPM now honors the error limit set on projections.

Fixes

• Model point file definition field names (headers) are now case insensitive for HPM runs.
• Merging a variable change consistently removes indirect array references as appropriate.
• Force recalc variables for dynamically run products are consistently being output for time periods during the projection period.
• Projection time is again being consistently set for force recalc variables for all time periods in the debug view.
• Main variable result is again showing at the top of the debug view when an array value is selected.
• Invalid product range array configuration is being consistently captured by validation.
• Drag and drop is no longer freezing when the user opens the relationship view in another tab while using the formula editor.
• Model point field merges are again successfully being merged.

New

New Formula Option: Dynamically Aggregate Array Values

The formula editor now has an option to take the sum, product, minimum, maximum or average across all array values. Similar to using a SUMIF or other conditional formulas in Excel, this new operand allows for conditional operations or manipulations across the array values.

Change

Changed Validation Error to Warning

Users will now be warned when an Investment Strategy Portfolio variable references a product aggregate with ‘After Investment’ timing set. This is to inform users of potential misconfigurations.

Fixes

• Merge mapping logic has been updated to better handle name changes.
• Updated the Debug View to show all fields for Present Value and Goal Seek formulas.
• User will no longer get an unknown error when merging a variable that does not have an array set in the variable properties of the source model and does have an array set in the variable properties of the target model.
• Resolved a temporary issue resulting in unknown errors on the run logs.

New

Merge Multiple Table Structures and Data Tables at Once

The Governance module now allows users to merge multiple table structures and data tables at once so that each data table and table structure does not have to be individually merged one at a time. All nested table structures included in the mass merge will be automatically mapped for a more efficient merge experience.

In addition to the mass merge capabilities, the merge module now refreshes the items in the left hand panel upon merging to remove the changes that no longer exist between the two models.

In-App Resource Center

The new Resource Center provides integrated support article searching and highlights new features within the Slope Application. Walk throughs and additional onboarding content will be available in the Resource Center in the future.

Enhancements

Copy and Paste Workbook Elements and Worksheets

Workbook elements (tables, visualizations, etc) can no be copied and pasted for easy repurposing and editing. You can also copy and paste worksheets.

Delete Workbook Folders

Folders can now be deleted from My Documents or your account’s workspace from within the Workbooks module.

Export All Elements in a Workbook to Excel

You can now export all elements (tables, visualizations, etc) to a single excel file with the ‘Send Now’ functionality. Each element will be sent in a different worksheet of the same excel file.

Fixes

• Pasting a part of a formula in the editor will no longer clear out the operator.
• Consistently showing the correct variable name in the error message when an aggregate calculation has an empty value.
• Resolved an issue in which a renamed variable was listed multiple times when merging model changes in the Governance module.
• Corrected the headers on the grouped projections view in the Projections module.
• The state of the ‘is required’ property can now be merged in the Governance module.
• Users can now merge model point field change if the alias on target model matches a name change.
• Validation has been added to workflows to notify users that workflows have a limit of running 40 projections at once.
• Large scenario tables should no longer cause projection delays.

New

Monte Carlo Simulation

Slope now offers both a Random Number Generator and Statistical Distribution function in the formula editor so that they can be used to run Monte Carlo Simulation. Slope supports Probability, Cumulative and Inverse Cumulative function types and the following distributions: Beta, Binomial, Exponential, Gamma, Lognormal, Normal and Poisson.

After selecting your desired distribution type, you can use the formula wheel to provide a value, calculation or variable for the additional distribution parameters. When the Random Number Generator is used in combination with the Statistical Distribution function, users can run Monte Carlo simulations to predict a variety of outcomes.

Click here for more information on Monte Carlo simulation in SLOPE.

Enhancements

In App Sorting and Filtering on Data Table Columns

Clients can now sort and filter on data table columns to more easily review, sort and edit data without having to export their table to Excel. Columns with a data type of string, decimal, integer, boolean, date and drop down list can be sorted or filtered.

Sort order updates and ‘clear column’ changes can be saved by using the save button but data value filtering will not persist upon save.

Improved Error Information for High Performance Mode (HPM) Projections

High Performance Mode (HPM) now offers improved error reporting. HPM errors are found on the Run Logs tab and Projection Run Summary on the Workbooks tab. A new ‘Error Report – HPM’ tab on the Projection Run summary will show new columns to provide additional info for troubleshooting. New columns include: variable name that errored, time index that the error occurred, data table and table structure (if the variable was a data table read), portfolio name, product name, model point record # and current array value when applicable. Errors are also grouped by the variable where the error originated.

On the Debug View for HPM projections, ‘Projection Time’ has been added and shows the time period that the projection was processing when the result was calculated. The column formerly called ‘Time’ has been updated to ‘Time of Result’

Easily Filter Workbooks to show Monthly, Quarterly or Annual Results

Workbook data tables and visualizations can now be easily filtered to view monthly, quarterly or annual results using a ‘View By’ control. Instructions on how to setup the control and filter the data are available here.

Changes

• The Operator Control is now integrated into the end of a formula instead of inserted in between two operands to better align with the typical order of operations for creating a formula.
• Non breaking spaces on Data Table Data and Index columns are now being converted to a standard space so they do not result in an error retrieving records at runtime.
• The Bond Equivalent option for Yield Curve Rates will automatically be selected when rates are fetched from the Treasury for scenario generation.

Note: The change to always calculate variables that are non time indexed has been put on hold. This will allow clients an opportunity to update their models to prevent excessive errors on variables or specific model points for a variable that did not need to be calculated. Communication with timelines and model update recommendations will be sent via email to all clients well in advance of this change.

Fixes

• Slope will now return a descriptive error message when there is an invalid nested data table.
• The validation message for an empty table will now be cleared when importing a ‘File Only’ table over top of an empty table.
• The correct time index is again being reported in errors when using a non-default data table.
• A complex array aggregation configuration will no longer result in an unknown error at runtime.
• Calculating a table formula for the first time within a goal seek chain will no longer result in an unknown error at runtime.