| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 10"
(Created page with "What's new in Version 10 =General= ==Scheduling== * Scheduling allows reports to be run as a user =Excel Edition= ==Grids== * Breakouts now supported on translated grids *...") |
(→Dynamic Charts - General) |
||
| (71 intermediate revisions by 7 users not shown) | |||
| Line 1: | Line 1: | ||
What's new in 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: | ||
| + | * [[Business Charts#Absolute Variance|Absolute Variance]] | ||
| + | * [[Business Charts#Relative Variance (%)|Relative Variance]] | ||
| + | * [[Business Charts#Integrated Variance|Integrated Variance]] | ||
| + | * [[Business Charts#Indicator Comparison|Indicator Comparison]] | ||
| + | * [[Business Charts#Offset Comparison|Offset Comparison]] | ||
| + | * [[Business Charts#Business Scenario|Business Scenario]] | ||
| + | * [[Business Charts#Waterfall|Waterfall]] | ||
| + | * [[Business Charts#Variance Waterfall|Variance Waterfall]] | ||
| + | * [[Business Charts#Trend Comparison|Trend Comparison]] | ||
| + | * [[Business Charts#Trend Comparison (Cumulative)|Trend Comparison (Cumulative)]] | ||
| + | |||
| + | ==Dynamic Charts - General== | ||
| + | Small Multiples have been renamed to DynamicCharts, and include a range of improvements | ||
| + | * New Message Chart Options area of the [[Dynamic Chart Designer|Dynamic Chart designer]] | ||
| + | * 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 [[Dynamic_chart_formatting_pane |formatting pane]] for quicker more intuitive chart formatting | ||
| + | * %percent% 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: [[Comparison Chart Designer|Comparison 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= | =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== | ==Grids== | ||
| − | * | + | * Grid Calculations - new option to show calculation 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_Properties#Drilling|Grid]] indentation | ||
| + | * [[Gaps]] - easy addition of a row or column break within a grid for presentation and layout | ||
| + | ==Tables== | ||
| + | * [[Table_Properties#Behaviour|Option]] to remove leading apostrophe to allow Excel calculations from SQL | ||
==Formulae== | ==Formulae== | ||
| − | * Insert XL3Member now | + | * 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== | ==Slicers== | ||
| − | |||
* Improved Slicer formatting | * Improved Slicer formatting | ||
| − | == | + | ==Grids== |
| − | * | + | * Writeback to grids in a viewport now supported |
| − | * | + | |
| + | ==Scheduling== | ||
| + | * [[Multi-sheet_Web_Printing|Multisheet]] support for Excel output | ||
| + | * [[Scheduling]] allows reports to be run as a user, inheriting their permissions | ||
==General== | ==General== | ||
| − | |||
| − | |||
* Protect Worksheets when downloaded to Excel | * Protect Worksheets when downloaded to Excel | ||
| − | * | + | * [[Customising web config]] - option to turn off ‘Adhoc’ and ‘Analytic Books’ functionality independently |
| − | |||
* Log downloads of reports (PDF, Excel Live, Excel Fixed, PPT) | * 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 operational dashboards to show system usage | ||
Latest revision as of 08:15, 20 April 2021
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
- 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
- New Message Chart Options area of the Dynamic Chart designer
- 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
- %percent% 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: Comparison 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 calculation 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
- Customising web config - 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 operational dashboards to show system usage
