XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Release Notes"

Line 2: Line 2:
  
 
=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==
 
==v10.0.156==
 
* Default to new UI for new installs
 
* Default to new UI for new installs

Revision as of 14:34, 10 March 2023

The following page lists new features added to XLCubed, each release will also contain general bug fixes

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