Version 9.2

What's new in Version 9.2

General

Grids

• Query timeout option

Tables

• 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

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

• 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

• Schedules can now be 'Run Now'
• Users can subscribe and unsubscribe from schedules
• 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 (*)

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 Zooming on some controls (slicers, treemaps)

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

Extensions

• SQL Connections now supported