Difference between revisions of "Version 10"

Line 15: Line 15:
 
* Added Dynamic Chart ribbon and formatting pane for more intuitive formatting
 
* Added Dynamic Chart ribbon and formatting pane for more intuitive formatting
 
* %percentage% label and tooltip option for 100% stacked chart types
 
* %percentage% label and tooltip option for 100% stacked chart types
 +
 
==Slicers==
 
==Slicers==
 
*Option to include a search option in Treeview Slicers
 
*Option to include a search option in Treeview Slicers
Line 28: Line 29:
 
* Improved performance and stability
 
* Improved performance and stability
 
* Allow parameter definitions for SQL Driven pivotviews
 
* Allow parameter definitions for SQL Driven pivotviews
 
  
 
==Datasources==
 
==Datasources==
 
* Support for enforced Hana encryption
 
* Support for enforced Hana encryption
 
* Breakout support for Hana grids
 
* Breakout support for Hana grids
 
=Excel Edition=
 
  
 
==Grids==
 
==Grids==
Line 40: Line 38:
 
* Improved Grid formatting when using subtotals
 
* Improved Grid formatting when using subtotals
 
* Option to use alignment instead of spaces for Grid indentation
 
* Option to use alignment instead of spaces for Grid indentation
 +
 +
==Tables==
 +
* option to remove leading apostrophe to allow Excel calculations from SQL
 +
 +
=Excel Edition=
 +
  
 
==Formulae==
 
==Formulae==
Line 47: Line 51:
 
* Maps now support data labels
 
* Maps now support data labels
 
* Improved chart formatting
 
* Improved chart formatting
 +
 +
  
 
==General==
 
==General==
Line 56: Line 62:
 
=Web Edition=
 
=Web Edition=
  
==Small Multiples==
+
==Dynamic Charts==
 
* Improved Chart Drilling
 
* Improved Chart Drilling
 +
* Improved printing support
  
 
==Slicers==
 
==Slicers==

Revision as of 12:08, 3 March 2020

What's new in Version 10

Main Additions

  • A new set of business-focused Dynamic Charts to support IBCS style best practice visualisation
  • Support for IBM TM1, for both reporting and planning and budgeting
  • Grid Breaks - easily add row and column breaks to XLCubed Grids for spacing and presentation
  • Member Search Option for Treeview Slicers
  • SSO support for XLCubedWeb

General

Dynamic Charts

  • Small Multiples auto-detect legend width
  • Option to have staggered labels in animated charts
  • Added Dynamic Chart ribbon and formatting pane for more intuitive formatting
  •  %percentage% label and tooltip option for 100% stacked chart types

Slicers

  • Option to include a search option in Treeview Slicers

Scheduling

  • Scheduling allows reports to be run as a user

Visualisations

  • New Incell chart: Compare charts
  • Better support for standard Excel waterfall charts

Pivotviews

  • Improved performance and stability
  • Allow parameter definitions for SQL Driven pivotviews

Datasources

  • Support for enforced Hana encryption
  • Breakout support for Hana grids

Grids

  • Grid Calculations - now allow title in first cell of the row/column
  • Improved Grid formatting when using subtotals
  • Option to use alignment instead of spaces for Grid indentation

Tables

  • option to remove leading apostrophe to allow Excel calculations from SQL

Excel Edition

Formulae

  • Insert XL3Member now supports multiple connections

Visualisations

  • Maps now support data labels
  • Improved chart formatting


General

  • Improved property searching
  • Comment Frames can now be copied
  • Improved very high-dpi handling
  • Installation includes sample reports

Web Edition

Dynamic Charts

  • Improved Chart Drilling
  • Improved printing support

Slicers

  • Improved Slicer formatting

Grids

  • Writeback to grids in a viewport now supported

Scheduling

  • Multisheet support for Excel output

General

  • Protect Worksheets when downloaded to Excel
  • Option to turn off ‘Adhoc’ and ‘Analytic Books’ independently
  • Log downloads of reports (PDF, Excel Live, Excel Fixed, PPT)
  • XL3SetProperty - option to update the datalabels of a chart from an Excel Range
  • XL3CubeComment() can now be edited in calculated columns
  • Improved logging of invalid calculations
  • Improved report usage dashboards