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

Difference between revisions of "Version 10"

(Created page with "What's new in Version 10 =General= ==Scheduling== * Scheduling allows reports to be run as a user =Excel Edition= ==Grids== * Breakouts now supported on translated grids *...")
 
Line 5: Line 5:
 
==Scheduling==
 
==Scheduling==
 
* Scheduling allows reports to be run as a user
 
* Scheduling allows reports to be run as a user
 +
  
 
=Excel Edition=
 
=Excel Edition=
  
 
==Grids==
 
==Grids==
* Breakouts now supported on translated grids
+
* Default draggable dimension labels have been set to 'Off' by default
* Custom Calculations kept when changing connection properties
+
* Custom Drillthrough Columns
 
+
* Grid Calculations - now allow title in first cell of the row/column
 +
* Improved Grid formatting when using subtotals
  
 
==Formulae==
 
==Formulae==
Line 17: Line 19:
  
 
==Visualisations==
 
==Visualisations==
 +
* Maps now support data labels
  
 +
==General==
 +
* Option to select the Active Tab first in a Properties search
 +
* Comment Frames can now be copied
  
  
Line 23: Line 29:
  
 
==Small Multiples==
 
==Small Multiples==
* Better chart formatting
 
 
* Option to drill Categories on Web
 
* Option to drill Categories on Web
 +
* Improved Chart Drilling
  
 
==Slicers==
 
==Slicers==
* Slicers now retain selection on members with names containing quote marks.
 
 
* Improved Slicer formatting
 
* Improved Slicer formatting
  
 
==Visualisation==
 
==Visualisation==
* Excel Waterfall Charts now handle negative opening and closing totals
 
 
* Better Excel Chart formatting
 
* Better Excel Chart formatting
  
 
==General==
 
==General==
* Merged Cells keep their format
 
* Downloading to Excel using the multi-sheet option handles formatting
 
 
* 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
 
* SharePoint Add-ins
 
* Log downloads of reports (PDF, Excel Live, Excel Fixed, PPT)
 
* Log downloads of reports (PDF, Excel Live, Excel Fixed, PPT)

Revision as of 15:10, 10 January 2020

What's new in Version 10

General

Scheduling

  • Scheduling allows reports to be run as a user


Excel Edition

Grids

  • Default draggable dimension labels have been set to 'Off' by default
  • Custom Drillthrough Columns
  • Grid Calculations - now allow title in first cell of the row/column
  • Improved Grid formatting when using subtotals

Formulae

  • Insert XL3Member now supports multiple connections

Visualisations

  • Maps now support data labels

General

  • Option to select the Active Tab first in a Properties search
  • Comment Frames can now be copied


Web Edition

Small Multiples

  • Option to drill Categories on Web
  • Improved Chart Drilling

Slicers

  • Improved Slicer formatting

Visualisation

  • Better Excel Chart formatting

General

  • Protect Worksheets when downloaded to Excel
  • Option to turn off ‘Adhoc’ and ‘Analytic Books’ independently
  • SharePoint Add-ins
  • Log downloads of reports (PDF, Excel Live, Excel Fixed, PPT)