Skip to Content

Change log

Version 1.1.4

Visual improvements

  • Hide "Dimensions" and "Master Dimensions" in Validate summary templates if no column is selected with these settings
  • Hide "New dimensions" in summary templates for Lookup and Breakdown
  • In zoomed out mode, nodes in error state show a red border with red semi-transparent background

Fixes

  • Creating a new Excel Table, which triggers creation of an ExcelInputValidate node, now triggers an initial data load
  • "New Dimensions" summary text in Lookup and Breakdown now refresh on node run
  • If a temp sheet name conflicts with an existing sheet, it chooses a non-conflicting name

Version 1.1.3

Features

  • Undo/Redo functionality, currently limited to model map actions.
    • Covers adding, deleting, moving components, resizing groups, adding/removing connections, and editing group comments/headers.
    • Undo/Redo buttons in the ribbon.
  • Added export map to PDF functionality accessible from the ribbon, display the full map details even if zoomed out
  • Updated components
    • Unpivot: category column is automatically a dimension
    • Scenarios: clicking the Scenarios button in the ribbon opens the Scenarios panel, even if the component is not selected in the model map
    • Formula: upgrade formula edit boxes with syntax highlighting, auto-complete column names with auto-quoting, error highlighting, and explicit save/cancel and buttons better documentation
  • New components
    • Combine scenarios: runs the model once for each scenario and assemple all versions of a table with a union.
    • Forecast horizon: adds a forecast horizon column to a time series table and adds base values for the whole period.
    • Excel Input Validate: combines Excel Input and Validate in a single component, with columns selected by default.

Bug Fixes

  • Union: output columns are now properly set based on the result of the union operation.
  • In some cases, reloading a model from file didn't reconnect some Excel Tables properly.
  • Deactivated auto-selection of column in Validate (when clicking the dimension checkbox) and Assumptions (when clicking Assumption or Set point checkboxes) to avoid issues when reloading a model from file.
  • Data quality checks on column names with special characters are now working.
  • Each component now triggers a full calculation (a SELECT in the database) so that all errors are now propagated to the UI (at the cost of slightly slower speed).

Visual Improvements

  • Temporary sheets reset view to top left when opened.
  • Display zoomed out node in red if error, otherwise display node category color as in footer if zoomed in.