| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 9.2"
(→Grids) |
(→General) |
||
| Line 4: | Line 4: | ||
=General= | =General= | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Small Multiples== | ==Small Multiples== | ||
| Line 19: | Line 13: | ||
* Improved printing quaility | * Improved printing quaility | ||
* Option to change major units | * Option to change major units | ||
| + | * Addition of Marimekko charts | ||
| + | |||
| + | ==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== | ==Visualisation== | ||
* [[Paged Viewports]]: Can output active overlay index to a cell | * [[Paged Viewports]]: Can output active overlay index to a cell | ||
| − | |||
| − | == | + | ==Power BI== |
* New custom visual for embedding XLCubed elements inside Power BI reports | * 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 | * [[Power BI Embedding in Excel]] allows a report to be included in a workbook | ||
| Line 58: | Line 59: | ||
* XL3SetProperty can set target by name and nearest match screen size | * XL3SetProperty can set target by name and nearest match screen size | ||
| − | == | + | ==Data Connectivity== |
| + | * Addition of Oracle Essbase connector | ||
* Support [[XL3RunSQLProc]] with SAP HANA | * Support [[XL3RunSQLProc]] with SAP HANA | ||
* Better Custom Calculations support on more server types | * Better Custom Calculations support on more server types | ||
| + | |||
==Misc== | ==Misc== | ||
Revision as of 15:28, 5 November 2018
What's new in Version 9.2
Contents
[hide]Main Additions
General
Small Multiples
- More user interactivity
- Animated charts
- Better chart formatting
- Improved tooltips options
- Improved drilling options
- Improved printing quaility
- Option to change major units
- Addition of Marimekko charts
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
- Paged Viewports: Can output active overlay index to a cell
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)
- 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
- 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
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
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
- 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
