| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 10"
(→Other Visualisation) |
(→Dynamic Charts - General) |
||
| (14 intermediate revisions by 3 users not shown) | |||
| Line 13: | Line 13: | ||
==Dynamic Charts - Message Library== | ==Dynamic Charts - Message Library== | ||
A new Library of Financially-focused interactive charts including: | 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== | ==Dynamic Charts - General== | ||
Small Multiples have been renamed to DynamicCharts, and include a range of improvements | 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 | * Dynamic Charts auto-detect legend width | ||
* Options to have staggered labels in animated charts | * Options to have staggered labels in animated charts | ||
* New [[Dynamic Chart Ribbon]] for quick access to common operations | * New [[Dynamic Chart Ribbon]] for quick access to common operations | ||
* New [[Dynamic_chart_formatting_pane |formatting pane]] for quicker more intuitive chart formatting | * 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 | * Improved data label layout | ||
* Support for overlaying labels and lines on charts | * Support for overlaying labels and lines on charts | ||
| Line 46: | Line 47: | ||
=Connectivity= | =Connectivity= | ||
==Datasources== | ==Datasources== | ||
| − | * New connector for IBM TM1 / PAL | + | * New connector for IBM [[TM1]] / PAL |
* New connector for icCube | * New connector for icCube | ||
* Support for enforced SAP HANA encryption | * Support for enforced SAP HANA encryption | ||
| Line 61: | Line 62: | ||
* [[Gaps]] - easy addition of a row or column break within a grid for presentation and layout | * [[Gaps]] - easy addition of a row or column break within a grid for presentation and layout | ||
* Formatting Task pane for Dynamic Charts | * Formatting Task pane for Dynamic Charts | ||
| − | * Dynamic Chart Ribbon for common operations | + | * [[Dynamic Chart Ribbon]] for common operations |
==Slicers== | ==Slicers== | ||
| Line 67: | Line 68: | ||
==Grids== | ==Grids== | ||
| − | * Grid Calculations - new option to show | + | * 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 | * Improved Grid formatting when using subtotals | ||
| − | * Option to use alignment instead of spaces for Grid indentation | + | * 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 | * [[Gaps]] - easy addition of a row or column break within a grid for presentation and layout | ||
==Tables== | ==Tables== | ||
| − | * Option to remove leading apostrophe to allow Excel calculations from SQL | + | * [[Table_Properties#Behaviour|Option]] to remove leading apostrophe to allow Excel calculations from SQL |
==Formulae== | ==Formulae== | ||
| Line 93: | Line 94: | ||
==Scheduling== | ==Scheduling== | ||
| − | * Multisheet support for Excel output | + | * [[Multi-sheet_Web_Printing|Multisheet]] support for Excel output |
| − | * Scheduling allows reports to be run as a user, inheriting their permissions | + | * [[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 | * [[XL3SetProperty]] - option to update the datalabels of a chart from an Excel Range | ||
* XL3CubeComment() can now be edited in calculated columns | * XL3CubeComment() can now be edited in calculated columns | ||
* Improved logging of invalid calculations | * Improved logging of invalid calculations | ||
| − | * Improved | + | * 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
