XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Release Notes"
(→V10) |
|||
(42 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
The following page lists new features added to XLCubed, each release will also contain general bug fixes | The following page lists new features added to XLCubed, each release will also contain general bug fixes | ||
+ | |||
+ | ==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 | ||
+ | |||
+ | ==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 | ||
+ | * XLCubed 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 XLCubed 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 | ||
+ | * XLCubed 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 | ||
+ | * XLCubedWeb: New "Send to" scheduling options for outputting to Azure blobs | ||
+ | * Drill down on web with named set only possible with right click first | ||
+ | * XLCubedWeb App Service - OpenID authentication support | ||
+ | * Change incorta schemas description | ||
+ | * Scheduling: Malformed email address shows stack trace to user | ||
=V10= | =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 XLCubed | ||
+ | * 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 XLCubedWeb | ||
+ | * 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 | ||
+ | * XLCubed 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 | ||
+ | * XLCubedWeb: 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 XLCubed 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 XLCubedWeb title (WebSiteTitle in web.config) | ||
+ | * Fluence commentary | ||
+ | * Fluence API Update | ||
+ | * Update Microsoft.Identity.Client and Microsoft.Graph.Core versions in XLCubedWeb.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 | ||
+ | * XLCubedWeb: 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 XLCubed 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== | ==v10.0.81== |
Latest revision as of 10:13, 13 November 2023
The following page lists new features added to XLCubed, each release will also contain general bug fixes
Contents
[hide]- 1 V2311.1
- 2 V2310.1
- 3 V2306.1
- 4 V2305.1
- 5 V2304.2
- 6 V2304.1
- 7 V10
- 7.1 v10.0.157
- 7.2 v10.0.156
- 7.3 v10.0.155
- 7.4 v10.0.154
- 7.5 v10.0.153
- 7.6 v10.0.152
- 7.7 v10.0.151
- 7.8 v10.0.150
- 7.9 v10.0.149
- 7.10 v10.0.148
- 7.11 v10.0.147
- 7.12 v10.0.146
- 7.13 v10.0.144
- 7.14 v10.0.138
- 7.15 v10.0.137
- 7.16 v10.0.136
- 7.17 v10.0.135
- 7.18 v10.0.133
- 7.19 v10.0.132
- 7.20 v10.0.131
- 7.21 v10.0.130
- 7.22 v10.0.129
- 7.23 v10.0.128
- 7.24 v10.0.126
- 7.25 v10.0.125
- 7.26 v10.0.124
- 7.27 v10.0.123
- 7.28 v10.0.122
- 7.29 v10.0.121
- 7.30 v10.0.118
- 7.31 v10.0.117
- 7.32 v10.0.116
- 7.33 v10.0.115
- 7.34 v10.0.114
- 7.35 v10.0.113
- 7.36 v10.0.112
- 7.37 v10.0.111
- 7.38 v10.0.110
- 7.39 v10.0.109
- 7.40 v10.0.107
- 7.41 v10.0.106
- 7.42 v10.0.105
- 7.43 v10.0.104
- 7.44 v10.0.103
- 7.45 v10.0.101
- 7.46 V10.0.98
- 7.47 V10.0.96
- 7.48 v10.0.94
- 7.49 v10.0.93
- 7.50 v10.0.91
- 7.51 v10.0.87
- 7.52 v10.0.81
- 7.53 V10.0.79
- 7.54 v10.0.75
- 7.55 v10.0.62
- 7.56 V10.0.60
- 7.57 V10.0.57
- 7.58 V10.0.56
- 7.59 V10.0.55
- 7.60 V10.0.51
- 7.61 V10.0.49
- 7.62 V10.0.47
- 7.63 V10.0.46
- 7.64 V10.0.35
- 7.65 v10.0.34
- 7.66 V10.0.32
- 7.67 V10.0.31
- 7.68 V10.0.28
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
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
- XLCubed 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 XLCubed 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
- XLCubed 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
- XLCubedWeb: New "Send to" scheduling options for outputting to Azure blobs
- Drill down on web with named set only possible with right click first
- XLCubedWeb 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 XLCubed
- 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 XLCubedWeb
- 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
- XLCubed 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
- XLCubedWeb: 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 XLCubed 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 XLCubedWeb title (WebSiteTitle in web.config)
- Fluence commentary
- Fluence API Update
- Update Microsoft.Identity.Client and Microsoft.Graph.Core versions in XLCubedWeb.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
- XLCubedWeb: 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 XLCubed 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 XLCubed 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 XLCubedWeb
- 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