Skip to main content

v20260619 (Release)

· 3 min read

This release delivers new capabilities across pivot tables, calculations, MCP, and the workflow engine, alongside significant stability improvements across Canvas, Dimension Roles, and the Global File System.

New Features & Major Enhancements 🚀​

MCP​

  • MCP now supports running and writing model, SQL, dimension, and LID queries directly from connected AI clients.

Calculations​

  • Formula enhancements — the calculation engine has been significantly expanded with new capabilities:
    • Aggregation of dynamic calc results — dependent members are now automatically included in aggregated values
    • Formula scoping — restrict when a formula triggers using the new scope panel
    • Cross-dimensional references — reference members from other dimensions directly in expressions
    • Time shifting — use lag() and lead() to reference prior or following time periods
    • On-demand and automatic execution — formulas can now be run on demand or triggered automatically when dependencies change

See the Formulas documentation for full details.

Pivot Table​

  • Hidden fields are now supported in pivot tables, giving users more control over what is displayed.

Explorer​

  • Users can now rename files directly from the left-side file explorer panel.
  • Large zip imports now show a progress indicator instead of an indefinite spinner, providing visibility into long-running imports.

Matrix​

  • Add Row/Column is now available in the context menu in View Mode, allowing users to add rows or columns without switching to edit mode.

Workflow​

  • Workflow context keys are now available for use in dynamic text fields, without any additional setup required — useful for passing context to activities like the AI Generator.

Fixes & Improvements 🛠️​

Canvas​

  • Model is now changeable in View Mode.
  • Fixed an issue where filter set changes were not saved when the Dashboard model was set to "By Role."
  • Fixed an issue where newly added filters would not appear on the dashboard without "Advanced" configuration setup.
  • Fixed a "No Matching Models" error that appeared when opening a dashboard through the Global File System.

Dimension Roles & Global File System​

  • Fixed an issue where the selected model would not update correctly after enabling Dimension Roles in the model query.
  • "Resolve Roles" action now works to resolve dimension roles and preserve filter links.
  • Fixed {dimension.role} references not resolving when used inside parameter syntax for labels.
  • Users can now set and manage permissions for files and folders in the Global File System.

Matrix​

  • Fixed an issue where entering a value in a cell incorrectly set other empty cells in the row to 0.00.
  • Fixed an issue where drilling down into certain parent nodes in a matrix would not expand to show child members.
  • Fixed dimension role resolution producing hard-coded values instead of filter link syntax.
  • The Line Item Detail (LID) option no longer appears in the context menu when the LID feature has not been enabled.

Multi-dimensional Engine​

  • Fixed V_Notes artificially aggregating with prior YTD periods when the perspective is set to MTD.
  • Fixed writing to leaf members failing when @TimePerspective filter is used with MTD.
  • Fixed an error occurring when using multiple column ranges with a Time Perspective.

Hierarchy Editor​

  • Fixed a whitespace validation error that incorrectly blocked adding child nodes when no whitespace was present.