| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Version 8.1"
(→Visualisation) |
|||
| (19 intermediate revisions by 2 users not shown) | |||
| Line 13: | Line 13: | ||
* Excel "Report Viewer" option - user can't change reports but can run them | * Excel "Report Viewer" option - user can't change reports but can run them | ||
* Show [[Report Designer#Hierarchy Descriptions|Hierarchy Descriptions]] as tooltips in Report Designer | * Show [[Report Designer#Hierarchy Descriptions|Hierarchy Descriptions]] as tooltips in Report Designer | ||
| + | * Ability to set time in seconds before [[XLCubed Options#Data Options|long queries]] will be cancelled | ||
==Grids== | ==Grids== | ||
* Support for [https://msdn.microsoft.com/en-us/library/ms145573.aspx FONT_FLAGS] cube formatting | * Support for [https://msdn.microsoft.com/en-us/library/ms145573.aspx FONT_FLAGS] cube formatting | ||
| − | * [[Active Cell Grid Selections|Active cell tracking]] includes an option to allow clicking on members as well as data cells | + | * [[Active Cell Grid Selections#Track on Member Cells|Active cell tracking]] includes an option to allow clicking on members as well as data cells |
* Additional options to [[Keep Members]] and create sets | * Additional options to [[Keep Members]] and create sets | ||
* Can [[Hierarchy Editor#Copy Existing Member|Copy Existing Member]] selection in [[Member Selector]] | * Can [[Hierarchy Editor#Copy Existing Member|Copy Existing Member]] selection in [[Member Selector]] | ||
* Grids on tabular cubes support [[Grids on tabular cubes#Dynamic Measures|dynamically created measures]]. | * Grids on tabular cubes support [[Grids on tabular cubes#Dynamic Measures|dynamically created measures]]. | ||
| − | * [[Formatting_Grids | + | * [[Formatting_Grids|Member formatting]] will now apply to member properties |
| − | * Ability to [[Formatting Grids|format a member]] based on a member property value | + | * Ability to [[Formatting Grids#Format_by_Member_Property|format a member]] based on a member property value |
* Group members option in [[Hierarchy Editor#Group Members in Member Selector|Member Selector]] | * Group members option in [[Hierarchy Editor#Group Members in Member Selector|Member Selector]] | ||
| − | |||
* Improved [[Set Searching|Advanced member searching]] - can keep added members and running another search without leaving form | * Improved [[Set Searching|Advanced member searching]] - can keep added members and running another search without leaving form | ||
| − | * NonEmpty advanced member selection option | + | * [[Ranking,_Sorting_and_Filtering#Non_Empty|NonEmpty]] advanced member selection option |
==Tables== | ==Tables== | ||
| Line 32: | Line 32: | ||
* Support for more [[Tabular Designer#Advanced filters|DAX table operators]] | * Support for more [[Tabular Designer#Advanced filters|DAX table operators]] | ||
* Support for [[Tabular Designer#Dynamic Measures|dynamically created measures]] | * Support for [[Tabular Designer#Dynamic Measures|dynamically created measures]] | ||
| − | * | + | * [[Table Properties#Formatting|Transpose]] Tables |
==Visualisation== | ==Visualisation== | ||
| Line 45: | Line 45: | ||
** Switch connection | ** Switch connection | ||
** Spacing | ** Spacing | ||
| − | * [[Small Multiples]] - configure drill to level | + | * [[Small Multiples]] - configure [[Small_Multiple_Charts#Drill_Into:_for_a_breakdown_on_the_Column|drill to level]] |
| − | * [[Small Multiples]] | + | * Small Multiples can output [[Small Multiples#Behaviour|Unique Name or Caption]] based on selection |
| − | * [[In-Cell Charts in Grids| | + | * Can [[In-Cell Charts in Grids#Switch Members|Switch Members]] on which In-Cell charts are based |
* [[Format Sheet|Format Sheet]] on network location - warning message if network drive not available | * [[Format Sheet|Format Sheet]] on network location - warning message if network drive not available | ||
==Slicers== | ==Slicers== | ||
| − | * [[Dimension Slicers|Slicer]] | + | * [[Dimension Slicers#Slicer Title from Excel range (new in v8.1)|Slicer Title]] can be driven from Excel range |
==Formulae== | ==Formulae== | ||
| Line 58: | Line 58: | ||
* [[XL3Link]] can set the tooltip | * [[XL3Link]] can set the tooltip | ||
* [[XL3SetProperty]] extended: | * [[XL3SetProperty]] extended: | ||
| − | ** Enable/Disable slicers | + | **[[XL3SetProperty#Slicer|Enable/Disable slicers]] |
| − | ** Switch Small Multiples between more chart types | + | **[[XL3SetProperty#SmallMultiple|Switch Small Multiples]] between more chart types |
* [[XL3SparkDotPlot]] | * [[XL3SparkDotPlot]] | ||
| Line 71: | Line 71: | ||
* [[Customising web config|XLCubedWeb Option]] to display Reports before Sub-folders in repository view | * [[Customising web config|XLCubedWeb Option]] to display Reports before Sub-folders in repository view | ||
* Support for printing header and footer images | * Support for printing header and footer images | ||
| − | * Ability to delete reports from the [[Web | + | * Ability to delete reports from the [[Web HomePage|Web UI]] |
* [[Customising web config|Keep Alive]] option from client browser so session doesn't expire | * [[Customising web config|Keep Alive]] option from client browser so session doesn't expire | ||
| − | * [[Workbook Options | Workbook option]] to set the "Download to Excel/PDF" filename | + | * [[Workbook Options#Web Publication| Workbook option]] to set the "Download to Excel/PDF" filename |
* Warn when leaving a report with unsaved [[writeback]] changes | * Warn when leaving a report with unsaved [[writeback]] changes | ||
* [[Workbook_Options#Web_Publication|Option]] to auto refresh after editing cell value | * [[Workbook_Options#Web_Publication|Option]] to auto refresh after editing cell value | ||
* [[Connection Mapping | Connection mapping]] - option to not unmap when the file is saved to Excel as live | * [[Connection Mapping | Connection mapping]] - option to not unmap when the file is saved to Excel as live | ||
| − | + | * Option to download to Excel any reports that can't be run due to errors, [[Rescue workbook]] | |
| − | * Option to download to Excel any reports that can't be run due to errors | ||
==Formulae== | ==Formulae== | ||
Latest revision as of 11:07, 5 February 2018
What's new in XLCubed Version 8.1
Contents
[hide]Main Additions
- Cube Comments
- Viewports
- Support for SAP HANA connections
General
- Support for "Dynamic" sets in client calculations
- Excel "Report Viewer" option - user can't change reports but can run them
- Show Hierarchy Descriptions as tooltips in Report Designer
- Ability to set time in seconds before long queries will be cancelled
Grids
- Support for FONT_FLAGS cube formatting
- Active cell tracking includes an option to allow clicking on members as well as data cells
- Additional options to Keep Members and create sets
- Can Copy Existing Member selection in Member Selector
- Grids on tabular cubes support dynamically created measures.
- Member formatting will now apply to member properties
- Ability to format a member based on a member property value
- Group members option in Member Selector
- Improved Advanced member searching - can keep added members and running another search without leaving form
- NonEmpty advanced member selection option
Tables
- Option to Prompt for user id and password on Relational connections
- Support for more DAX table operators
- Support for dynamically created measures
- Transpose Tables
Visualisation
- Option to format the text in Treemaps
- Can Switch Chart Type by series for Small Multiple Charts
- More customisation options for Small Multiples:
- Axis titles
- Data Labels
- Background fill
- Marker style on line graph
- Switch connection
- Spacing
- Small Multiples - configure drill to level
- Small Multiples can output Unique Name or Caption based on selection
- Can Switch Members on which In-Cell charts are based
- Format Sheet on network location - warning message if network drive not available
Slicers
- Slicer Title can be driven from Excel range
Formulae
- XL3Link can set the tooltip
- XL3SetProperty extended:
- Enable/Disable slicers
- Switch Small Multiples between more chart types
- XL3SparkDotPlot
SQL
Scheduling
Web Edition
General
- XLCubedWeb Option to display Reports before Sub-folders in repository view
- Support for printing header and footer images
- Ability to delete reports from the Web UI
- Keep Alive option from client browser so session doesn't expire
- Workbook option to set the "Download to Excel/PDF" filename
- Warn when leaving a report with unsaved writeback changes
- Option to auto refresh after editing cell value
- Connection mapping - option to not unmap when the file is saved to Excel as live
- Option to download to Excel any reports that can't be run due to errors, Rescue workbook
Formulae
- Support for XL3Link to trigger "Active Cell Tracking" when linking to a grid
- XLCubedWeb Option to use Report path instead of Guid when embedding SQL Repository reports
Visualisation
- Viewports - an interactive and scrollable control which can display content held in another part of the workbook. Very useful for report layout where one or more data areas can change in size.
- Support for Pattern fills on published charts
- Improved Small Multiple default formatting
- Camera object zooming support
API
- Web API update to support multi-cell parameters
