October 2022: Slope Academy, Workbook and Debug Improvements

New

Slope Academy

Slope Academy is your newest resource for platform learning. Courses for new learners and seasoned users alike will regularly be developed and available to deepen knowledge, improve model efficiency, and accelerate onboarding.

Slope Academy can be accessed from within the Slope application by clicking the ? icon in the top right corner and selecting “Academy”.

Debug Tab in the Execute & Analyze Modules

The Debug view can now be accessed directly from within the Execute and Analyze modules without needing to click on a result in a workbook or dashboard. Within the Debug tab, you can select a level, additional inputs and then a variable to begin reviewing your calculations.

Enhancements

Reporting Improvements

Workbook visualizations now have an option to include trend lines to highlight and predict patterns across multiple values in a set of data.

There are three new functions for calculating subtotals and percentages of totals in workbook pivot tables and visualizations.

  • PercentOFTotal returns the percent of total for an aggregate formula
  • SubTotal returns the subtotal for an aggregate formula
  • GrandTotal returns the grand total for an aggregate formula

REPORTING REMINDER: Looker dashboards are no longer editable and all new reports must be created in the Workbooks tab. Dashboards will be removed from the platform on December 31, 2022. Please check out our support site or reach out to your Account Rep or our support team at support@slopesoftware.com if you need training.

Variable Sidebar Updates

The variable sidebar has been updated so that it reflects changes to variables (e.g. adding a tag) without requiring a refresh of the page.

Miscellaneous Updates

  • Added the word “Projection” next to the Delete action so that it is clear this action deletes a projection and not a workbook or dashboard.
  • Added validation for non time indexed range array variables that use a time indexed variable to prevent errors.
  • Arrays can now be switched from Dynamic to Static and Static to Dynamic. Users will be provided with warnings that list impacted variables when making the array change.
  • Data Table importing via the Slope interface and API is no longer case sensitive when reading headers.

Fixes

  • Fixed the Debug url so it does not break when there is an “&” or “=” in a variable name.
  • Calculated Range Array variables will no longer show a result of 0 when the projection product name does not match the product definition name.
  • Copies of copy only models will be visible to the user making the copy.
  • Fixed table links in the Debug view to render a full html version of the data table instead of a text version of the site.
  • Resolved in an issue in the debug view in which a “no results available” message showed for certain variables that had results calculated.
  • Run logs are now available when a multi-scenario run hits the validation stage.
  • Negative values can now be entered in the time input on the debug view.
  • The formula builder’s drag and drop capabilities will no longer create invalid formula structures.
  • Projections that have corrected validation errors can now be run via the API.
  • The error message when a user clicks on a deleted object has been updated.
  • We are now reporting the proper variable time period in the Run Logs when a variable in a PV formula fails at a future time period.
  • We are now preventing data table columns of “Data Table” from saving without a table structure associated.