Version 9

What's new in XLCubed Version 9

Main Additions

  • Dashboard sheets - build auto-connected, responsive, and device optimised dashboards in Excel for Web and mobile deployment.
  • Grids can connect to Additional datasources - SQL, Excel and Big Data Sources.
  • Paged Viewports - Ideal for 'panel' dashboards - Bring any part of an Excel workbook together in one dynamically switchable container.
  • Viewports can now reference Excel charts directly, rather than the range the chart is located in.
  • Data Mashup - to bring data from different sources together in one reporting table.
  • UI enhancements

General

Grids now connect to additional Datasources

Tables

Visualisation

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

  • XL3Link adds "PRINTSHEET" and "PRINTWB" to print the active sheet/workbook without prompting

Scheduling

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

  • Skip Levels for tree slicers
  • Reduced Excel resource usage by dimension slicers

Grids

  • * Skip Levels in member selector
  • "Clear drills" option in member selector
  • New "Scope_Isolation" option in Custom Calculations
  • Option to sort named sets in member selector
  • Option to turn off "Refresh when slicers change", similar to "Refresh when driving ranges change"

Web Edition

General

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

Formulae

SharePoint

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

Visualisation

API