Difference between revisions of "Version 9.2"

(Main Additions)
 
(17 intermediate revisions by 5 users not shown)
Line 2: Line 2:
  
 
=Main Additions=
 
=Main Additions=
*[[Small Multiple Charts#Zooming|Interactive Charts & Small Multiples]]
+
*[[Small Multiple Charts#Zooming|Interactive animated Charts and Small Multiples]]
*[[Small Multiple Charts#Animated Charts|Animated charts]]
+
* [[Alerts|Commentary - Email notifications and subscriptions]]
*Power BI Custom Visuals - New custom visuals for embedding Grids, Reports and Small Multiple Charts inside Power BI reports
+
* Connector for Oracle [[Essbase]]
* Addition of  Marimekko charts
+
*[[PowerBI Visual| Power BI - New Custom Visuals]] for embedding Grids, Reports and Small Multiple Charts in Power BI
 +
* [[Alerts|Commentary - Subscriptions and Email notifications]]
 +
* Scheduling - Several Reports can be combined to one PDF, PowerPoint or Excel output
 +
* Schedules can be setup to allow users to [[Manage Schedules#Subscriptions|subscribe and unsubscribe]]
  
 
=General=
 
=General=
Line 33: Line 36:
 
* [[Power BI Embedding in Excel]] allows a report to be included in a workbook
 
* [[Power BI Embedding in Excel]] allows a report to be included in a workbook
  
==Formulae (A)==
+
==Formulae ==
 
* [[XL3SetProperty]] extended
 
* [[XL3SetProperty]] extended
 
** Grid --> ShowDescendantComments
 
** Grid --> ShowDescendantComments
Line 41: Line 44:
 
** SmallMultipleChart --> DataLabelsVisible
 
** SmallMultipleChart --> DataLabelsVisible
  
==Commentary (C)==
+
==Commentary==
 
* [[Alerts|Email notifications]]
 
* [[Alerts|Email notifications]]
 
* Attachments for [[Cube Comments]]
 
* Attachments for [[Cube Comments]]
Line 51: Line 54:
 
* Enhanced SQL Stored Procedure support in the [[SQL_Data_Tables_(Administrators)#Using Stored Procedures|query designer]]
 
* Enhanced SQL Stored Procedure support in the [[SQL_Data_Tables_(Administrators)#Using Stored Procedures|query designer]]
  
==[[Scheduling]] (C)==
+
==[[Scheduling]]==
 
* [[Manage Schedules|New UI]]: Schedules can be created within folders
 
* [[Manage Schedules|New UI]]: Schedules can be created within folders
 
* Schedules can now be '[[Manage Schedules#Embedding Images|Run Now]]'
 
* Schedules can now be '[[Manage Schedules#Embedding Images|Run Now]]'
 +
* Several Reports can be combined to one PDF, PowerPoint or Excel output
 
* Schedules can be setup to allow users to [[Manage Schedules#Subscriptions|subscribe and unsubscribe]]  
 
* Schedules can be setup to allow users to [[Manage Schedules#Subscriptions|subscribe and unsubscribe]]  
 
* Protected workbooks remain protected when sent
 
* Protected workbooks remain protected when sent
Line 70: Line 74:
  
 
==Misc==
 
==Misc==
* Workbooks can now have Aspects defined
+
* Workbooks can now have [[Workbook_Aspects|Aspects]] defined
  
 
=Excel Edition=
 
=Excel Edition=
Line 100: Line 104:
 
==Extensions==
 
==Extensions==
 
* SQL Connections now supported
 
* SQL Connections now supported
 +
 +
[[Category: Versions]]

Latest revision as of 08:29, 15 April 2019

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