XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Version 9"

m
(→‎Grids)
 
(20 intermediate revisions by 5 users not shown)
Line 3: Line 3:
 
=Main Additions=
 
=Main Additions=
 
* [[Dashboard sheets]] - build auto-connected, responsive, and device optimised dashboards in Excel for Web and mobile deployment.
 
* [[Dashboard sheets]] - build auto-connected, responsive, and device optimised dashboards in Excel for Web and mobile deployment.
−
* Additional datasource support - Connnect an XLCubed Grid to SQL, Excel and Big Data Sources.
+
* 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.
 
* [[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.
 
* [[Data Mashup]] - to bring data from different sources together in one reporting table.
 
* UI enhancements
 
* UI enhancements
Line 10: Line 11:
 
=General=
 
=General=
  
−
==Grids==
+
==Grids now connect to additional Datasources==
 
* [[Grids]] can be built from any supported datasource using a [[Pivot View]]
 
* [[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==
Line 17: Line 30:
  
 
==Visualisation==
 
==Visualisation==
−
* Improved layout of [[Treemaps]]
 
 
* [[Dashboard sheets]]
 
* [[Dashboard sheets]]
 
* [[Paged Viewports]]
 
* [[Paged Viewports]]
Line 24: Line 36:
 
* Option to auto-size [[Maps]]
 
* Option to auto-size [[Maps]]
 
* [[Maps]] support additional placeholders in tooltips
 
* [[Maps]] support additional placeholders in tooltips
 +
* Improved layout of [[Treemaps]]
  
 
==Slicers==
 
==Slicers==
Line 36: Line 49:
 
* [[XL3SetProperty]] can now set:
 
* [[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
 
* [[XL3Link]] adds "PRINTSHEET" and "PRINTWB" to print the active sheet/workbook without prompting
−
 
−
==Datasources==
 
−
 
−
* Additional datasources:
 
−
** Google BigQuery
 
−
** Amazon Redshift
 
−
** PowerBI Cloud
 
−
** PowerBI Desktop
 
−
** HDInsight
 
−
** QlikSense Desktop
 
  
 
==Scheduling==
 
==Scheduling==
Line 63: 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=

Latest revision as of 11:48, 19 October 2016

What's new in XLCubed Version 9

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

Tables

Visualisation

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

  • 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

SharePoint

  • Reports published directly to SharePoint can now be used in scheduling

Visualisation

API

Retrieved from ‘https://help.xlcubed.com/index.php?title=Version_9&oldid=7742’