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_FLAG cube formatting
• Active cell tracking includes an option to allow clicking on members as well as data cells
• New 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
• 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
• 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

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
• 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
• 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

• 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