| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 9.2"
(→Relational Connections) |
(→Data Connectivity) |
||
| (30 intermediate revisions by 6 users not shown) | |||
| Line 2: | Line 2: | ||
=Main Additions= | =Main Additions= | ||
| + | *[[Small Multiple Charts#Zooming|Interactive animated Charts and Small Multiples]] | ||
| + | * [[Alerts|Commentary - Email notifications and subscriptions]] | ||
| + | * Connector for Oracle [[Essbase]] | ||
| + | *[[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= | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Small Multiples== | ==Small Multiples== | ||
| Line 18: | Line 20: | ||
* 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 | ||
| − | ==Formulae | + | ==Formulae == |
* [[XL3SetProperty]] extended | * [[XL3SetProperty]] extended | ||
** Grid --> ShowDescendantComments | ** Grid --> ShowDescendantComments | ||
| Line 35: | Line 44: | ||
** SmallMultipleChart --> DataLabelsVisible | ** SmallMultipleChart --> DataLabelsVisible | ||
| − | ==Commentary | + | ==Commentary== |
* [[Alerts|Email notifications]] | * [[Alerts|Email notifications]] | ||
* Attachments for [[Cube Comments]] | * Attachments for [[Cube Comments]] | ||
| Line 45: | 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]] | + | ==[[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# | + | * Schedules can now be '[[Manage Schedules#Allow Recipients To Run On Demand|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 57: | Line 67: | ||
* XL3SetProperty can set target by name and nearest match screen size | * XL3SetProperty can set target by name and nearest match screen size | ||
| − | == | + | ==Data Connectivity== |
| − | * Support | + | * Addition of Oracle Essbase connector |
| + | * Support [[XL3RunSQLProc]] with SAP HANA | ||
* Better Custom Calculations support on more server types | * Better Custom Calculations support on more server types | ||
| + | * Support for [[IcCube]] | ||
==Misc== | ==Misc== | ||
| − | * Workbooks can now have Aspects defined | + | * Workbooks can now have [[Workbook_Aspects|Aspects]] defined |
=Excel Edition= | =Excel Edition= | ||
| Line 73: | Line 85: | ||
==Slicers== | ==Slicers== | ||
| − | * Favourites | + | * Favourites - Users can now save slicer designs as favourites for re-use in other workbooks |
=Web Edition= | =Web Edition= | ||
| Line 79: | Line 91: | ||
* Logging for license usage | * Logging for license usage | ||
* .url favourites support passing through parameters | * .url favourites support passing through parameters | ||
| + | * Connection details are encrypted by default when sent to the browser | ||
==Formulae== | ==Formulae== | ||
| Line 91: | Line 104: | ||
==Extensions== | ==Extensions== | ||
* SQL Connections now supported | * SQL Connections now supported | ||
| + | |||
| + | [[Category: Versions]] | ||
Latest revision as of 10:56, 14 November 2019
What's new in Version 9.2
Contents
[hide]Main Additions
- Interactive animated Charts and Small Multiples
- Commentary - Email notifications and subscriptions
- Connector for Oracle Essbase
- Power BI - New Custom Visuals for embedding Grids, Reports and Small Multiple Charts in Power BI
- 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 subscribe and unsubscribe
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
- 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 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
- 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
- Support for IcCube
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
- 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
