v20261009 (Release)
ยท 3 min read
This release brings significant updates to Detailed Planning, unifying time-based and static measures in a single model. This unlocks the ability to have both time based inputs and calculations supported. Calculation enhancements expand support for additional properties and pramaterization making it easier to deploy more focused calculations. As with most release there have been additional enhancements and fixes across Canvas, Matrix, Export, and the new Cell Classes feature that improve reliability and consistency.
New Features & Major Enhancements ๐โ
Detailed Planningโ
- Detailed Planning models can unifying time-based and static measures in a single model. This unlocks the ability to have both time based inputs and calculations supported. For example, Vendor expenses that are contract based can now be calculated based on their start and end periods while other vendor expenses can be manually adjusted over time.
Model Managementโ
- Model processing now offers fine-grained control โ choose exactly which dimensions or models to reprocess, instead of always reprocessing everything.
Calculationsโ
- Admins can now set up a Calculation once and share it so business users run it with a click. The logic stays locked down and controlled by the admin, so users never need database access of their own.
- Formulas and Calculations can now use dimension member properties, point at neighbouring or specific members with relative and absolute references, and check whether a period is Actual, all directly inside the formula or script.
- Formulas can do more of what Calculations could: common date and string functions, lookups by name or tag (StrToName/StrToTag), and standalone measure references now work as expected (e.g. [Closing] = [@Measure].[Opening] + [@Measure].[New]).
- Formulas that return an empty result can now be suppressed correctly in reports that hide empty rows and columns.
Fixes & Improvements ๐ ๏ธโ
Dimension Securityโ
- Dimension security profile rules can now include the root member making it easier to set rules on the entire dimension.
Matrixโ
- Improved reliability when adding new rows to a matrix.
Cell Classesโ
- Corrected unexpected results and increased preview abilities.
Tableโ
- Dropdown columns linked to a system List now keep their configuration, even when the list's name starts with a lowercase letter.
Form Widgetโ
- Form widgets connected to a table correctly display the selected item's name instead of the raw key after making a selection.
- Locked table columns are now properly enforced in connected form widgets, even when the column uses a list dropdown.
Layout Engineโ
- Fixed several PDF export formatting issues.
Integrationsโ
- Improvemnts to the consistency on how ERP and CRM syns work.