Difference between revisions of "Version 8"
(→General) |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (48 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
| − | What's new in | + | What's new in FluenceXL Version 8. |
=Main Additions= | =Main Additions= | ||
| − | Enhanced User Interface for | + | [[Web HomePage|Enhanced User Interface]] for FluenceXL Web Edition |
| − | [[Richer Control and Operational Reporting]] option for | + | [[SQL Repository|Richer Control and Operational Reporting]] option for FluenceXL Web Enterprise. Reports can now be published to an SQL database rather than fileshare, which provides for more straightforward security management, report version control, and operational reporting on usage etc. |
| − | + | [[Scheduling|FluenceXL Scheduling]] enhancements | |
[[Multi-sheet Web Printing]] - this is a new option to allow for [[Propagate Across Sheets]] style printing and saving to Excel from the Web Edition, producing multi-paged PDFs or multi-sheet workbooks from a single worksheet. | [[Multi-sheet Web Printing]] - this is a new option to allow for [[Propagate Across Sheets]] style printing and saving to Excel from the Web Edition, producing multi-paged PDFs or multi-sheet workbooks from a single worksheet. | ||
| Line 13: | Line 13: | ||
Slicer Enhancements | Slicer Enhancements | ||
* [[Workbook Slicers|Workbook Level Slicer Control]] | * [[Workbook Slicers|Workbook Level Slicer Control]] | ||
| − | * | + | * Greater control over[[Dimension Slicers#Alignment options (new in v8.0)| formatting, sizing and alignment]] |
| − | * Time Slider | + | * [[Time Slider]] slicer type |
| − | General Navigation | + | General Navigation and usability enhancements |
| − | * Back & Forward controls on Grids | + | * [[Back & Forward]] controls on Grids |
| − | * | + | * [[Apply]] button in member selector to see changes applied without leaving dialog |
| − | * QuickSearch for hierarchies | + | * [[QuickSearch]] for hierarchies |
| − | * Workbook Explorer to show overall report structure and build up | + | * [[Workbook Explorer]] to show overall report structure and build up |
| − | * Dependency Explorer to show which parts of the report will be run when published | + | * [[Dependency Explorer]] to show which parts of the report will be run when published |
Data Visualisation | Data Visualisation | ||
| Line 27: | Line 27: | ||
Connectivity | Connectivity | ||
| − | * SAP [[HANA]] odbo connector | + | * SAP [[HANA]] odbo connector (available as beta with teh release of V8) |
* Teradata available as new SQL connection | * Teradata available as new SQL connection | ||
=General= | =General= | ||
| − | * Hold shift | + | * [[Advanced Workbook Open Options]] - Hold shift when opening a workbook to handle invalid members or temporarily disable FluenceXL functionality |
* Named range support - named ranges can be used as the source for any range driven items and will stay linked to the named range | * Named range support - named ranges can be used as the source for any range driven items and will stay linked to the named range | ||
* Right-click menu speed up in Excel 2013 | * Right-click menu speed up in Excel 2013 | ||
| − | * Import & Export custom calculations | + | * [[MDX Calculations#Importing and Exporting calculations|Import & Export custom calculations]] |
| − | * Search in Custom | + | * Search in Custom Calculations |
| − | * Support for [[ | + | * Support for [[MDX Calculations#Custom Scripts|SCOPE]] in custom calculation scripts |
* Pagers can input and output entirely to Excel ranges | * Pagers can input and output entirely to Excel ranges | ||
* Bulk edit properties - edit properties for several grids/slicers etc at the same time | * Bulk edit properties - edit properties for several grids/slicers etc at the same time | ||
| − | * Workbook | + | * [[Workbook Explorer]]: gives an overview of all the objects in a workbook |
* [[Workbook Design Mode|Design Mode]]: edit grid layout without running any queries | * [[Workbook Design Mode|Design Mode]]: edit grid layout without running any queries | ||
* Copy and Paste lists into editable cells on the web | * Copy and Paste lists into editable cells on the web | ||
| Line 46: | Line 46: | ||
==Grids== | ==Grids== | ||
* Back and forward controls on Grids | * Back and forward controls on Grids | ||
| − | * Option for non-pinned | + | * Option for non-pinned [[Grid Calculations]] (i.e. always show at position x) |
| − | * New option for member search: "Does not include" | + | * [[Grid Calculations]] can be re-ordered |
| − | + | * New option for [[Set Searching|member search]]: "Does not include" | |
* Support [[Aliases|aliasing]], to rename dimensions and members | * Support [[Aliases|aliasing]], to rename dimensions and members | ||
* Option to display member property instead of member caption in all dialogs and results | * Option to display member property instead of member caption in all dialogs and results | ||
| − | * "Apply" button on member selector | + | * "Apply" button on [[Hierarchy Editor|member selector]] |
| − | * Filter measure can be range driven | + | * [[Ranking, Sorting and Filtering#Driving Reports from Excel|Filter measure can be range driven]] |
| − | * | + | * Grid Charts: [[Grid Charts#Show Highest Members|highest level option]] |
| − | * "Order By" member property in advanced sorting | + | * "Order By" member property in [[Ranking, Sorting and Filtering|advanced sorting]] |
| − | * | + | * [[Outlier Grouping]] - option to always include a specified member (either in the ranking/filtering or as an additional row) |
| − | * Option to format | + | * Option to format [[Level based formatting#New syntax for FluenceXL V8|Leaf]] members in a grid |
| − | * New option to select "Default Member" in member selections | + | * New option to select the "Default Member" in member selections |
| + | ** A new toolbar button on the advanced tab of the member selector | ||
* Grid Ribbon: new option to create grouped members and named sets | * Grid Ribbon: new option to create grouped members and named sets | ||
| Line 64: | Line 65: | ||
==Visualisation== | ==Visualisation== | ||
| − | * Cube-based Treemaps: size and colour can be driven from an Excel Range | + | * Cube-based [[Treemaps]]: size and colour can be driven from an Excel Range |
| − | * Small multiples: Can apply number format to x and y-axis | + | * Treemaps: Specify [[Treemaps | formatting]] of treemaps |
| + | * [[Small Multiple Charts|Small multiples]]: Can apply number format to x and y-axis | ||
* Small multiples: Option to hide border | * Small multiples: Option to hide border | ||
* Small multiples: data driven x-axis min and max values | * Small multiples: data driven x-axis min and max values | ||
| − | * Small multiples: | + | * Small multiples: New [[Bump Charts]] chart type |
| − | |||
| − | |||
* Maps: option to select colour for "Blank" values | * Maps: option to select colour for "Blank" values | ||
| − | * Heatmaps - XL3SparkHeatMap() formula | + | * New [[Category:In-Cell Charts|in-cell chart]]: [[SparkHeatMap Chart Designer|SparkHeatMap]] |
| − | + | * Heatmaps - [[XL3SparkHeatMap]]() formula | |
==Slicers== | ==Slicers== | ||
| − | * Workbook | + | * [[Workbook Slicers|Workbook Level slicers]] - taskpane shows common slicers when changing worksheet |
* Improved printing from Excel | * Improved printing from Excel | ||
| − | * Resize and reposition several slicers at the same time | + | * [[Dimension Slicers#Alignment options (new in v8.0)|Resize and reposition several slicers at the same time]] |
* "Multi-select" option on Combobox slicers | * "Multi-select" option on Combobox slicers | ||
* Option on Button slicers to show members with no-data as "Disabled" button | * Option on Button slicers to show members with no-data as "Disabled" button | ||
* Tree slicers can now create a hierarchy from column based hierarchies | * Tree slicers can now create a hierarchy from column based hierarchies | ||
| − | * | + | * [[Time Slider]] slicer type |
| − | * "Initial value" can now be a range containing an "MDXSET:" | + | * [[Dimension Slicers#Initial Value|"Initial value"]] can now be a range containing an "MDXSET:" |
| + | * Dimension Slicers: [[Dimension Slicers| Alignment Options]] | ||
==Formulae== | ==Formulae== | ||
* [[XL3MemberNavigate]] - new option for "Parent at level" | * [[XL3MemberNavigate]] - new option for "Parent at level" | ||
| − | * Flex Reporting - supports paths from the same hierarchy | + | * [[Flex Reporting]] - supports paths from the same hierarchy |
* [[XL3SetProperty]] - can control a chart's visibility. | * [[XL3SetProperty]] - can control a chart's visibility. | ||
* [[XL3LastCubeUpdate]] - new "Format" paramter to control date/time format | * [[XL3LastCubeUpdate]] - new "Format" paramter to control date/time format | ||
| Line 95: | Line 96: | ||
==SQL== | ==SQL== | ||
| − | * Centralised connections - all formula take a connection id and any SQL driven objects use the same central connection, so they can be edited under | + | * Centralised connections - all formula take a connection id and any SQL driven objects use the same central connection, so they can be edited under the standard [[Managing Connections|Manage Connections form]] |
| − | * Added support for " | + | * Added support for "Teradata" to the SQL Connection form |
==Scheduling== | ==Scheduling== | ||
| Line 103: | Line 104: | ||
=Web Edition= | =Web Edition= | ||
==General== | ==General== | ||
| − | * New | + | * New improved look and feel |
| − | * | + | * [[SQL Repository]] |
| + | * Custom or automatic preview images of reports | ||
| + | * Option to view: Most recent, Most viewed, Popular and Bookmarked reports on the homepage | ||
| + | * Add support for including a custom logo | ||
| + | * [[Set Searching | Advanced Member searching]] option | ||
* Web edition connection history can be edited | * Web edition connection history can be edited | ||
| + | ** From the Options -> [[FluenceXL Options]] form | ||
* Retain chart names when saving back into Excel | * Retain chart names when saving back into Excel | ||
* Support for Excel data validation | * Support for Excel data validation | ||
| − | * Mutli-line editing for unlocked cells | + | * Mutli-line editing for unlocked cells on the web |
| − | * Connection | + | ** Ctrl+Enter creates a new line |
| − | * | + | * [[Connection Mapping]] support for SQL Connections |
| − | * New | + | * [[Dependency Explorer]] - check sheet calculation dependencies from Excel |
| − | + | * New option to [[Workbook Options | Hide Sheet Tabs]] when publishing | |
| − | * [[ | + | |
| + | ==Formulae== | ||
| + | * Support for over 70 additional Excel formulae. See the [[New FluenceXL Web Edition Formulae (Version 8.0)]] page for details. | ||
| + | |||
| + | ==SharePoint== | ||
| + | * Support for saving reports when viewing them in SharePoint | ||
| + | * Support for adhoc grids | ||
| + | * Support for Analytic Books | ||
| + | * Option to enable Mobile app access to SharePoint published reports | ||
Latest revision as of 09:39, 4 July 2023
What's new in FluenceXL Version 8.
Contents
[hide]Main Additions
Enhanced User Interface for FluenceXL Web Edition
Richer Control and Operational Reporting option for FluenceXL Web Enterprise. Reports can now be published to an SQL database rather than fileshare, which provides for more straightforward security management, report version control, and operational reporting on usage etc.
FluenceXL Scheduling enhancements
Multi-sheet Web Printing - this is a new option to allow for Propagate Across Sheets style printing and saving to Excel from the Web Edition, producing multi-paged PDFs or multi-sheet workbooks from a single worksheet.
Slicer Enhancements
- Workbook Level Slicer Control
- Greater control over formatting, sizing and alignment
- Time Slider slicer type
General Navigation and usability enhancements
- Back & Forward controls on Grids
- Apply button in member selector to see changes applied without leaving dialog
- QuickSearch for hierarchies
- Workbook Explorer to show overall report structure and build up
- Dependency Explorer to show which parts of the report will be run when published
Data Visualisation
- Bump Charts - to show changes in rank position over time
Connectivity
- SAP HANA odbo connector (available as beta with teh release of V8)
- Teradata available as new SQL connection
General
- Advanced Workbook Open Options - Hold shift when opening a workbook to handle invalid members or temporarily disable FluenceXL functionality
- Named range support - named ranges can be used as the source for any range driven items and will stay linked to the named range
- Right-click menu speed up in Excel 2013
- Import & Export custom calculations
- Search in Custom Calculations
- Support for SCOPE in custom calculation scripts
- Pagers can input and output entirely to Excel ranges
- Bulk edit properties - edit properties for several grids/slicers etc at the same time
- Workbook Explorer: gives an overview of all the objects in a workbook
- Design Mode: edit grid layout without running any queries
- Copy and Paste lists into editable cells on the web
- Accepts lists in plain text or ranges copied from Excel.
Grids
- Back and forward controls on Grids
- Option for non-pinned Grid Calculations (i.e. always show at position x)
- Grid Calculations can be re-ordered
- New option for member search: "Does not include"
- Support aliasing, to rename dimensions and members
- Option to display member property instead of member caption in all dialogs and results
- "Apply" button on member selector
- Filter measure can be range driven
- Grid Charts: highest level option
- "Order By" member property in advanced sorting
- Outlier Grouping - option to always include a specified member (either in the ranking/filtering or as an additional row)
- Option to format Leaf members in a grid
- New option to select the "Default Member" in member selections
- A new toolbar button on the advanced tab of the member selector
- Grid Ribbon: new option to create grouped members and named sets
Tables
- Support for "OData" datasources
Visualisation
- Cube-based Treemaps: size and colour can be driven from an Excel Range
- Treemaps: Specify formatting of treemaps
- Small multiples: Can apply number format to x and y-axis
- Small multiples: Option to hide border
- Small multiples: data driven x-axis min and max values
- Small multiples: New Bump Charts chart type
- Maps: option to select colour for "Blank" values
- New: SparkHeatMap
- Heatmaps - XL3SparkHeatMap() formula
Slicers
- Workbook Level slicers - taskpane shows common slicers when changing worksheet
- Improved printing from Excel
- Resize and reposition several slicers at the same time
- "Multi-select" option on Combobox slicers
- Option on Button slicers to show members with no-data as "Disabled" button
- Tree slicers can now create a hierarchy from column based hierarchies
- Time Slider slicer type
- "Initial value" can now be a range containing an "MDXSET:"
- Dimension Slicers: Alignment Options
Formulae
- XL3MemberNavigate - new option for "Parent at level"
- Flex Reporting - supports paths from the same hierarchy
- XL3SetProperty - can control a chart's visibility.
- XL3LastCubeUpdate - new "Format" paramter to control date/time format
- XL3DynamicPicture - Option to auto size image
- XL3WebReportLink - support for Sharepoint-based publishing
- XL3Links can be linked to toolbar buttons: "Download to Excel", "Print" etc
SQL
- Centralised connections - all formula take a connection id and any SQL driven objects use the same central connection, so they can be edited under the standard Manage Connections form
- Added support for "Teradata" to the SQL Connection form
Scheduling
- Support for HTML formatting
Web Edition
General
- New improved look and feel
- SQL Repository
- Custom or automatic preview images of reports
- Option to view: Most recent, Most viewed, Popular and Bookmarked reports on the homepage
- Add support for including a custom logo
- Advanced Member searching option
- Web edition connection history can be edited
- From the Options -> FluenceXL Options form
- Retain chart names when saving back into Excel
- Support for Excel data validation
- Mutli-line editing for unlocked cells on the web
- Ctrl+Enter creates a new line
- Connection Mapping support for SQL Connections
- Dependency Explorer - check sheet calculation dependencies from Excel
- New option to Hide Sheet Tabs when publishing
Formulae
- Support for over 70 additional Excel formulae. See the New FluenceXL Web Edition Formulae (Version 8.0) page for details.
- Support for saving reports when viewing them in SharePoint
- Support for adhoc grids
- Support for Analytic Books
- Option to enable Mobile app access to SharePoint published reports
