Version 10

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

Dynamic Charts - General

• 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
• 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