Release Notes
The following page lists new features and any general improvements added to Anaplan XL Reporting (formerly FluenceXL). The product was rebranded Anaplan XL Reporting in the October 24 release.
From version 2502.1 the release notes will move to the Anapedia community page Release Notes Anapedia
Contents
[hide]- 1 V2502.1 - March 14, 2025
- 2 V2501.1 - Jan 30, 2025
- 3 V2412.1 - Jan 17, 2025
- 4 V2411.1 - Nov 18, 2024
- 5 V2410.1 - Oct 11, 2024
- 6 V2409.1 - Oct 2, 2024
- 7 V2408.1 - internal
- 8 V2407.1 - July 15, 2024
- 9 V2406.1 - June 21, 2024
- 10 V2405.1 - May 13, 2024
- 11 V2404.1 - April 16, 2024
- 12 V2403.1 - March 14, 2024
- 13 V2402.1 - Feb 16, 2024
- 14 V2312.1
- 15 V2311.1
- 16 V2310.1
- 17 V2309.1
- 18 V2308.1
- 19 V2307.1
- 20 V2306.1
- 21 V2305.1
- 22 V2304.2
- 23 V2304.1
- 24 V10
- 24.1 v10.0.157
- 24.2 v10.0.156
- 24.3 v10.0.155
- 24.4 v10.0.154
- 24.5 v10.0.153
- 24.6 v10.0.152
- 24.7 v10.0.151
- 24.8 v10.0.150
- 24.9 v10.0.149
- 24.10 v10.0.148
- 24.11 v10.0.147
- 24.12 v10.0.146
- 24.13 v10.0.144
- 24.14 v10.0.138
- 24.15 v10.0.137
- 24.16 v10.0.136
- 24.17 v10.0.135
- 24.18 v10.0.133
- 24.19 v10.0.132
- 24.20 v10.0.131
- 24.21 v10.0.130
- 24.22 v10.0.129
- 24.23 v10.0.128
- 24.24 v10.0.126
- 24.25 v10.0.125
- 24.26 v10.0.124
- 24.27 v10.0.123
- 24.28 v10.0.122
- 24.29 v10.0.121
- 24.30 v10.0.118
- 24.31 v10.0.117
- 24.32 v10.0.116
- 24.33 v10.0.115
- 24.34 v10.0.114
- 24.35 v10.0.113
- 24.36 v10.0.112
- 24.37 v10.0.111
- 24.38 v10.0.110
- 24.39 v10.0.109
- 24.40 v10.0.107
- 24.41 v10.0.106
- 24.42 v10.0.105
- 24.43 v10.0.104
- 24.44 v10.0.103
- 24.45 v10.0.101
- 24.46 V10.0.98
- 24.47 V10.0.96
- 24.48 v10.0.94
- 24.49 v10.0.93
- 24.50 v10.0.91
- 24.51 v10.0.87
- 24.52 v10.0.81
- 24.53 V10.0.79
- 24.54 v10.0.75
- 24.55 v10.0.62
- 24.56 V10.0.60
- 24.57 V10.0.57
- 24.58 V10.0.56
- 24.59 V10.0.55
- 24.60 V10.0.51
- 24.61 V10.0.49
- 24.62 V10.0.47
- 24.63 V10.0.46
- 24.64 V10.0.35
- 24.65 v10.0.34
- 24.66 V10.0.32
- 24.67 V10.0.31
- 24.68 V10.0.28
V2502.1 - March 14, 2025
Release notes have moved to Release Notes Anapedia
- Add copy Report in Excel publication form
- Tabular designer - add support for display folders
- Tabular designer - Add tooltips
- Tabular designer - add Shift+click support for multi-select
- Allow relational writeback to use an existing workbook connection
- Add "suppress zeros" function for DAX tables
- Add Pick button in advanced member search for multi-step search
- Add a new comment from a comment frame
- Support for Freeform Reports on Web
- Add Query Optimization Type setting for consolidation
- Performance improvement for Anaplan cube picker
- Support for all Anaplan data environments
- Change Incorta access to deal with new api result format
- Updated Dutch translations
V2501.1 - Jan 30, 2025
- Only load members of selected column in DAX designer
- Advanced Search form added to Standalone Member selector
- Integrate feature flag feature enablement
- Resolve Workbook slicers can cause grids to refresh twice
- Anaplan login change
- Handle Line items date format issue in charts
- Bubble ring chart Web: fade out when selected
- Pick folder of measures and add all to selections
- Reverse indentation style option
- Copy-paste members directly to Member Selector
V2412.1 - Jan 17, 2025
- Support Freeform reports in propagate
- Rename FluenceXL Workbook Slicers
- Disable convert grid to formula if column/row members are hidden
- Allow max number of writeback cells to be configured
- Anaplan style for default Grid format
- Update Dropdown menu hover color
- Update several legacy icons
- Improve ok/cancel button UI
- Improve handling of 'Initial Value' check on Anaplan batch writeback
- Reduce number of calls to get workspace when loading Anaplan workbooks
- Bottom up Hierarchy Selections for freeform (lowest minus x)
- Bottom up Hierarchy Selections for Grids (lowest minus x)
- Update Close & Consolidation drillback to a new row for each entry
- XL Web - csv output option for Scheduler
- Add support for XL3RunSqlProc on Fluence / Consolidation connection
- Avoid flicker in member selector
- Disable actions where not supported on connection type
- Resolve error with Multisheet print
- Insert property form doesn't allow picking a member in some scenarios
- Resolve Freeform conversion error if number members in merged cells
V2411.1 - Nov 18, 2024
- Show as captions option added to Custom calculations screen
- Speedup Anaplan Connection dialog, delay load
- Improved token refresh handling for Anaplan and Atoti
- Anaplan writeback support for dates
- Default writeback to off on new Grids
- Prevent display of list item dropdown on read only cells
- Default formatting updates for writeable and written members
- Improved handling of dimension metadata changes in Anaplan
- Snowflake SSO support
- Updated French translations
- Support for Microsoft Sensitivity Labels and IRM (Information Rights Management)
- Re-design portal to Anaplan Styling
- Ability to set auto refresh in seconds
- Schedule explorer now shows folder path in breadcrumb
- Web highlight Color set to match primary color
- Various Minor UI Improvements
- Scheduling Support for Atoti
- Fix scenario where waterfall chart loses selections
- Fix to ensure Right click / Ribbon keep option in synch
- Fix for user tagging in comments
- Fix for pasting XL3Lookup as Values
- Fix for Custom named Sets on Atoti
- Various Minor Improvements and fixes
V2410.1 - Oct 11, 2024
- Anaplan connections: check if XL3LookupRW and enable workbook writeback
- 'Zoom Out' for Grids
- Toggle between MemberName and Selected Alias for Freeform Reports
- Show aliases in filter section of Grid
- Member picker should retain Alias view after it has been closed & re-opened (freeform)
- Suppress Zeros shortcut to be added to toolbar (freeform)
- Member properties not displayed in grid (Anaplan connection)
- Validate members disabled when reports are downloaded as live
- Error opening file on the Web
- Option to display Base Name instead of Name
- Convert empty grid to freeform and suppressing nulls causes error
- Scheduling a pivot view errors
- Improve Kyvos logging
- Web: Default to use new portal
V2409.1 - Oct 2, 2024
- Rebrand to Anaplan XL
- Improved Anaplan Connection UI
- New UI: Minor updates and improvements
- Updated Japanese translations
- Oauth SSO support for Atoti
- XL Web now supports SSO connection to Anaplan
- Speed up formatting of large writable member areas
- Improved Support for Booleans in MDX Calcs
- Add text support to Filters
- Atoti mdx change for drilldown
- Custom Calculation Support for AtScale Connection
- Ability to toggle booleans in grids with a click to writeback
- Anaplan connection screen option for currently used cubes(modules) only
- Check licenced connection types in Excel
- Member selector - remove members by dragging them to the left
- Enable set command timeout for Atoti
- Disable anaplan modules with no data or too large dimensions, per API restrictions
- Disable writeback setting (Product Key level)
- Support for Freeform reports on Essbase
- Marimeko Chart improvements (including reference line)
- Various Security updates and fixes
- Fixed: Convert to freeform errors on non-cube members
- Fixed: Anaplan MDX wizard doesn't use YTD() function
- Fixed: Writeback hierarchies duplicated in UI
- Fixed: Dashboard title static on web
- Fixed: Anaplan writeback boolean errors
- Fixed: Scheduling UI fixes / improvements
- Fixed: Anaplan waterfall charts error
- Fixed: Freeform pick members incorrect on first open
- Fixed: Custom calcs screen doesn't show measure groups or display folders
- Fixed: Freeform conversion on grid with hidden areas fails
- Fixed: Other stability improvements
V2408.1 - internal
- (internal)
V2407.1 - July 15, 2024
- Add new scheduling UI to Excel
- Various security updates and fixes
- New UI improvements and fixes
- Anaplan: integration improvements and fixes
- Freeform support for member properties
- Fixed: Schedule doesn't work with distribution list/group
- Fixed: Can't change locale in reports sent via scheduling
- Fixed: Small multiple non-empty toggle icons don't change
- Add SharePoint to External source types
- Outline default format allow setting border style
- Atoti: XL3Member formulae support captions
- Support Anaplan line items styles
- Embedded workbook: support merged ranges
- SQL table merging doesn't work correctly when header is hidden
- Remove need for Access 2010 installation by using FluenceXL csv driver instead
- Sign all DLLs and EXEs
- Add support for SSAS azure link:// servers
- Rotated cells render incorrectly on high dpi displays
- Disabled schedules can be executed
- Adding dynamic chart on cube with no time hierarchy gives an error
- Conditional formats with Row() in criteria can be rendered incorrectly.
V2406.1 - June 21, 2024
- Manage Scheduling available in Web portal
- Web portal - option to display the report full screen
- New UI: Updates and Fixes
- Security updates
- Fix: Pager not copied to new sheet
- Incorrect number formatting on web when mdx calc returns -0.0
- Refactor alias resolution to happen in mdx generation
- Fix Textbox font size when using fractions
- Proxy: Relational connections request reauthentication on invalid query
- Multisheet save to Excel fails when no sheets are selected
- Web report tabs - show ellipsis if name is cut off & improve tooltip
- Anaplan - support formulae writeback
- Column headers not right aligned on the Web
- Error displaying custom calculations form when connection has been deleted
- Fixed: SAP HANA hierarchies can have blank captions
- App Service - Allow setting witch Claim to use for username & email
- Scheduling: enable connecting to Anaplan for embedded scheduler
- Conditional format does not override accounting format layout on web
- Kpis on Atoti create duplicate measures
- Complex send to: doubling output
- Fixed: Invalid UniqueName on grid calculations
- Freeform allow setting output to caption/key/un if validating
- Add table filter does not work through grid designer
- Table Filter does not work on Anaplan/Fluence/etc
V2405.1 - May 13, 2024
- Ability to bring data and named ranges from external workbooks
- New UI - improvements and fixes
- General security updates and fixes
- Complex "Send to" layouts
- Variance charts input children if you select the member twice
- Anaplan freestyle doesn't fill blank members
- Fixed: Error when changing connection in Template Table Editor
- Regional settings English Belgium - xl3link triggers SQL statement but doesn't reset cell reference
- Member property display issue when removing member
- Use "Display Property" in member selector automatically
- Powerpoint export: Excel chart/axis title containing a formula not displayed
- Freeform auto pick alias if grid configure for them
- Powerpoint export: hidden columns are displayed in PowerPoint export
- Anaplan errors on dates and certain blanks
- Dynamic charts can error on web when syncing plots with null data
- Multisheet template scheduling support
- Member props not returned when empty member as mdx values
- Update Dutch translations
- Freeform enhancements
- Atoti can double validate member aliases
- Atoti member caption validation should be for all hierarchies
- Maintain natural column order when doing a Fluence Drillback
V2404.1 - April 16, 2024
- Expanded New UI to client calculations
- New UI: Fixes and updates
- Option to auto log out user on after inactivity
- Encryption of connection string in the connection mapping XML file
- Improved null cell handling for Anaplan / Polaris
- Freeform reports do not support member properties
- Freeform mode: Add support for Aliases
- Chart is overwritten by the last used slicer values
- Formulae can't drill on formula that use a caption with spaces
- Anaplan freestyle doesn't fill blank members
- Apply format sheet row heights: Error when changing member selections -2 members only
- Proxy client error fixes
- Bar chart axis matching can miss in Excel
- Enable replace 0 with null for Kyvos
- Update Japanese translations
- Fixed: Powershell - add-xl3report doesn't import images
- Update Dutch translations
- XL3Comments don't support multi-byte filename attachments
- Improved Proxy server logging
- "Create powerpoint chart" - not showing latest data
- Comments can error when user deleted
- SQL Admin: web.config error when installed on non-server computer
- ImpersonateJWT fails after session expires
V2403.1 - March 14, 2024
- Enable Advanced tab on web designers
- Remove legacy service-based scheduler - see: https://help.fluencexl.com/Embedded_Scheduling_Upgrade
- Slicers - option to maintain named range of selected members
- New UI - various improvements and fixes
- Update permission descriptions to clarify approval level
- Fixed: Scheduler: Embedded images don't embed
- Allow Hierarchy quick search to be cancelable
- Update default FormatSheet grid label colour
- Fix random Webview error when using Dynamic chart error in a Dashboard sheet
- Support of Named Ranges for custom formatting areas of grids
- SQL Repo: new options to limit the number of report versions or number of days to keep old version for
- Imported aliases should overwrite existing aliases
- Grid with #REF named ranges gives obscure error
- Update Japanese translations
V2402.1 - Feb 16, 2024
- New UI: Manage Favourites form
- New UI – Fix for error in edit XL3Lookup form
- New UI: Upgrade RepositorySideBar to new UI
- New UI: Performance improvement for table designer
- New UI: Insert Member Useability improvements
- Fix for formula Breakout to new sheet
- Improved handling for template publication
- Fix: Save password with connection fix for multiple connections
- Improvement: Display/Member properties - add property as soon as checked
- Fix: Error on quick search when display property set (Fluence connection)
- Atoti Connection: Update for display/member property handling and updated logo
- Fix: Member properties not remembered when "group member props with same name" checked
- Fluence mdx calcs can get incorrect key from unique name
- Null ref error when paging a proxied table rowset
- Add timing to Web SQL repository logging
- Fluence writeback now converts to correct data type
- Handling for Fluence drilling when connection has MDX calcs
- Fix: Fluence formula reports with restricted members
- Fix: Copy Dynamic Chart puts chart underneath original
- New UI: Fix for Hierarchy quick search, 2nd search doesn't always scroll to search result
- Translation: Addition of Japanese language
- Member selection menu wrong
- Fix: Task pane - member selector can show the wrong hierarchy
- Upgrade Microsoft.Data.SQLClient version
- TidyUp : Removal of redundant references:
- TidyUp: Security enhancements
V2312.1
- New UI - additional forms and bug fixes/improvements
- Global Parameters concept for Web reports
- Axis tuple editor for editing tuple sets from workbook
- Clean Formatsheet location if install path changes
- Refresh connections to clear "Save form cookies"
- Remapping connection for a grid with gap calculation errors
- Web Can't download attachment from comment frame
- Publish button remains active when publishing
- Updated paging control
- Check for kyvos server being down before retrying oauth
- Allow editing of groups in admin app
- Removed additional Web UI right click option
- Powershell - Include license key expiration
- Embedded scheduler - support TM1 conns
- Recent reports page not refreshing after opening a report
- Scheduler: Allow connections to PowerBI using service principal
- Fixed: Display member property doesn't work
- Fixed: Freeze pane not positioned correctly in web on very high dpi
- Member property not shown in Web
- SQL Repo managed identity isn't used for scheduling LogController
- Dashboard labels and titles not center aligned on web
- Web multi-select workbook slicers don't resize correctly
- Drillthrough on FluenceXL grid - Group Dimension should only pull itself, not leaf descendents
- Web dialog closing on toolbar click
- Excel update: Camera objects impact Grid Refresh performance
- Fixed performance issue using Picture Links/Camera objects
V2311.1
- New UI improvements and fixes
- Axis set editor
- General security fixes
- Powershell Cmdlet - Get license info
- App service - support printing viewports onto incell charts
- Scheduling allow new Exchange connections
- Fixed: Dashboard Label with title gets scrollbars
- Fixed: Grid title replaces the first member when headers are hidden
- Dax designer doesn't show member picker when hierarchy on Filters
- Fixed: All hierarchy member choice disappears from grid when a new filter is added
- Fixed: Template table 1 not showing column headers
- Fixed Slicer aliases ignored
- Improved logging
- Allow SSO logon for PBI xlsx connection files
- Improved support for legacy(2000) Cube files
- SSAS Azure unauthorized exceptions can be missed
- Dashboard title button does not output on web
- Hierarchy editor not showing member aliases
- Waterfall chart with no series errors
- Kyvos remove sso retry with basic auth
- Datalabel background not applied on reversed waterfall charts
- Variance chart labels wrong way round
- Axis tuple switch error if grid is hasn't been executed
- Dashboard item captions don't update when items are edited
- Formatting issue if format sheet selected and pick Accounting
- Import Items into Web show import progress
- Fluence: Don't cache global variables
- Variance waterfall - split by doesn't keep new hierarchy
- Fixed: Template table indentation issue on Web
- Add SQL Server connections (relational) to Powershell
- Download to Powerpoint using XL3ReportType
- Rename XLCubed dashboard
- Error when editing picture link
- Connection mapping: Support mapping from integrated to un/pw
- On-premise Embedded scheduler - can't connect to azure as
- Override border colour not working in dynamic chart
- Slicer selection doesn't update chart on pivot view
- Remapping hierarchies on a connection for a grid with gap calculation errors
V2310.1
- New Feature: Report Publication Workflow Process
- Grid Designer - Axis editor for asymetric selections
- Store detailed information about each 'SendTo' run
- New UI - bug fixes and enhancements
- Security updates
- Freeform report ribbon + improvements
- New Template table UI
- Fix reversion Icon order on In-cell chart formula
- Fixed: Grid Chart added on the web is printed in the upper left corner
- Improve Button Slicer Rendering
- Added {gridlastrefresh} option to grid title
- Propagate to new workbook should keep formatting
- Convert Incorta grid to formula can give wrong measure aggregation type
- Allow sql: directly in xl3lookup for incorta
- Add logging to browser initialisation
- Incorta formulae using measure columns as filters give blank
- Incorta SSO change
- Improve anaplan SSO error message
- Tabular SSAS gives incorrect error when session invalidated
- Basic auth doesn't prompt after log out
- "Message" editing controls fix
- Combo tree slicer on web - Scroll button moves after resizing slicer
- New UI: Publish complete notification missing
- Fluence drillback: handle jsonDetails
- Fixed: Unable to manage multi-sheet printing schedules
- Fluence drills on filters cause error
- XLCubedWebDashboard should use XL3LocaliseFormatString for date formats
- Fixed: Basic authentication, Publisher - 2 login prompts
- Web Ad-Hoc Add toolbar items
- Fixed: Kerberos-alternative doesn't work with embedded scheduling when using Windows or Basic authentication
- ImpersonateJWT - allow custom effectiveuser claim & set SQLContext
- Fixed: Member properties are lost after Edit & Remap connection
- Icon Text incorrect in published FluenceXL reports
- Fixed: Create Powerpoint chart - charts don't render correctly
V2309.1
- New UI fixes and improvements
- Enable Excel logging through the Options form
- New freeze pane handling option for web publication - improves alignment when zooming
- Add 'last modified' date to Report context menu
- Add scheduling for single report via "Send To" schedules
- Fluence: Support repeated tuples in grids
- Fluence: XL3GlobalVariableLookup function
- Don't overwrite appsettings.json on upgrade
- Fixed: Can't sort grid by calculation on Incorta
- Create aggregates instead of measures for Incorta
- Overlap charts get black fill
- Dashboard Chart Overlay refresh on Web
- Dynamic chart can error with no series on the primary axis
- Web Dashboard Chart - Entity name overlaps chart bar
- Datalabel background missing on reversed value scales
- Deleting a schedule folder doesn't delete its contents
- New Comment UI improvments
- Fixed: Error saving comments when embedded in iframe
- Allow setting custom sql filter for incorta
- Fix error in Web config utility for some virtual directories
- Dax-based tree slicers do not output captions
- Preview option: Embedded styles, to stop needed to save as XML
- Dax tree slicer - support "All" item
- Incorta sql calcs do not go into the right measure group
- Updated Dutch translations
- Reverse sort doesn't work on ATOTI
- Fluence - Add alternate Drillthrough option
- Deleting freeform root cell causes error
- Copy Freefrom reports when copying worksheet
- Incorta - allow self join hierarchies on business schema
- Anaplan SSO updates
- Fixed: Azure SSAS connection may not reconnect after token expiration
- Missing member in set slicer causes error
- Slicer not displayed in chart
- Improve text of SSO auth type option
V2308.1
- New UI - Allow switching of member display from caption to other properties
- Include new toolbar in embedded reports
- SQL Repo - Option to limit excel "Manage" options for "My Reports"
- Fluence Writeback - apply writeable formatting based on security & open periods
- Fluence - formula reports using custom calcs speed up
- Grid writeback - allow grid calculation to be sent on write
- Missing translations in Table Properties form
- Grid designer - member sets are removed after updating the grid
- Retry SSAS weighted writes on null/0
- Grid calcs attached to KPI members disappear
- SendTo: Time zone issue
- Matched chart axes have incorrect direction when data is inverted
- Warn if error occured during load that may impact saved workbook
- Custom MDX implementation: NonEmpty & member.UniqueName property
- Web commentary - fix regression with tagging & viewing attachments
- New UI - various fixes
- Chart print to pdf missing markers
- Incorta v2 PAT connection mapping
- SQL Table drilling - handle nulls better
- Incorta search on attribute hierarchy doesnt work
- Rest API - add report parameter support
- Slicer edit screen cant turn on "all" item
- 'Edit & Remap' missing from new connection dialog
- Incorta drill removes items when slicer "<All>" is selected
- Format Category Axis Alignment - fix align right icon
- Support distinct count in PBI column default agg
- SQL Admin console - Roles window only opens once
- Speed up on some reports when using "delay control creation option"
- Search measures error on Incorta
- Cancel Query form not always shown
V2307.1
- New UI - Dynamic Chart Designer
- BulkConnectionEditor: enable loading xlsb
- Sql connection mapping - add ability to toggle RequiresPassword
- Option to replace Access Driver with our own CSV driver
- Add WebReport Links to Fluence Tenants
- Various security updates
- SmartView freeform retrieval mode
- Add COM accessor option for AtScale connections
- Show download progress for embedded reports
- Option to use managed identity or Client Secret to access Azure storage for "Send to"
- Atoti support
- Add button on Dashboard Ribbon to toggle TaskPane
- Add a way to reset chart category highlighting
- Javascript API - add "XLCubed.ImpersonateFromJwt"
- Extend the number of parameters XL3WebReportLink supports
- Web: Using a tree slicer with a dead session breaks new session
- Tree slicer search focus goes into Excel
- Anaplan tree-slicer search support
- Error on chart with tabular translations
V2306.1
- Rebranded to FluenceXL
- New UI improvements & fixes - Web & Excel
- XL3Link - option to reload current workbook
- Add support for SSO on Anaplan connection
- Can't apply set function to column aggregate measures
- Option to insert real charts into Powerpoint export
- Connecting to Azure Analysis Services in a tenant that isn't the user's home tenant fails
- Embedded scheduling: allow anonymous SMTP server connection
- Bubble charts can error with customized tuples
- Allow role management via Web UI
- Error with calc grid column on Fluence-based grid with no columns
- Incorta set pageSize as well as maxRows
- Security fixes
- Fluence - Add mdx functions for tags
- Cube Comments error with multiple filters
- Client executed MDX calc improvements
- Option to set default member search type
- Ability to refresh all the objects / Grids of the current sheet from the menu
- Add the capability to sort Fluence data by member property
- Grid designer - subcube button should be disabled for some connections
- Polygon data label names not resolved on web
- Embedded scheduler support Named User Licenses
- Printing conditionalformat icons on the web can error
- Fluence - Drillthrough
- New formula: XL3LastComment - returns most recent comment for data slice
- Multisheet printing not showing slicers
- Azure authentication from Excel required too many Admin approvals - Analysis Services, SQL & Power BI permissions now optional
V2305.1
- Moved to .Net Framework 4.8
- Allow adding a DAX: measure to a dax table by picking an Excel cell
- Enable multi select on the treeview slicer search results
- FluenceXL copy sheet improvements
- Grid Calc with xl3Link can error
- Excel Sparklines can error on different locales
- New UI: Commenting, Breakout
- App Service: Allow managed identity for Repo DB access
- Writeback member formatting erroneously applied
- SSO: Custom procedure customise identity claim
- Add placement option to Slicer lists
- Incorta SSO integration
- Excel treemap chart causes publish error
- Support for Excel validation lists in Writeable grids
- Fluence: Member lookup by Key
- Proxy Server: Role/impersonation optional
- Smallmultiple formatting limit by Name
- Support replace 0 with null for Fluence connections
- Anaplan API update fix
V2304.2
- Proxy server performance improvements
V2304.1
- New Version numbering: YYMM.Release.Build.0 where YYMM is release year and month
- Extended new preview UI to include: breakout, comments, tabular queries, scheduling overview
- Add parameter to hide the workbook slicers pane when activated through XL3WebReportLink
- Kylin support
- Add InterSystems support
- New Web Portal UI - add zoom in/out
- SAI 360 authentication support
- Scheduling: Handle malformed email errors better
- Support calculation group format strings for Tabular SSAS sources
- PowerShell Cmdlet - Export and Import XL3RZ files
- Fluence - Open in new Tab is not showing correct name after rename
- Excel can hang on OnUserPreferenceChanged message
- Unauthorized (401) error when opening Fluence Favourites
- Fluence MDX Calc - better handling of divide by zero
- Template tables - add support for calculated columns
- New web portal:support "Back and Forward" change history
- New UI: Ability to move folders in the publisher screen
- Add an alignment option for slicer lists
- XL3Link new type with extra calcs
- Add Item Footer option on Dashboard sheets
- Add a filter/button option to the workbook object menu to change the view from per sheet to object types
- New web portal: Make side bar color configurable
- Fixed: Comment Timestamp issues in FluenceXL portal
- Improved FluenceXL Proxy error handling
- Support Number format in non-pinned Grid Calculations
- Fluence dimension mapping uses type not role
- Edit table properties - Error getting query from Excel Range
- Fixed: Blank comments can error
- Fixed: Empty sql dynamic charts can error when data is returned again
- Incorta calcs on fields outside of hierarchies lose calcs
- Fixed: Multisheet - first slicer cell output not handling value type correctly
- Member Set from Excel to ignore empty rows / columns
- Intersystems support calculated dimensions
- Fixed: Drill on excel set can use incorrect dimension index in excel
- FluenceXL Mdx Aggregate errors if one of the members isn't returned due to non-empty behaviour
- Better handling of objects that overlap frozen pane by a few pixels
- Minor performance improvements in Excel Grid rendering
- Incorta - add support for xl3membernavigate()
- PowerShell - Allow output directly to Azure Store Blob
- Improve handling of infinitely recursive MDX calcs
- FluenceXLWeb: New "Send to" scheduling options for outputting to Azure blobs
- Drill down on web with named set only possible with right click first
- FluenceXLWeb App Service - OpenID authentication support
- Change incorta schemas description
- Scheduling: Malformed email address shows stack trace to user
V10
v10.0.157
- Fluence repo - Favourite linked to delete folder causes error on publish form
- Fix case of Excel crash on exit
- Fixed: removePartialTextMatches() when resizing iFrame
- Add option to use Row Heights defined on the format sheet
- Web option to throw error if EffectiveUser has not been set on a connection
- Formula can fire too early when loading workbook xml - causes access issues when using App Service
- Fixed: Workbook option 'include page showing selections' not working
- Incorta data reading misses calling cells overload
- Added Aspect support in New Web UI
- Add support for {DimensionTable.{Global.ConsolDataModel}.Entity} in Fluence SQL Queries
- Update Dutch translations
- New UI: various updates sna dfixes
- SQL and Excel dynamic charts should use old properties form
- Data entry Workbook option: Save post & pre writeback triggers
- Data Entry Settings - enable for standard FluenceXL
- XL3RunSqlProc2 can fire twice, no table arracy second time
- XL3Link parameter for A target attr
- Web can run calculations before connections have password
- Option to turn of borders from Workbook Slicer Pane
- Printing workbook with invalid Array formula fails
- Make grid sort context menus more consistent
- Chart doesn't pick up measure format in variance report if driven from custom item
- Improve dashboard item deleting
- Anaplan grids can reformat numbers after writeback
- Smallmultiples hidden on web when placed in certain frozen panes
- Allow and ignore blank member properties in XL3SetProperty()
- Embedded scheduler: connect to Azure SQL and PowerBI
- Configure embedded scheduling on on-prem FluenceXLWeb
- Track Active Cell doesn't work on calculated members
- SQL boolean parameters not correctly converted to strings
- Fixed Chart error on web: Cannot read properties of null
- Add MDX logical functions
- Anaplan cube picking improvements
- Stacked charts with hidden labels hide all labels
- Add dynamic chart null checks
- Allow disabling of Cancel Query dialog
- Incorta fixes and improvements
- Incorta add support for session sql calcs
- Drill relational tables - add expand/collapse all button support
- Relational tables - option to drill/group based on indenting field
- Support scroll wheel in frozen panes on web
- Edge Data validation drop down fixes
- Remove IE from forms login handling
- Default new workbooks to "Use Embedded images"
v10.0.156
- Default to new UI for new installs
- Default to embedded image publication on new workbooks
- Fixed regression issue with XL3Filter/XL3Trackchanges being passed to formulae
v10.0.155
Internal
v10.0.154
- Fluence Web - Support text writeback
- Grid Actions - custom right-click menu items
- Auto handling of typed hierarchies in Fluence between tenants
- Prep for Fluence formula query optimisation
- Web: Change Run sql order to avoid conflicts with XL3Lookup
- Option remove slicer if dimension not present when opening workbook
- Add ability to pick descendants of Level in member selector
- Drop Internet Explorer Support
- Fixed: Chart colour disappears on web dashboard sheet when clicked
- Group members doesn't show range name when on filters
- Improve Anaplan formula performance when multiple measures
- Change sql command timeout UI
- IsEmpty function support in custom calc support for Fluence & Anaplan
- Fixed: Validation drop downs disappear in Edge
- Bold Column/Row labels don't size correctly on web
- Percentage bar format in second breakout grid resets to default
- App Service: Auto restart CubeBuilderShim
- Fluence: Option to limit tenants to match URL
- New UI: General improvements & fixes
- Dynamic Charts manual layout option
- Incorta white label updates
- Print object option for viewports
- Grid "Auto size rows" option
v10.0.153
- Item title button support large range copying
- Support HierarchiesOnHeaders in XL3SetProperty for slicers
- Allow changing of Dynamic Chart connections
- Error on web when grid has measure with null default format
- Anaplan can have dimensions with no members if you have no security access
- Save to excel using direct link fails
- Asymetric drill errors on Kyvos
- Fluence writeback issues fixed
- Connection made before connections are configured on web when using a cell parameter created with a named range
- Dynamic Charts can refresh during Excel recalc before any format sheet formulae have calculated
- Multiple writes in a transaction on Fluence don't overwrite properly
- Improved Fluence debug messages
- Incorta - Allow nesting of measures
- Fix regression on encoding of some styles
- Anaplan support for retrying writeback
- Upgrade from ADAL to MSAL
- User Aspects not saving on some reports
- Embedded toolbar via Javascript API errors because of missing DataEntry div
- Scheduler: Handle @@XL3TOTALPAGE@@ in pdf output
- App Service installer Manual mode gives object ref not set
- Veracode scan updates
- Give proper error when cube is unavailable in reports with Slicers
- Abandon App Service session when anonymous and redirected to login
- Improved error for XL3WebReportLink pointing to missing report
- Support different first page setup
- Excel freezes when opening file with viewports on dashboard sheets
- Update jquery-ui & jQuery version
- New UI Preview: Dimension slicer & Table Designer
- New UI Preview: Named ranges in new grid editor UI
- New UI Preview: Connection Form
- Writeback that requires old value changes active cell
v10.0.152
Internal
v10.0.151
- Resolved issue with asymmetric drilling
- Support asymmetric drilling on Kyvos data sources
v10.0.150
- Fluence writeback update - Restore cursor after writeback
v10.0.149
- Spark Sql connector
- Fixed: Writeback on Fluence doesn't include default members
- Fixed: Named user licensing - creating User table entry even if user doesn't have access
- Centrally disable workbook storing of Credentials
- Specify Locale on startup for addin conflicts
- Fixed: Fluence Portal - Aspects not saved
- Allow insert tables for Kyvos and Incorta
- Template Tables: add Range picker in formatting selector
- XL3SetProperty should allow using captions if no unique name matches
- Update to new PowerBI xlsx connection files
- Fixed: Indenting formatting issue
- Update Fluence naming conventions
- Fixed: Custom calcs not registered for fluence sql pivot tables
- Anaplan tenant and writeback improvements
- Can't add calc columns to aggregate measures
- Outlier grouping can error on waterfall chart against Tabular SSAS
- Add ability to capture member expression from metadata
- Task pane always displays layout of the first grid (new UI)
- New UI: Grid designer advanced selections & Member properties
- Add Rendering support to PowerShell
- Support Trusted Publisher via group policy
- Workbook Aspects don't reset slicer selections to default (all)
v10.0.148
- Scheduling service startup hotfix
v10.0.147
internal only
v10.0.146
- New Web portal – updates and fixes
- New Report Designer – support for member properties and other improvements
- Allow DAX: in XL3LookupTabular()
- Fluence – support GlobalVariables for Model name
- Allow escape to cancel writeback editing without a warning
- Latest IBCS standards updates
- Fixed: Converting Qlik grids with dynamic measures errors
- Data driven dashboard labels don't update on the web
- Deal with ! in sheet name when parsing addresses
- Fluence Tag reporting enhancements
- Handle blank Favourite Names
- Incorta - adjust page size based on current position
- Incorta default member caption should be blank
- MdxCalcs - genarate blank tuples as necessary
- Measure search doesn't include calculated members
- Member tree allow loading "More" into top level
- FluenceXL Powershell Cmdlet for automated report deployment/management
- Slice highlights with blank members not handled correctly
- Table properties - hide some tabs for Incorta
- TM1 custom calc sets can error
- Performance improvement for Workbook slicers – stop additional refreshes
- Fluence – added “Level” property
- Incorta add measure filters on tables, custom query on tables and improve timeout handling
- Update Maps to use embedded Edge to address Google dropping IE support
- Fluence: Web-based Model entry support
- Enhanced logging capabilities
v10.0.144
- Updated “Preview UI”
- Grid Designer
- Publishing
- Web Portal
- Web Adhoc
- "Clear and select members" bug fix
- Business template table support for Fluence and Anaplan
- Business charts turn off non-empty series to correct comparisons made
- Template tables - don't flag rows as subtotals if member has no children
- Commas in MDX statements in formulae can be replaced in non-US locales after pdf printing
- Support MDX Calculations in Fluence & Anaplan
- Hide levels MSAS MDX doesn't always work when drilling down
- Misbehaving datasources can cause favourites to be deleted
- FluenceXLWeb: Anti CSRF checks + additional adhoc access checks
- Powerpoint: Improved incell chart handling in grids
- Fluence relational - handle quoting of reserved words
- Fluence EffectiveDate - default to today
- Add XL3SetProperty support for member properties for Grids
- New formula XL3HierarchyRoleLookup
- Proxy: Support SSAS Writeback
- Chart taskpane colors checkbox
- Proxy: Improve proxy with inaccessible/invalid connections
- Add new function XL3DefaultMember()
- Add DefaultMemberType to grids
- Add support for #tag to Fluence range selections
- Fluence improve #tag support in range driven reports
- Viewport backcolour not applied to entire dashboard item
- Multidimension Query - fix default members and add more search properties
- Chart taskpane - category axis reverse order checkbox
- Implement selection level for cube tree slicers
- TM1 formula mdx fix
- Fluence: Fix for publishing when user only has access to one tenant
- Fix for XL3Link form inserts formula not cell address
- Allow drilling on smc category labels for lolliplots
- Updated dutch translations
- Fluence data entry - support highlighting by tag in grids
- Fixed: Workbook slicer pane can not have its bg colour set to "none"
- Custom grid highlight ranges and writeback controlled by cell locking
- Fluence comment web server fix
- Powerpoint export: Closer match Excel character spacing
- Powerpoint export: Better viewport support for inline incell charts
- Incorta support paging members
- Workbookslicer visibility issues
- Fixed: Fast PDF regression
- Incorta Scheduling support
- Incorta slicers fix
v10.0.138
- Allow clearing of auth tokens on web
- WebView2 - Fix apply IBCS issue
- Clean up streams after use
- Scheduling: save as Excel can get wrong file name when dynamic
- App Service: Embedded scheduler fails with connection mapping enabled
- New feature: Fixed header rows in Grids
- Change default for "Disable unrelated columns in Tabular Designer" setting to false
- Fix mdx syntax highlighting when query ends with ] and no new line
- AppService installer: handle FTPS-only app services
- Fixed: Quick search for measures doesn't work
- Add Axis level custom queries for Incorta and Qlik
- Pick range doesn't always hide all forms
- Fluence metadata adapter can error on some published reports
- Kyvos support for member key from range
- MultidimensionalQuery calculations initial implementation
- Reading function xml can error on empty elements
- Fluence - support hierarchy aliases from properties
- Preivew feature: improved web adhoc ui
- Qlik paging for spaces and apps
- Fix InsertFavourite for Fluence connections
- Fix fluence query text for advanced selections
v10.0.137
- Fluence model data entry
- Incorta updates
- Default implicit measures on in new installations
- Fluence native member alias support
- Qlik improvements
- Incorta enhancements
- Qlik UI captions
- Add flex drilling on levels to non-mdx data sources
- Add alias support to Anaplan,Incorta,Qlik
v10.0.136
- Qlik updates
- Handle 307 redirects with Proxy server auth
- Fix regression of XL3RunSQLProc
v10.0.135
- Improve handling of waterfall comparisons on expenses/revenues
- Improve handling of line breaks with words longer than a cell
- Fix error with mixed compact axes and grid calculations
- Fix for hang during comment formulae authentication check
- Dynamic chart legend improvements
- Add %distributionlist% placeholder to scheduling
- Grid comment support in viewports
- Member search support multiple criteria
- Allow MDX: when defining member sets in Excel
- Proxy: Relational parameters
- XL3Jsonify Formula
- Scheduling: Use Distribution List name instead of Guid when using %groupname%
- TM1 web auth improvement
- Publish connection form improvement
- TM1 web auth improvements for ibm cloud sources
- Don't retry logon attempts when un/pw is invalid
- Fluence Writeback improvements
- TableFilter may not update correctly on web when driven from range
- Duplicate field names cause pivotview to error
- Fix for hidden headers for Table
- Improve XL3LookupTabular performance
- Restrict business tables to valid connection types
- Qlik cloud handle moved Apps
- Create message can crash with invalid textbox in master template
- Qlik performance improvement and setting removal
- CubeBuilderShim, fix issues and improve performance of App Service PivotViews
- Fluence tree slicer drilling
- Optional WebView2 dynamic charts
- Fluence Model View Support
- Business table with template columns driven from range doesnt update on web
- Improve Qlik connection item listing
- Fluence API - Intrinsic Property support
- Improvements to switching between MSAS and API Fluence connections
v10.0.133
- Allow editing of grid calcs when axis set driven from a range
v10.0.132
- Add extracted Scintilla binaries to Excel installers
v10.0.131
- Incorta - add support for picking attr hier as measure
- PowerBI Premium powerbi:// web auth fix
- Incorta int type fix
v10.0.130
- Fluence Pivotview support
- Propagate Forumla creating duplicate grids
- Handle Int32 in PivotViews
- Fluence Table slicer support & Fluence writeback phase 1
v10.0.129
- Anaplan improvements and flunce set function support
- TM1 OAuth improvement
- TM1 Auth improvements for HttpOnly cookies
- TM1 improve auth when at server vs db level
- Anaplan - Support pivoting for cellsets > 2D
- Anaplan Improve token refresh
v10.0.128
- New grid taskpane
- Dynamic charts - copy animation settings
- Template tables - option to compare vs Forecast for IBCS templates 2 and 4
- Make table filter selections editable
- Init Member Search UI with existing config
- Qlik compact mode with nulls fix
- Tooltips on Picturelinks
- Edit Picturelink added to Excel right-click menu
- Better resizing of Dashboards when FluenceXL Taskpanes are shown/hidden
- Localise dynamic charts in excel
- Reset slider in small multiples when categories change
- Show cube caption not name in connection dropdown
- Clear progress spinner if listing cubes errors
- Qlik - add support for using variables as measures
- Order schedule execution according to next run time
- Anaplan - support layout with only columns defined, only add view members once in a crossjoin, App Service installer: Always use slashless Url
- Fluence scheduling groundwork
- Anaplan - improve connection handling and security
- Excel installer: include WebView2 bootstrapper
- Improved Member Selection when adding business rules
- "Delay control creation during load" option
- Fluence API - allow partner hosting
- PowerBI Auth update on Web
- Whitelabel updates
- Fix list method overriding
v10.0.126
- Fluence style - increase multi-select slicer min width
- Delay in Selected items updating when setting "Initial selection" in Excel
- TM1 Enhancements - cube picker and writeback
- Business template tables allow comparing to forecast
- Added blue headers to some options
- Initial Fluence relational support
- Hide incell chart formulae for template tables
- "TheSans" better datalabel handling in Incell Chart
- Updated XL3Lookup, CubeSliceEditor and add default member selection in xl3lookup in grid
- Include Microsoft.Web.Scintilla in Excel setup
- Include Microsoft.Web.WebView2 in Excel setup
v10.0.125
- Multiselect in Available Hierarchies
- Chart defaults and save/load styles
- TM1 cloud auth fix
- Table filter improve blank handling
- Some chart settings not being copied
- Formatting fixed for Tables when Headers are hidden.
- Reverse formats option of XL3SparkBar
- Add chart axis option - auto min/max sets to zero
- Speed up member tree view by enabling virtualization
- Support Total page count on FastPDF output
- Breakout % column to match grid font size
- XL3Members should drill up even when they have very long member unique names
- "ignore hierarchies" in comments no longer need to be the last dims on filters
- TM1 auth and view fixes
- Line charts with current month business rule error
- Remove current sample reports and link to new ones
- Chart taskpane - colour field in not visible and error changing chart type with xyz values
- TM1 - test server ip address and host for connectivity
- Fluence commenting
- Support illegal characters in Connection Mapping for sql repo
- Dutch translations
- New Visual styles (Preview)
- Option to change FluenceXLWeb title (WebSiteTitle in web.config)
- Fluence commentary
- Fluence API Update
- Update Microsoft.Identity.Client and Microsoft.Graph.Core versions in FluenceXLWeb.csproj
- Fluence small mults index fix when no row dimensions
- Fix sparkbar and add error handling to sparklines
v10.0.124
- Qlik changes
- Change connection defaults with evaluation license
v10.0.123
- Workbook slicers don't reshow when switching from the Formats sheet
- ClickOnce: rename as FluenceXL and sign as Fluence
- Proxy: Register logger stub
- Enable AtScale connections
- Remove current sample reports and link to new ones
v10.0.122
- Fluence updates
v10.0.121
- Add support for MFA when connecting to Azure Sql Server
- Add TableFilter selection type: https://help.xlcubed.com/Table_Filter
- Waterfall charts in PowerPoint & pdf
- Option to use inline Incell Charts in Fixed Excel Exports (clearer but needs font installed)
- Sort fluence folders alphabetically
- Multipart number formats with thousand dividers not correctly applied
- IBCS tables chart columns with missing formats can have previous format applied
- Dashboard sheet with workbook slicers can have initial size rendered with scrollbars
- Filter table selection item: add sort option
- Web formulae with "ResetAddress" don't work when the reset cell is on another worksheet
- New dashboard taskpane - hide/show all items
- New dashboard taskpane - items context menu
- Allow reference ranges on business charts
- Waterfall category direction/colour can be incorrect if expenses are +ve
- Waterfall chart fixes
- Business chart task pane can error when there is missing series data
- Freeze panes can be in wrong position
- Improved support for xl3lookup with >20 hierarchies
- Allow multi-drag of hierarchies in grid designer
- White label updates
- App Service - Azure SQL Authentication
- Fluence style update
- Improve handling of cell editing in sheets with merged cells
- Remove member selection type menu for measures on the web
- MDX formatting can be slow, timeout after 3 seconds
- Add "between levels" selection type to web UI
v10.0.118
- Demo sample data
v10.0.117
- Pivotview update
v10.0.116
- Fix hierarchy unique names in TupleArray-s
- Fluence api
- Odata fixes
- Small multiple task pane auto apply for agg setting
- OData network creds and waterfall tabular calc fixes
- Fluence tenant mapping
v10.0.115
- Snowflake connection type
- Allow user to configure compact/attribute-drill per axes
- Change default axes for drillable attributes
- Correct comments typo
- Compact mode can error if nothing on rows
- Allow batching of writeback update statements
- Proxy: avoid error messages in login window after login complete
- Default cell format as locked
- y2 axis tooltip incorrectly being set as htmltooltip
- Date slicer not updating initial value on load
- Clicks not registered through a viewport with alignment set
- User's default aspect not saving without user defined aspects
- Turn off y2 axis in ibcs style and separate axes colours in taskpane
- Add "Drill Category" menu item on web small multiples
- Preserve slicer visibility, and apply workbook slicer visibility from XL3SetProperty
- Fix Table tree slicers outputting 2nd column
- Merged cell roots should not be in hidden columns
- Updated Dutch translations
- XL3Filter works incorrectly with a single row of data
- Pivot views handle all invalid chars in column names
- New chart taskpane background
- Print PDF with connection needing SSO prompt
- Enable database creation from command line
- Click off chart should clear the designer new task pane
- Calculated members can break DAX translations
- IBCS comparison waterfall can use incorrect filters
- Try most recent id when connecting to Azure AD
- Compact axes can error for empty cellsets
- XL3DoComment - always use the canonical unique name
v10.0.114
- Fluence translation updates
- Update wixproj files to support per-instance MSBuildExtensionsPath32 for pipeline build
v10.0.113
- Fluence - improved translations and hierarchy hiding
v10.0.112
- Fluence commentry
- Fluence Display now and preview
- Fluence - hide sharepoint option when publishing
v10.0.111
- Fluence - Publishing fixes
v10.0.110
- Tabular translations
- Fluence - tabular translations
- Rename Fluence ribbon to FluenceXL
- Fluence - add SSAS connection when connecting and improved auth for publishing
- Fluence - log out option for data connections
v10.0.109
- Fluence publishing
- Fluence querying
- SSO handle logon during formulae
- Fluence API updates
- Fluence ribbon icon colours
- Fluence excel logon
- Fluence publishing logon
- AppService installer: add support for multiple Host Names
- Fluence authentication updates including impersonation on web
- Fluence "Publish to xlcubedweb" option
- Fluence - hierarchy metadata changes
- Excel Installer: Add Microsoft.Identity.Client and Microsoft.Identity.Client.Extensions.Msal
- Fluence connections should only be available to Fluence license keys
v10.0.107
- Retry socket reset errors
- AuthToken retrieval can error in Azure app service
- Relational writeback to use db context
- Add support for retrying commands to Com data accessor
- Kyvos updates
v10.0.106
- Attempt to handle "Enable macros" prompt
- Add HANA session context and MDX catalog context
- Add XL3DoComment formula
- Fix freeze pane when hidden rows or columns are contained before the freeze pane.
- Labelled Control auto-wrapping fix
- Download prerequisites from HTTPS only
- Initialise CubeCommentController outside of the QueryCanceller to avoid "Cancel Query" prompt
- App Service setup, handle invalid connection better
- App Service setup, more detailed error messages
- Custom calcuations on SSAS perspective can error when edited
- Check for mdx missing member mode support before setting command prop
- Change to more generic error message for file not found on opening web report
- Handle chart overlays on chart areas with no series
- Dutch translations
- small multiples on sql connections driven from a range can error on opening worksheet
- workbook slicers with initial value changes can cuase multiple refreshes work workbook objects
- Sql parameters used with "IN" clause whose names are substrings of each other can cause invalid queries
- Add more properties to slicer bulk edit
- Allow setting a border on an Excel camera object
- Log XL3MemberNavigate exceptions
- XL3MemberNavigate doesn't correctly store duplicate captions stored in the same cell
- Calculated columns error if grid is in attribute drilling mode
- If just one invalid member when "Manage structure changes" then it is not shown as invalid
v10.0.105
- Web: Extra startup tracing
v10.0.104
- White label updates
- Allow ignoring invalid members when member text not validated
- Acterys
- Kyvos add support for MDX missing member
- Copy member validation mode in grid/table settings
- kyvos and acterys updates
v10.0.103
- Allow context menus in workbook slicer trees
- Dynamic Charts - option to hide null/zero data labels
- Dynamic Charts - allow total in center for pie/doughnut chart types
v10.0.101
- New drilling mode: Attribute drilling paths on grids and template tables. Move attributes to Rows to define drill path
- FluenceXLWeb: Excel Chart Datatable improvements
- General Performance improvements
- Grid & Table ribbon handles erroring grid better
V10.0.98
- Option to show report name in repository tooltip
- Handle tel: and callto: links on web
- Improved donut and pie label support on web
- Donut chart better border support
- Allow custom calculation form to open when there are sets that contain syntax errors
- Business chart improvements
- Web build now strong-named: Custom Extensions will need to be compiled for each release
- Ibcs icon changes and rule renaming
- SQL Query builder improvements
- Default InlineMicrocharts for new installs
- Dashboard titles icon picker
V10.0.96
- Azure App Service scheduling support
- Fixed: "More fields" not appearing
v10.0.94
- Better support for deep links between grids and dynamic charts
- Improved "Available Hierarchy" searching
- New right-click options on Tree slicers to select parent/children
- Auto-create subtotals in drilled template tables
- Option to return a blank cell from slicers if no selections are made
- xl3activecelladdress parameter when opening a report will scroll to the cell if it's unlocked
- Custom business rule formats
- Improved Excel start-up speed with unavailable azure-storage mapped drives
- Better format support for "XL3Link" columns in relational tables
- Parent Child hierarchies can be created in Pivot-Views (right-click on the hierarchy in the Pivot view setup to configure)
- Support "Startup report" with "Browser-based login" on FluenceXL Mobile
- TM1 - better handling when no measure hierarchy defined
- New option to apply filters/set functions to drill results
- Waterfall dynamic chart - better subtotalling and label positioning
v10.0.93
- Fix issue with some Tabular Analysis Services columns and tables not begin shown
- Better support for display folders in Tabular Analysis Services
v10.0.91
- Better support for some @ style formula on the web
- Multi-tenant App Service logon will no longer use external website for authentication
v10.0.87
- PowerPoint export supports multi-lined cells
- Option to control layout of Dynamic Charts used as small multiples
- Preview: Updated Dashboard task pane
- Better support for Azure SQL in the SQL Query editor
- Highly formatted textbox support in FastPDF/Powerpoint
- Improved Template Table UI
v10.0.81
- Azure connections: renew authentication tickets automatically in more scenerios
V10.0.79
- Preview Option - new Table properties form
- Preview Option - Improved Dymanic Chart Taskpane
- Preview Option - Template tables
- Business rules
- Improved FastPDF support
- Dynamic charts support in viewports
- Hana - option to disable connection pooling
v10.0.75
- Option to turn off FluenceXL when editing PowerPoint-embedded workbooks
- Slicer searching support for more data sources
- LinkTo option on Dashboard Labels
- Additional Writeback information available in Web API
v10.0.62
- Workbook slicers support DAX slicers
V10.0.60
- Improved support for Azure Analysis Services/Multi-Tenant OAuth setups
V10.0.57
- Multi-sheet printing: New workbook option to allow "Select All" of members
- Report exports added to tracking in SQL Repository
- Improved report loading speed of workbooks with many linked Workbooks Slicers
V10.0.56
- New formula: XL3TrackChanges
- New formula: XL3Filter
- New multi-sheet printing option to associate sheets to specific slicers
- More dynamic chart options to support IBCS
V10.0.55
- FIPS algorithm compliance
V10.0.51
- SQL Repo: Support for case-sensitive server collation
- Performance improvement loading workbook with lots of aliases
- Option to alias Dynamic chart Column/Row name
- Integrated legend now supports "drag" resizing
- All web popup dialogs work better on small devices
V10.0.49
- Various new dynamic chart options to continue to support IBCS standards
V10.0.47
- Options to handle Data Validation dropdown submit behaviour
- Slicer lists - allow adding of relational connection slicers
- Advanced member search support in SAP Hana
V10.0.46
- Add business rules support for dynamic chart formatting
- Dynamic charts - lots of new options to support IBCS
- Incell Compare chart support in Grids
V10.0.35
- Add TM1 support for CategoryCompare waterfall charts
v10.0.34
- Support for SSO provider initiated logon
- Option to disable specific dialogs in FluenceXLWeb
- Multisheet printing: options for sheets to include at start and end of PDF
- New options in XL3ReportInfo
- New formula XL3ConnInfo
- Initial support for Kyvos connections
V10.0.32
- Improved french translation
V10.0.31
- Support for 2 PowerBI connections in one workbook
V10.0.28
- Release version - see Version 10 for a list of all the new features