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
• Formatting and usability improvements to Small Multiples (now 'Dynamic Charts')
• Support for IBM TM1, for both reporting and planning and budgeting
• Gaps - easily add row and column breaks to XLCubed Grids for spacing and presentation
• Member Search Option for Treeview Slicers
• SSO support for XLCubedWeb

Charting & Data Visualisation

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
• Improved Drilling
• Improved Printing

Other Visualisation

• New In-Cell chart: Compare charts
• Maps now support data labels
• Improved chart formatting
• Resize to fit range option on all floating controls
• Improved publication support for standard Excel waterfall charts

Connectivity

Datasources

• New connector for IBM TM1 / PAL
• New connector for icCube
• Support for enforced SAP HANA encryption
• Breakout support for SAP HANA grids
• Improved support for SAP HANA parameters

PivotViews

• Improved startup and query performance
• Allow parameter definitions for SQL Driven pivotviews

General

Usability

• Gaps - easy addition of a row or column break within a grid for presentation and layout
• Formatting Task pane for Dynamic Charts
• Dynamic Chart Ribbon for common operations

Slicers

• Option to include a search option in Treeview Slicers

Grids

• Grid Calculations - new option to show calcuation title in the first row of the members for cross-joined grids
• Improved Grid formatting when using subtotals
• Option to use alignment instead of spaces for Grid indentation
• Gaps - easy addition of a row or column break within a grid for presentation and layout

Tables

• Option to remove leading apostrophe to allow Excel calculations from SQL

Formulae

• Insert XL3Member now allows switching connection

General

• Improved property searching
• Comment Frames can now be copied
• Improved very high-dpi handling
• Installation includes sample reports

Web Edition Specific additions

Slicers

• Improved Slicer formatting

Grids

• Writeback to grids in a viewport now supported

Scheduling

• Multisheet support for Excel output
• Scheduling allows reports to be run as a user, inheriting their permissions

General

• Protect Worksheets when downloaded to Excel
• Option to turn off ‘Adhoc’ and ‘Analytic Books’ functionality 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