Difference between revisions of "Version 10"

(Dynamic Charts - General)
(Dynamic Charts - General)
Line 24: Line 24:
  
 
==Dynamic Charts - General==
 
==Dynamic Charts - General==
Small Multiples have been renamed to DynamicCharts, and had a range of improvements  
+
Small Multiples have been renamed to DynamicCharts, and include a range of improvements  
** Dynamic Charts auto-detect legend width
+
* Dynamic Charts auto-detect legend width
** Options to have staggered labels in animated charts
+
* Options to have staggered labels in animated charts
** New Dynamic Chart ribbon for quick access to common operations
+
* New Dynamic Chart ribbon for quick access to common operations
** New formatting pane for quicker more intuitive chart formatting
+
* New formatting pane for quicker more intuitive chart formatting
** %percentage% label and tooltip option for 100% stacked chart types
+
* %percentage% label and tooltip option for 100% stacked chart types
** Improved data label layout
+
* Improved data label layout
** Support for overlaying labels and lines on charts
+
* Support for overlaying labels and lines on charts
** Better transparency support
+
* Better transparency support
  
 
==Slicers==
 
==Slicers==

Revision as of 16:41, 9 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 - Message Library

  • A new Library of Financially-focused interactive charts including
    • Absolute Variance
    • Relative Variance
    • Integrated Variance
    • Indicator Comparison
    • Offset Comparison
    • Business Scenario
    • Waterfall
    • Variance Waterfall
    • Trend Comparison
    • Trend Comparison (Cumulative)

Dynamic Charts - General

Small Multiples have been renamed to DynamicCharts, and include a range of improvements

  • Dynamic Charts auto-detect legend width
  • Options to have staggered labels in animated charts
  • New Dynamic Chart ribbon for quick access to common operations
  • New formatting pane for quicker more intuitive chart formatting
  •  %percentage% label and tooltip option for 100% stacked chart types
  • Improved data label layout
  • Support for overlaying labels and lines on charts
  • Better transparency support

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
  • Resize to fit range option on all floating controls

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