Version 8

What's new in XLCubed Version 8.

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

Grids

• Back and forward controls on Grids

Visualisation

• Cube-based Treemaps: size and colour can be driven from an Excel Range
• Small multiples: Can apply number format to y-axis
• Small multiples: Option to hide border
• New incell chart: SparkHeatmap

Slicers

• Workbook level slicers - taskpane shows common slicers when changing worksheet
• Improved printing from Excel

Formulae

• XL3MemberNavigate - new option for "Parent at level"
• Flex Reporting - supports paths from the same hierarchy