Version 9.2

What's new in Version 9.2

General

Grids

• Query timeout option

Tables

• Display folder support

Small Multiples

• More user interactivity
• Animated charts
• Better chart formatting
• Improved tooltips options
• Improved drilling options
• Improved printing quaility
• Option to change major units

Visualisation

• 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

Commentary (C)

• Email notifications
• Attachments for Cube Comments
• Cube comments now show which members the comment is attached to when using "Show descendants"

Relational Connections

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

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

Dashboards

• 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

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

Web Edition

General

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

Formulae

• XL3Link and XL3WebReportLink can open links in a new window

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