Version 9.2

What's new in Version 9.2

Main Additions

General

Small Multiples

Grids

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

Tables

  • Display folder support for Tabular Analysis Services

Visualisation

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

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

Commentary

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

  • New UI: Schedules can be created within folders
  • Schedules can now be 'Run Now'
  • Several Reports can be combined to one PDF, PowerPoint or Excel output
  • 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

Dashboards

  • 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


Misc

  • Workbooks can now have Aspects defined

Excel Edition

General

  • 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

Slicers

  • Favourites - Users can now save slicer designs as favourites for re-use in other workbooks

Web Edition

General

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

Formulae

Printing

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

Extensions

  • SQL Connections now supported