| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 9"
(→General) |
(→Grids) |
||
| (46 intermediate revisions by 7 users not shown) | |||
| Line 2: | Line 2: | ||
=Main Additions= | =Main Additions= | ||
| + | * [[Dashboard sheets]] - build auto-connected, responsive, and device optimised dashboards in Excel for Web and mobile deployment. | ||
| + | * Grids can connect to [[Managing Connections|Additional datasources]] - [[SQL]], Excel and Big Data Sources. | ||
| + | * [[Paged Viewports]] - Ideal for 'panel' dashboards - Bring any part of an Excel workbook together in one dynamically switchable container. | ||
| + | * [[Viewports]] can now reference Excel charts directly, rather than the range the chart is located in. | ||
| + | * [[Data Mashup]] - to bring data from different sources together in one reporting table. | ||
| + | * UI enhancements | ||
| + | =General= | ||
| − | = | + | ==Grids now connect to additional Datasources== |
| + | * [[Grids]] can be built from any supported datasource using a [[Pivot View]] | ||
| − | + | * Additional datasources supported in v9: | |
| − | * | + | ** Microsoft SQL Server |
| + | ** Oracle Server | ||
| + | ** [[Google BigQuery]] | ||
| + | ** Amazon Redshift | ||
| + | ** [[PowerBI Cloud]] | ||
| + | ** [[PowerBI Desktop]] | ||
| + | ** HDInsight | ||
| + | ** Teradata | ||
| + | ** QlikSense Desktop | ||
| + | ** Vertica | ||
==Tables== | ==Tables== | ||
| − | * | + | * [[Data Mashup]] |
==Visualisation== | ==Visualisation== | ||
| − | * | + | * [[Dashboard sheets]] |
| − | + | * [[Paged Viewports]] | |
| − | + | * [[Viewports#Popup_Viewports|Popup Viewports]] | |
| − | * Paged | + | * [[Viewports#Chart_Viewports|Chart Viewports]] |
| − | * Popup | + | * Option to auto-size [[Maps]] |
| − | * Option to | + | * [[Maps]] support additional placeholders in tooltips |
| − | * Maps support additional placeholders in tooltips | + | * Improved layout of [[Treemaps]] |
==Slicers== | ==Slicers== | ||
| + | * "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== | ==Formulae== | ||
* Support more then 30 parameters on XLCubed formulae | * Support more then 30 parameters on XLCubed formulae | ||
| − | * New function: XL3RefreshSheetObjects | + | * New function: [[XL3RefreshSheetObjects]] |
| − | * XL3SetProperty can now set: | + | * New function: [[XL3RefreshConnections]] |
| + | * New function: [[XL3LocaliseFormatString]] | ||
| + | * [[XL3SetProperty]] can now set: | ||
** Chart Series colours | ** Chart Series colours | ||
| + | ** Pager page number | ||
| + | ** Dashboard active target | ||
| + | ** The "Protected" setting on a range | ||
| − | + | * [[XL3Link]] adds "PRINTSHEET" and "PRINTWB" to print the active sheet/workbook without prompting | |
| − | |||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Scheduling== | ==Scheduling== | ||
| − | * Option to run schedules via scheduled task rather then using the service | + | * [[Running the Scheduling Service in non-Service mode|Option to run schedules via scheduled task rather then using the service]] |
==General== | ==General== | ||
* Workbook option to set queryengine.ValidateMembers | * Workbook option to set queryengine.ValidateMembers | ||
* Moved to .net framework 4.5.2 | * Moved to .net framework 4.5.2 | ||
| − | * [[Formatting_Grids/Version_9.0 | Updated format sheet]] - allows better control of borders. | + | * [[Formatting_Grids/Version_9.0 | Updated format sheet]] - allows better control of borders.(CS) |
=Excel Edition= | =Excel Edition= | ||
| Line 54: | Line 70: | ||
==Slicers== | ==Slicers== | ||
| + | * [[Skip Levels]] for tree slicers | ||
* Reduced Excel resource usage by dimension slicers | * Reduced Excel resource usage by dimension slicers | ||
| − | |||
==Grids== | ==Grids== | ||
| + | * * [[Skip Levels]] in member selector | ||
* "Clear drills" option in member selector | * "Clear drills" option in member selector | ||
* New "Scope_Isolation" option in Custom Calculations | * New "Scope_Isolation" option in Custom Calculations | ||
* Option to sort named sets in member selector | * Option to sort named sets in member selector | ||
| + | * Option to turn off "Refresh when slicers change", similar to "Refresh when driving ranges change" | ||
=Web Edition= | =Web Edition= | ||
| Line 67: | Line 85: | ||
* [[Connection Mapping]] includes an optional "path" attribute to allow folder-level mappings | * [[Connection Mapping]] includes an optional "path" attribute to allow folder-level mappings | ||
* Option to include custom css file to override css | * Option to include custom css file to override css | ||
| + | * New [[SQL Repository]] options | ||
==Formulae== | ==Formulae== | ||
Latest revision as of 11:48, 19 October 2016
What's new in XLCubed Version 9
Contents
[hide]Main Additions
- Dashboard sheets - build auto-connected, responsive, and device optimised dashboards in Excel for Web and mobile deployment.
- Grids can connect to Additional datasources - SQL, Excel and Big Data Sources.
- Paged Viewports - Ideal for 'panel' dashboards - Bring any part of an Excel workbook together in one dynamically switchable container.
- Viewports can now reference Excel charts directly, rather than the range the chart is located in.
- Data Mashup - to bring data from different sources together in one reporting table.
- UI enhancements
General
Grids now connect to additional Datasources
- Grids can be built from any supported datasource using a Pivot View
- Additional datasources supported in v9:
- Microsoft SQL Server
- Oracle Server
- Google BigQuery
- Amazon Redshift
- PowerBI Cloud
- PowerBI Desktop
- HDInsight
- Teradata
- QlikSense Desktop
- Vertica
Tables
Visualisation
- Dashboard sheets
- Paged Viewports
- Popup Viewports
- Chart Viewports
- Option to auto-size Maps
- Maps support additional placeholders in tooltips
- Improved layout of Treemaps
Slicers
- "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
- Support more then 30 parameters on XLCubed formulae
- New function: XL3RefreshSheetObjects
- New function: XL3RefreshConnections
- New function: XL3LocaliseFormatString
- XL3SetProperty can now set:
- Chart Series colours
- Pager page number
- Dashboard active target
- The "Protected" setting on a range
- XL3Link adds "PRINTSHEET" and "PRINTWB" to print the active sheet/workbook without prompting
Scheduling
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
- Skip Levels for tree slicers
- Reduced Excel resource usage by dimension slicers
Grids
- * Skip Levels in member selector
- "Clear drills" option in member selector
- New "Scope_Isolation" option in Custom Calculations
- Option to sort named sets in member selector
- Option to turn off "Refresh when slicers change", similar to "Refresh when driving ranges change"
Web Edition
General
- Connection Mapping includes an optional "path" attribute to allow folder-level mappings
- Option to include custom css file to override css
- New SQL Repository options
Formulae
- Reports published directly to SharePoint can now be used in scheduling
