Difference between revisions of "Version 10"
(→Dynamic Charts - Message Library) |
|||
| Line 33: | Line 33: | ||
* Support for overlaying labels and lines on charts | * Support for overlaying labels and lines on charts | ||
* Better transparency support | * Better transparency support | ||
| + | |||
| + | ==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 | ||
| + | |||
==Slicers== | ==Slicers== | ||
| Line 39: | Line 47: | ||
==Scheduling== | ==Scheduling== | ||
* Scheduling allows reports to be run as a user | * Scheduling allows reports to be run as a user | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Pivotviews== | ==Pivotviews== | ||
| Line 63: | Line 67: | ||
==Formulae== | ==Formulae== | ||
* Insert XL3Member now supports multiple connections | * Insert XL3Member now supports multiple connections | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==General== | ==General== | ||
Revision as of 16:44, 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
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
Slicers
- Option to include a search option in Treeview Slicers
Scheduling
- Scheduling allows reports to be run as a user
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
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
