News and Announcements

MODLR Excel Add-In Workview Validations (Experimental) When enabled in the Options menu, Workviews that define basic validations will now display those validations as dropdown lists directly inside Excel for easier and more accurate data entry. Handling of Invalid Workview Names Workview names containing characters that Excel does not allow in worksheet names will no longer prevent the Workview from loading. Names are now automatically sanitized while preserving uniqueness. Resolved Ambiguous Element Issues Workviews that previously failed to apply CubeGet formulas due to elements named the same in both columns and row headers should now process correctly without stopping the refresh. Live Workview Auto-Refresh on Selection...

MODLR Excel Add-In Stripping Formulas will fallback to stripping individual rows or cells if there is not enough memory to strip the entire worksheet in one go. Fixed loading MODLR workviews with names longer then 31 characters. Select function will work on merged cells Refresh worksheet/workbook shortcuts (CTRL+SHIFT+R, CTRL+SHIFT+W) Correct hierarchy should be used when expanding elements on live workviews. You can download the latest version of the MODLR Excel Add-In [here]

MODLR Gateway v5.3.0 Date: 1st September 2025 This is the developer portal for designing models, reports and dashboards. For some of the functions to become available a server upgrade is required. Features: [New] Process Secrets We have added the ability to create secrets that can be used within processes, this prevents sensitive values from showing through-out Gateway, the value is set and cannot be seen again. Great for API tokens for example. [New] Webhooks The ability to create scriptable webhooks, this allows for external applications to notify your MODLR instance of events. [New] Card Styles Server wide styled components. This allows you to create specific styles then apply them quickly to elements inside your cards, keeping...

MODLR Excel Add-In AliasSet formula function to be able to update alias' in a similar way that you can update cube values with excel formulas. Rewording of CubeSend popup message when refreshing a workbook/worksheet to also alert for AliasSet functions Fixed potential issue that on rare occasion caused excel to freeze after a worksheet/workbook refresh. Fixed an issue where exporting cards to a worksheet would not work You can download the latest version of the MODLR Excel Add-In [here]

MODLR Excel Add-in - Documentation, Download Update Date: 16th Nov 2020 Update Listing Instance Version: 2.4.908 - Workviews containing sets with overridden labels revert to the element names so the workview exports correctly. Instance Version: 2.4.908 - Workviews referencing multiple cubes export correctly. Bug Fix - Copy Hierarchy Delimiter and Delta Symbol buttons were not working under all circumstances. Bug Fix - With some instance versions writeback was failing. This has been fixed. Bug Fix - In some instances exporting a workview with stacked dimensions the resulting worksheet would not refresh correctly.