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
• Excel "Report Viewer" option - user can't change reports but can run them
• Show Hierarchy descriptions as tooltips in Report Designer

Grids

• Support for FONT_FLAGS cube formatting
• Active cell tracking includes an option to allow clicking on members as well as data cells
• Additional options to Keep Members and create sets
• Can copy existing member selection in Member Selector
• Grids on tabular cubes support dynamically created measures.
• Member formatting will now apply to member properties
• Ability to format a member based on a member property value
• Group members option in Member Selector
• Automatically handle formatting when captions start with "["
• Improved Advanced member searching - can keep added members and running another search without leaving form
• NonEmpty advanced member selection option

Tables

• Option to Prompt for user id and password on Relational connections
• Support for more DAX table operators
• Support for dynamically created measures
• Transpose Tables

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
  • Marker style on line graph
  • Switch connection
  • Spacing
• Small Multiples - configure drill to level
• Small Multiples can output unique name or caption based on selection
• Grid In-cell charts - can switch the member that the chart is based on
• Format Sheet on network location - warning message if network drive not available

Slicers

• Slicer title can be driven from Excel range

Formulae

• XL3Link can set the tooltip
• XL3SetProperty extended:
  • Enable/Disable slicers
  • Switch Small Multiples between more chart types
• XL3SparkDotPlot

Web Edition

General

• XLCubedWeb 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
• Option for "Keep Alive" from client browser so session doesn't expire Customising web config
• Workbook option to set the "Download to Excel/PDF" filename
• Warn when leaving a report with unsaved writeback changes
• Option to auto refresh after editing cell value Workbook_Options#Web_Publication
• Connection mapping - option to not unmap when the file is saved to Excel as live
• LongQueryCancelTimeout setting
• Option to download to Excel any reports that can't be run due to errors

Formulae

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

SharePoint

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

Visualisation

• Viewports - an interactive and scrollable control which can display content held in another part of the workbook. Very useful for report layout where one or more data areas can change in size.
• Support for Pattern fills on published charts
• Improved Small Multiple default formatting
• Camera object zooming support

API

• Web API update to support multi-cell parameters