Version 8.1

What's new in XLCubed Version 8.1

Main Additions

• Cube Comments
• Viewports
• Support for SAP HANA connections

General

• Support for "Dynamic" sets in client calculations

Grids

• Member formatting can apply to member properties
• Support for FONT_FLAG cube formatting
• Active cell tracking includes an option to allow clicking on just member
• Can copy existing member selection in Member Selector

Tables

• Option to Prompt for user id and password on Relational connections
• Support for more DAX table operators

Visualisation

• Option to format the text in Treemaps
• Can switch chart type by series
• More customisation options for Small Multiples
  • Axis titles
  • Data Labels
  • Background fill
  • Switch connection
• Small multiples - configure drill to level
• Small multiples can output unique name or caption based on selection
• Grid Incell charts - can switch member chart is based on

Slicers

• Slicer title can be driven from Excel range

Formulae

• XL3Link can set the tooltip

Web Edition

General

• web.config Option to display Reports before Sub-folders in repository view
• Support for printing header and footer images
• Ability to delete reports from the Web UI

Formulae

• Support for XL3Link to trigger "Active Cell Tracking" when linking to a grid

SharePoint

• Option to use Report path instead of Guid when embedding SQL Repository reports

Visualisation

• Support for Pattern fills on published charts
• Improved Small Multiple default formatting

API

• Web API update to support multi-cell parameters