| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 9"
(→General) |
m ((AR)) |
||
| Line 21: | Line 21: | ||
* Maps support additional placeholders in tooltips | * Maps support additional placeholders in tooltips | ||
| − | ==Slicers== | + | ==Slicers (AR)== |
* "Apply query restrictions" available for Member Selector slicer types | * "Apply query restrictions" available for Member Selector slicer types | ||
* Slicers will now retain data types when outputting to cells - off by default in pre-v9 workbooks, can be enabled in Workbook Options | * Slicers will now retain data types when outputting to cells - off by default in pre-v9 workbooks, can be enabled in Workbook Options | ||
| − | ==Formulae== | + | ==Formulae (AR)== |
* Support more then 30 parameters on XLCubed formulae | * Support more then 30 parameters on XLCubed formulae | ||
* New function: XL3RefreshSheetObjects | * New function: XL3RefreshSheetObjects | ||
| Line 41: | Line 41: | ||
** QlikSense Desktop | ** QlikSense Desktop | ||
| − | ==Scheduling== | + | ==Scheduling (AR)== |
* Option to run schedules via scheduled task rather then using the service | * Option to run schedules via scheduled task rather then using the service | ||
Revision as of 08:54, 27 April 2016
What's new in XLCubed Version 9
Contents
[hide]Main Additions
General
Grids
- Grids can be built from any supported datasource
Tables
- Joined tables
Visualisation
- Improved layout of Treemaps
- Dashboard sheets
- Paged viewports
- Popup viewports
- Option to autos-size maps
- Maps support additional placeholders in tooltips
Slicers (AR)
- "Apply query restrictions" available for Member Selector slicer types
- Slicers will now retain data types when outputting to cells - off by default in pre-v9 workbooks, can be enabled in Workbook Options
Formulae (AR)
- Support more then 30 parameters on XLCubed formulae
- New function: XL3RefreshSheetObjects
- XL3SetProperty can now set:
- Chart Series colours
Datasources
- Additional datasources:
- Google BigQuery
- Amazon Redshift
- PowerBI Cloud
- PowerBI Desktop
- HDInsight
- QlikSense Desktop
Scheduling (AR)
- Option to run schedules via scheduled task rather then using the service
General
- Workbook option to set queryengine.ValidateMembers
- Moved to .net framework 4.5.2
- Updated format sheet - allows better control of borders.(CS)
Excel Edition
General
- Updated ribbon and UI
- Option to remember logon credentials for current Excel session
- Removed support for Excel 2003 - previous versions remain compatible
Slicers
- Reduced Excel resource usage by dimension slicers
Grids
- "Clear drills" option in member selector
- New "Scope_Isolation" option in Custom Calculations
- Option to sort named sets in member selector
Web Edition
General
- Connection Mapping includes an optional "path" attribute to allow folder-level mappings
- Option to include custom css file to override css
Formulae
- Reports published directly to SharePoint can now be used in scheduling
