Difference between revisions of "Version 10"
(→Dynamic Charts - General) |
(→Dynamic Charts - Message Library) |
||
| Line 11: | Line 11: | ||
==Dynamic Charts - Message Library== | ==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== | ==Dynamic Charts - General== | ||
Revision as of 16:41, 9 March 2020
What's new in Version 10
Contents
[hide]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
