Difference between revisions of "Version 9.2"

(Main Additions)
(Main Additions)
Line 2: Line 2:
=Main Additions=
=Main Additions=
==Interactive Charting & Small Multiples==
*[[Small Multiple Charts#Zooming|Interactive Charts & Small Multiples]]
*[[Small Multiple Charts#Zooming|More user interactivity]]
*[[Small Multiple Charts#Animated Charts|Animated charts]]
*[[Small Multiple Charts#Animated Charts|Animated charts]]
*Better chart formatting
*Better chart formatting

Revision as of 16:35, 5 November 2018

What's new in Version 9.2

Main Additions


Small Multiples


  • Compact mode - Display row members in a single column for drilldown reports.
  • Query timeout option can be set in the Managing Connections screen.


  • Display folder support for Tabular Analysis Services


Power 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

Commentary (C)

Relational Connections

  • Custom connection string for some typed connections
    • This allows and type-specific features to be used with custom connection strings
  • Enhanced SQL Stored Procedure support in the query designer

Scheduling (C)

  • New UI: Schedules can be created within folders
  • 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

Data Connectivity

  • Addition of Oracle Essbase connector
  • 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 - Users can now save slicer designs as favourites for re-use in other workbooks

Web Edition


  • Logging for license usage
  • .url favourites support passing through parameters
  • Connection details are encrypted by default when sent to the browser



  • 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