Difference between revisions of "Version 8"
| Line 34: | Line 34: | ||
* Named range support - named ranges can be used as the source for any range driven items and will stay linked to the named range | * Named range support - named ranges can be used as the source for any range driven items and will stay linked to the named range | ||
* Right-click menu speed up in Excel 2013 | * Right-click menu speed up in Excel 2013 | ||
| − | + | * Import & Export custom calculations | |
==Grids== | ==Grids== | ||
* Back and forward controls on Grids | * Back and forward controls on Grids | ||
| + | * Option for non-pinned grid calculations (i.e. always show at position x) | ||
| + | |||
==Tables== | ==Tables== | ||
==Visualisation== | ==Visualisation== | ||
| − | |||
* Cube-based Treemaps: size and colour can be driven from an Excel Range | * Cube-based Treemaps: size and colour can be driven from an Excel Range | ||
| − | * Small multiples: Can apply number format to y-axis | + | * Small multiples: Can apply number format to x and y-axis |
* Small multiples: Option to hide border | * Small multiples: Option to hide border | ||
| + | * Small multiples: data driven x-axis min and max values | ||
| + | * Small multiples: More options for customising formatting and spacing | ||
* New incell chart: SparkHeatmap | * New incell chart: SparkHeatmap | ||
| + | * Mapping can support custom images, via webservice URL | ||
| Line 52: | Line 56: | ||
* Workbook level slicers - taskpane shows common slicers when changing worksheet | * Workbook level slicers - taskpane shows common slicers when changing worksheet | ||
* Improved printing from Excel | * Improved printing from Excel | ||
| + | * Resize and reposition several slicers at the same time | ||
| Line 60: | Line 65: | ||
==SQL== | ==SQL== | ||
| + | * Centralised connections - all formula take a connection id and any SQL driven objects use the same central connection, so they can be edited under: Manage Connections | ||
| + | |||
| + | |||
=Web Edition= | =Web Edition= | ||
==General== | ==General== | ||
| + | * New option to hides sheet tabs after publishing | ||
Revision as of 16:18, 4 August 2014
What's new in XLCubed Version 8.
Contents
[hide]Main Additions
Enhanced User Interface for XLCubed Web Edition
Richer Control and Operational Reporting option for XLCubed Web Enterprise. Reports can now be published to an SQL database rather than fileshare, which provides for more straightforward security management, report version control, and operational reporting on usage etc.
XLCubed Scheduling Enhancements
Multi-sheet Web Printing - this is a new option to allow for Propagate Across Sheets style printing and saving to Excel from the Web Edition, producing multi-paged PDFs or multi-sheet workbooks from a single worksheet.
Slicer Enhancements
- Workbook Level Slicer Control
- Increased Formatting control
- Time Slider Slicer Type
General Navigation
- Back & Forward controls on Grids
- 'Apply' button in member selector to see changes applied without leaving dialog
- QuickSearch for hierarchies
- Workbook Explorer to show overall report structure and build up
Data Visualisation
- Bump Charts - to show changes in rank position over time
- Heatmaps - XL3SparkHeatMap() formula
Connectivity
- SAP HANA odbo connector
- Teradata available as new SQL connection
General
- Hold shift on open to handle invalid members or temporarily disable XLCubed functionality
- Named range support - named ranges can be used as the source for any range driven items and will stay linked to the named range
- Right-click menu speed up in Excel 2013
- Import & Export custom calculations
Grids
- Back and forward controls on Grids
- Option for non-pinned grid calculations (i.e. always show at position x)
Tables
Visualisation
- Cube-based Treemaps: size and colour can be driven from an Excel Range
- Small multiples: Can apply number format to x and y-axis
- Small multiples: Option to hide border
- Small multiples: data driven x-axis min and max values
- Small multiples: More options for customising formatting and spacing
- New incell chart: SparkHeatmap
- Mapping can support custom images, via webservice URL
Slicers
- Workbook level slicers - taskpane shows common slicers when changing worksheet
- Improved printing from Excel
- Resize and reposition several slicers at the same time
Formulae
- XL3MemberNavigate - new option for "Parent at level"
- Flex Reporting - supports paths from the same hierarchy
SQL
- Centralised connections - all formula take a connection id and any SQL driven objects use the same central connection, so they can be edited under: Manage Connections
Web Edition
General
- New option to hides sheet tabs after publishing
