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