Difference between revisions of "Version 10"

(Small Multiples)
Line 6: Line 6:
 
* Grid Breaks - easily add row and column breaks to XLCubed Grids for spacing and presentation
 
* Grid Breaks - easily add row and column breaks to XLCubed Grids for spacing and presentation
 
* Member Search Option for Treeview Slicers
 
* Member Search Option for Treeview Slicers
 +
* SSO support for XLCubedWeb
  
 
=General=
 
=General=
Line 11: Line 12:
 
==Dynamic Charts==
 
==Dynamic Charts==
 
* Small Multiples auto-detect legend width
 
* Small Multiples auto-detect legend width
* Option to have straggered labels in animated charts
+
* Option to have staggered labels in animated charts
* XL3CubeComment() can now be edited in calculated columns
 
  
 
==Slicers==
 
==Slicers==
Line 23: Line 23:
  
 
==Grids==
 
==Grids==
* Custom Drillthrough Columns
 
 
* Grid Calculations - now allow title in first cell of the row/column
 
* Grid Calculations - now allow title in first cell of the row/column
 
* Improved Grid formatting when using subtotals
 
* Improved Grid formatting when using subtotals
* Alternate row formatting
 
 
* Option to use alignment instead of spaces for Grid indentation
 
* Option to use alignment instead of spaces for Grid indentation
  
Line 37: Line 35:
  
 
==General==
 
==General==
* Option to select the Active Tab first in a Properties search
+
* Improved property searching
 
* Comment Frames can now be copied
 
* Comment Frames can now be copied
  
Line 44: Line 42:
  
 
==Small Multiples==
 
==Small Multiples==
* Option to drill Categories on Web
 
 
* Improved Chart Drilling
 
* Improved Chart Drilling
  
Line 53: Line 50:
 
* Protect Worksheets when downloaded to Excel
 
* Protect Worksheets when downloaded to Excel
 
* Option to turn off ‘Adhoc’ and ‘Analytic Books’ independently
 
* Option to turn off ‘Adhoc’ and ‘Analytic Books’ independently
* SharePoint Add-ins
 
 
* Log downloads of reports (PDF, Excel Live, Excel Fixed, PPT)
 
* Log downloads of reports (PDF, Excel Live, Excel Fixed, PPT)
 
* [[XL3SetProperty]] - option to update the datalabels of a chart from an Excel Range
 
* [[XL3SetProperty]] - option to update the datalabels of a chart from an Excel Range
 +
* XL3CubeComment() can now be edited in calculated columns

Revision as of 11:39, 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

Slicers

  • Option to include a search option in Treeview Slicers

Scheduling

  • Scheduling allows reports to be run as a user

Excel Edition

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

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


Web Edition

Small Multiples

  • Improved Chart Drilling

Slicers

  • Improved Slicer formatting

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