Version 9

What's new in XLCubed Version 9

General

Grids

• Grids can be built from any supported datasource

Tables

• Joined tables

Visualisation

• Improved layout of Treemaps

• Dashboard sheets
• Paged viewports
• Popup viewports
• Option to autos-size maps
• Maps support additional placeholders in tooltips

Slicers

• "Apply query restrictions" available for Member Selector slicer types
• Slicers will now retain data types when outputting to cells - off by default in pre-v9 workbooks, can be enabled in Workbook Options

Formulae

• Support more then 30 parameters on XLCubed formulae
• New function: XL3RefreshSheetObjects
• XL3SetProperty can now set:
  • Chart Series colours

Datasources

• Additional datasources:
  • Google BigQuery
  • Amazon Redshift
  • PowerBI Cloud
  • PowerBI Desktop
  • HDInsight
  • QlikSense Desktop

Scheduling

• Option to run schedules via scheduled task rather then using the service

General

• Workbook option to set queryengine.ValidateMembers
• Moved to .net framework 4.5.2
• Updated format sheet - allows better control of borders.(CS)

Excel Edition

General

• Updated ribbon and UI
• Option to remember logon credentials for current Excel session
• Removed support for Excel 2003 - previous versions remain compatible

Slicers

• Reduced Excel resource usage by dimension slicers

Grids

• "Clear drills" option in member selector
• New "Scope_Isolation" option in Custom Calculations
• Option to sort named sets in member selector

Web Edition

General

• Connection Mapping includes an optional "path" attribute to allow folder-level mappings
• Option to include custom css file to override css

SharePoint

• Reports published directly to SharePoint can now be used in scheduling