Version 9.2

Revision as of 07:48, 26 October 2018 by Csalter (talk | contribs) (General)

What's new in Version 9.2

Main Additions



  • Query timeout option


  • Display folder support

Small Multiples

  • Better chart formatting and animation
  • Option to change major units
  • Enhanced Drilling options
  • More measures support in tooltips
  • More tooltip formatting options
  • Improved printing quaility


  • Paged Viewports: Can output active overlay index to a cell
  • Marimekko charts

Pivot BI

  • New custom visual for embedding XLCubed elements inside Power BI reports
  • Power BI Embedding in Excel allows a report to be included in a workbook

Formulae (A)

  • XL3SetProperty extended
    • Grid --> ShowDescendantComments
    • Dashboard --> Target
    • PagedViewport --> ActiveViewport
    • SmallMultipleChart/Slicer/Pager/Map/Viewport/PagedViewport/PowerBI --> Visible
    • SmallMultipleChart --> DataLabelsVisible


  • Email notifications
  • Attachments for Cube Comments
  • Cube comments allow showing which members the comment is attached to

Relational Connections

  • Custom connection string for some typed connections
  • Enhanced SQL Stored Procedure support

Scheduling (C)

  • Schedules can now be 'Run Now'
  • Schedules can be setup to allow users to subscribe and unsubscribe
  • Protected workbooks remain protected when sent
  • Emails can include report images
  • Failure emails can be sent


  • Fixed size columns and rows are indicated with an asterisk (*)
  • XL3SetProperty can set target by name and nearest match screen size

Supported backends

  • Support XL3RunSqlProc with SAP HANA
  • Better Custom Calculations support on more server types


  • Workbooks can now have Aspects defined

Excel Edition


  • Better Worksheet copying
  • Holding Shift when opening a workbook allows all Grids to be set to Design Mode
  • Support for Excel worksheet "Zoom" on some controls (slicers, treemaps)
  • Various updates for improved appearance on very high DPI machines
  • Improved control placement when loading reports on machines with different DPI to the original design machine


  • Favourites

Web Edition


  • Logging for license usage
  • .url favourites support passing through parameters



  • Transparent picture links in PowerPoint exports
  • Multi-sheet printing supports ordering of slicers
  • Add option to only allow active sheet to be printed
  • Support for "Microsoft PDF Driver"


  • SQL Connections now supported